Business Excel

•       Menus & Worksheets | Keyboard Shortcuts
•       Working with Cells and Ranges: Formatting Cells, Name Manager
•       Absolute, Relative & Mixed References
•       Setting up a database | Data Formatting & Cleaning
•       Conditional Formatting | Sparkline Graphics (In Cell Charts)

VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, COUNTIF, COUNTIFS, IF, IFERROR, OR, AND, INDEX, MATCH, CONCATENATE, Array Formulas, Random Number Generation.

Tables and Structured References, Formulas for Financial Applications

Auto Filter – Multiple and Advanced Filter, Data Validation
Sorting Data – Multiple Sorting – Generating Subtotals & Formatting
What If Analysis – Data Table – Scenario Manager – Goal Seek & Solver

Creating, Formatting and Modifying Chart – Building Primary and secondary Axis chart – Working with various Charts. Setting up page – previewing and Printing.

Introduction to Macros – Recording Macros – Running Macros using menu command – Assigning a Keyboard shortcut – Assigning macro to a toolbar, menu or button

Create Database for Pivot, Analysing Data with Pivot Tables, Data Crunching, Report generation, Slicers, Creating Automated Reports, and Interactive Excel Dashboards & GETPIVOTDATA.

Introduction to Power Query, Power Pivot & Power BI