Microsoft Excel Fundamentals for Analysts
This Course covers the technical Excel Skills required of a Financial Analyst. After this course you will be able to confidently use Excel to analyse data, build models and provide the required outputs needed for effective data driven decisions.(22) 4.9 average rating
Report Automation in Modern Excel
Learn a powerful methodology to automate any report & dashboard in Excel (with no VBA) & watch it update all by itself every minute.(5) 5.0 average rating
Lookup Functions in Excel
Learn to Master the inner workings and correct for the limitations of the core lookup functions: VLOOKUP, INDEX, MATCH, OFFSET, CHOOSE and more(1) 5.0 average rating
Scenario & Sensitivity Analysis Master Class
Learn how to enhance reporting & Analytics in your models with scenario & sensitivity analysis best practices in Excel
Time Value of Money Calculations in Excel
Every financial calculation is a time value of money calculation. This course uses the Retirement Problem to teach how to work with Excel's Finance Functions.
Depreciation Calculations in Excel
Depreciation Calculations are usually a tedious exercise when building models. Here we show advanced Excel techniques to do it right.