Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.
This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research, and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you've mastered them. This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis.
1-Setting Up a Workbook
2- Working with Data and Excel Tables
3- Performing Calculations on Data
4- Changing Workbook Appearance
5- Focusing on Specific Data by Using Filters
6- Reordering and Summarizing Data
7- Combining Data from Multiple Sources
8- Analyzing Alternative Data Sets
9- Creating Dynamic Worksheets by Using Pivot Tables
10- Creating Charts and Graphics
12- Automating Repetitive Tasks by Using Macros
13- Working with Other Microsoft Office Programs