1. Course Intro for Advanced Excel Training
Build Excel Models using Advanced Formulas, VBA, Power Query
Course overview
What you'll learn
-
Advanced Formulas and Functions to prepare Accounting Schedules (such as prepaid expenditure) and many other amortisation models
-
How to leverage an awesome data transformation tool called Power Query (Get & Transform)
-
How to Manage Prepaid Expenses accounting professional way (or any other amortisation schedule)
-
How to Forecast and Budget Prepaid Expenses and its impact on three Financial Statements
-
Maintaining the utmost accuracy while closing month-end books (Accountants) for Prepaid Expenditures
-
Dynamic Data Visualization and Dashboard Preparation using Formulas and Functions
-
Dynamic Dashboards and Data Visualization with Power Query (Next level Data modelling tricks)
Your feedback is important, and helps your course provider to improve. Share your thoughts by leaving a review.
Hey, This is the ExActProBi team. We like helping fellow Accountants , Auditors and Analysts to become PRO at using Microsoft Excel . I ... Read more