Course details
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
Updated on 30 December, 2017 - Read Less