Excel and Advanced Excel

Course Overview:

Advanced Excel users know how to gather, structure & present their data so that it looks impressive. Good understanding of Excel features like Power Query, Tables, cell styles, formatting options is necessary to make awesome Excel workbooks.

Course Content: 

Introduction

♦ Using Excel lists

♦ Creating a List

♦ Sorting

♦ Managing Windows

♦ Multiple Windows

♦ Splitting Windows

♦ Freezing Panes

♦ Linking Data

♦ Macros

♦ Printing Excel files

♦ Managing Excel files

♦ Grouping and outlining data

♦ Shortcut keys and references

♦ Analysis tool pack

♦ Analysis by goal seek

♦ Analysis by pivot tables.

Formulas & Functions

♦ INDEX and MATCH

♦ IF with AND / OR

♦ OFFSET combined with other functions

♦ CHOOSE for creating scenarios

♦ INDIRECT combined with other functions

♦ XNPV and XIRR

♦ CELL, COUNTA and MID functions combined together

♦ PMT, IPMT and principal payment calculations

Data Analysis 

♦ Data tables

♦ Pivot tables

♦ Column and line charts

♦ Stacked column charts

♦ Waterfall charts

♦ Gauge charts

Advance excel

♦ Learn everything you need to be a world-class financial analyst

♦ Received advanced Excel spreadsheet training

♦ Master advanced formulas and functions

♦ Create sophisticated outputs for financial analysis, including beautiful tables, charts,  and graphs

♦ Easy to follow video-based tutorials and lessons