Learn advanced formulas, functions and financial analysis to be an Excel power user. This course is designed for proficient spreadsheet users looking to take their skills to the next level.

You will set up a template to structure an intelligent design for financial analysis. By using advanced functions, you will build financial statements and perform analysis. Once complete, you’ll create data tables and pivot tables to display information and charts and graphs to show results. To speed up analysis, you’ll record macros, and create additional user interfaces.


By the end of this course, you will be able to:

  • create auto-updating Excel spreadsheets
  • build dynamic financial statements
  • perform financial analysis
  • draw on advanced functions for insightful analysis


Financial analysts and other finance professionals working in investment banking, equity research, corporate development, financial planning and analysis (FP&A).