This course starts from scratch. So, even if you are a starter in Excel 2013, you will get it in this course. By the completion of this Comprehensive Microsoft Excel 2013 training, you will be comfortable with most of the powerful features and functions of Excel 2013. Working files are included, allowing you to follow along with the author throughout the lessons.
This course begins with taking care of all excel functions and formulas in a comprehensive manner with lots of examples and case studies. To make you understand the importance of Excel in our day to day life, the course starts with a case study and how that case study is being taken completely on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sumif, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. Then, the course will take you through some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table has been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course.
This course is ideal for Students, MBA’s, BBA’s, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker. There is no Pre-requisite to this course. A complete beginner can start with this course. Our objective with this course is to make you understand what excel is and to know its importance in the current business world. The only requirement from you is to be passionate to learn, be committed to the training and invest your time.
This course starts from scratch. So, even if you are a starter in Excel 2013, you will get it in this course. By the completion of this Comprehensive Microsoft Excel 2013 training, you will be comfortable with most of the powerful features and functions of Excel 2013. Working files are included, allowing you to follow along with the author throughout the lessons.
This course begins with taking care of all excel functions and formulas in a comprehensive manner with lots of examples and case studies. To make you understand the importance of Excel in our day to day life, the course starts with a case study and how that case study is being taken completely on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sumif, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. Then, the course will take you through some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table has been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course.
This course is ideal for Students, MBA’s, BBA’s, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker. There is no Pre-requisite to this course. A complete beginner can start with this course. Our objective with this course is to make you understand what excel is and to know its importance in the current business world. The only requirement from you is to be passionate to learn, be committed to the training and invest your time.
We will be covering the following modules in this online course on Comprehensive Microsoft Excel 2013.
·Overview
·Getting Started
·Case Study
·Data Entry
·Calculations
·Formulas
·Formatting
·Formatting Table formats
·Updating a Calculation
·Percentages & Absolute References
·Conditional Formatting
·IF Function
·COUNTIF
·SUMIF
·Graphs & Charts
·Pie Chart
·Sorts
·Filter Function
·Pivot table
·Freeze & Split
·Presentation
·Print
·Shortcuts
·Common errors
·What If Analysis
·Arrays
·Functions for Working with Text
·Excel 2013 - Pivot Table
·Summarizing Data Using Pivot Table
·Data Filtering
·Basics Pivot Table Formatting
·Advanced Pivot Table Formatting
·Introduction of Pivot Chart
·How to Print the Pivot Table
·Using Macros In Pivot Tables
·Introduction of Power Pivot
·DAX in Power Pivot
·Introduction of Power View
·Names and Dynamic Range
·Auditing and Trouble Shooting Formulas
·Important Excel Tools
·Excel 2013 - Charts & Graphs
·Chart Concept
·Basic Chart
·Fine Tuning of Charts
·Chart Options
·Format Tab
·Adjustment of Specific Chart Types
·Changing Chart Sources
·Specialised Charts & Graphs
·Excel 2013 - Excel Dashboard
·Creating Basic Charts
·Learning Pivot Table, Pivot Chart and Slicer
·Using Form Controls
·Basic Macros
·Assigning Macros to Buttons to Navigate and Dashboard
·Financial functions using Excel
·Future Value, SI, CI, PV, NPER, RATE
Show more
New Zealand
United Kingdom