Course Data files download link:
https://www.dropbox.com/s/8d45vgp4379auz1/1.%20Data%20file%20for%20students.xlsx?dl=0
Complete course link:
https://www.udemy.com/course/financial-reporting-analysis-w-ms-excel-powerpivot-dax/?referralCode=F92D95C57DBA2BA871D5
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, Financial Statements, Ratios
- 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
#Accounting #FinancialReporting #Excel #Microsoft Excel #Advanced Excel #FinancialAnalysis