Excel 2013 Advanced Training Course

Course details

In this course on Advanced Microsoft Excel 2013, we will be covering advanced functions and features. This Excel 2013 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 in Excel 2013
• 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 in Excel 2013
• How to Print the Pivot Table
• Using Macros In Pivot Tables
• Introduction of Power Pivot
• DAX in Power Pivot in Excel 2013
• Introduction of Power View
• Names and Dynamic Range in Excel 2013
• 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 in Excel 2013
• Assigning Macros to Buttons to Navigate and Dashboard
• Financial functions using Excel
• Future Value, SI, CI, PV, NPER, RATE