Course Description :-
This course has been specifically designed to understand the advanced features of Microsoft excel 2013. This course will give you an in depth understanding of the most important functions in Microsoft excel and give you a complete hand on experience of working on the same with the necessary practical working files.
This training is a combination of learning data functions, what if analysis, arrays, functions for working with text. The next module specifically focuses on the Pivot table where you will learn how to summarize the data using pivot tables, its formatting and Pivot charts. Next we focus on another important feature in excel which is charts and Graphs, creating an excel dashboard right from scratch and also learn various financial Functions in this course.
By the closure of this Advanced Excel 2013 training, you will be comfortable using most of the excel functions and features. Working files are included with the tutorials enabling the participants to trail along with the author throughout the modules. We will be covering the following sections 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
Fine Tuning of Charts
Chart Options
Format Tab
Adjustment of Specific Chart Types
Changing Chart Sources
Specialized Charts & Graphs
Excel 2013 – Excel Dashboard
Creating Basic Charts
Learning Pivot Table, Pivot Chart and Slicer
Using Form Controls
Macros in Excel 2013
Assigning Macros to Buttons to Navigate and Dashboard
Financial functions using Excel
Future Value, SI, CI, PV, NPER, RATE
What are the pre-requisites for the Excel 2013 Advanced Training Course?
Basic knowledge of using Microsoft excel 2013
A computer with Internet
Passion to learn
What am I going to get from this Excel 2013 Advanced Training Course?
More than 11 hours of content
Hands-on experience of learning important excel features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table
Understand important excel applications such as creating Charts and Graphs, Dashboard and Financial Functions in this course
Gain command over powerful features and functions in Excel 2013
Who should take up this Excel 2013 Advanced Training Course?
Users who have completed Microsoft Excel 2013 Beginner course
Professionals and Students
Finance Professionals in the domain of Investment Banking and Equity Research
Anyone interested in more powerful features and functions of Excel 2013
Benefits of online course:
1. High Quality Content
2. Learn Anywhere Anytime & at Your Pace
3. 24X7 Customer Support
4. Complete Student Support Throughout The Program
5. Online Video Training Material
6. Lifetime course access
For any Query feel free to call
Mob-+918587999769/9818826705
Curriculum
Section 1: Introduction to Useful Excel 2013 Functions
Section 2: Data Functions
Section 3: What If Analysis
Section 4: Arrays
Section 5: Functions for Working with Text
Section 6: Excel 2013 - Pivot Table
Section 7: Summarizing Data Using Pivot Table
Section 8: Data Filtering
Section 9: Basics Pivot Table Formatting
Section 10: Advanced Pivot Table Formatting
Section 11: Introduction of Pivot Chart
Section 12: How to Print the Pivot Table
Section 13: Using Macros In Pivot Tables
Section 14: Introduction of Power Pivot
Section 15: DAX in Power Pivot
Section 16: Introduction of Power View
Section 17: Names and Dynamic Range
Section 18: Auditing and Trouble Shooting Formulas
Section 19: Important Excel Tools
Section 20: Excel 2013 - Charts & Graphs
Section 21: Chart Concept
Section 22: Basic Chart
Section 23: Fine Tuning of Charts
Section 24: Chart Options
Section 25: Format Tab
Section 26: Adjustment of Specific Chart Types
Section 27: Changing Chart Sources
Section 28: Specialized Charts & Graphs
Section 29: Excel 2013 - Excel Dashboard
Section 30: Creating Basic Charts
Section 31: Learning Pivot Table, Pivot Chart and Slicer
Section 32: Using Form Controls
Section 33: Macros
Section 34: Assigning Macros to Buttons to Navigate and Dashboard
Section 35: Financial functions using Excel
Section 36: Future Value, SI, CI, PV, NPER, RATE
