Excel Crash Course for Finance and Business Analysts 2020
Excel Crash Course for Finance and Business Analysts 2020
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 695 MB
Genre: eLearning Video | Duration: 22 lectures (1 hour, 23 mins) | Language: English
A comprehensive and complete Excel crash Course for All Finance and Business Professionals
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 695 MB
Genre: eLearning Video | Duration: 22 lectures (1 hour, 23 mins) | Language: English
A comprehensive and complete Excel crash Course for All Finance and Business Professionals
What you'll learn
You will learn how to use excel functions to perform fincnaial and business analysis
Requirements
non required
Description
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.
Who this course is for:
Finance and Business Analyst, Finance and business students
Excel Crash Course for Finance and Business Analysts 2020
