In this course on Advanced Microsoft Excel 2013, we will be covering advanced functions and features. The course begins with 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. By the completion of this Advanced Excel 2013 training, you will be comfortable with most of the advanced features and functions. Working files are included, allowing you to follow along with the author throughout the lessons.
We will be covering the following modules in this online course on Advanced Excel 2013.
Introduction to Useful Excel 2013 Functions
In this course on Advanced Microsoft Excel 2013, we will be covering advanced functions and features. The course begins with 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. By the completion of this Advanced Excel 2013 training, you will be comfortable with most of the advanced features and functions. Working files are included, allowing you to follow along with the author throughout the lessons.
We will be covering the following modules in this online course on Advanced Excel 2013.
Introduction to Useful Excel 2013 Functions
Data Functions
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