What you’ll learn:
Financial Reporting
Financial Ratios and Financial Analysis
Visualizing Financial data
Power Pivot & DAX
Requirements:
Basic knowledge of Financial Reports and Ratios
Description:
Reporting and Analysis are the two of the most common tasks that Accountants, Bookkeepers, and Financial Analysts perform on their job. Like most other tasks that we do, yet again Microsoft Excel is the most used software for these tasks.
But, using basic Excel for these tasks is like using a bullock cart for travelling in 2021. Oh yes, using the advanced Excel tools like Power Pivot & DAX, we can completely revolutionize the way we do reporting and analysis.
We can directly connect our database with Excel, automate the data cleaning and transformation of data, prepare cash key financial reports, including financial statements, prepare key insights including ratio analysis, and even prepare visualizations.
And the best part, all of this reporting and analytics can be set up as dynamic, meaning that these reports can be filter for any country, any cost center, or any business segment with just a click of a button.
Well, this is exactly what this course is all about!
In this course you will learning everything that you need to completely transform the way you do you perform your Reporting and Analytics
