Excel Crash Course for Finance and Business Analysts 2020

In this Excel Crash Course, you will learn how to use different excel functionalities to carry out financial calculations, financial analysis together with business analysis and calculations.

This course will help you to be able to use excel functionalities to consolidate and calculate different Profit and Loss statements (income statements).

You will learn how to use cell referencing to enhance your usage of excel for financial and business analysis.

You will have an understanding of how to use excel to value a project, calculate the NPV of a project and determine if the project is viable or not.

You will learn how to use excel functionalities to build dynamic models.

You will learn how to carry out professional formatting.

You will learn how to use important excel tools such as the WHAT IF analysis to carry out sensitivity analysis for better decision making.

You will learn how to use advance excel functionalities such as the V-LOOKUP, THE CHOOSE function, DATA VALIDATION function, CONSOLIDATION function, INDEX AND MATCH function, The IF functionality, etc.