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