Transform the way you perform Financial Reporting and Analysis with Excel Power Pivot & DAXWhat 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.

Prerequisites:

Basic knowledge of Accounting/Bookkeeping, financial statements, and ratios is required.

Basic knowledge of Excel will be helpful.

Who should take this course:

Accountants and Bookkeepers

Finance professionals

Financial Analysts

Business Analysts

Finance Managers

Financial Controllers

Business Leaders

Software Requirement:

Any version of Microsoft Excel 2010 or later.

Who this course is for
Financial Analysts
Business Analysts
Finance Managers
Financial Controllers
Accountants
Bookkeepers
Accounting & Finance students