Build Excel Models using Advanced Formulas, VBA, Power Query

Design Robust Excel Models for Accounting and Reporting, learn to Build Automated Dashboards using Power Query and VBA
4.51 (53 reviews)
Udemy
platform
English
language
Microsoft
category
Build Excel Models using Advanced Formulas, VBA, Power Query
826
students
6 hours
content
Oct 2019
last update
$54.99
regular price

What you will learn

Advanced Formulas and Functions to prepare Accounting Schedules (such as prepaid expenditure) and many other amorisation models

How to leverage 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 modeling tricks)

Screenshots

Build Excel Models using Advanced Formulas, VBA, Power Query - Screenshot_01Build Excel Models using Advanced Formulas, VBA, Power Query - Screenshot_02Build Excel Models using Advanced Formulas, VBA, Power Query - Screenshot_03Build Excel Models using Advanced Formulas, VBA, Power Query - Screenshot_04
1325688
udemy ID
8/19/2017
course created date
6/15/2019
course indexed date
Bot
course submited by