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
827
students
6 hours
content
Oct 2019
last update
$13.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)

Course Gallery

Build Excel Models using Advanced Formulas, VBA, Power Query – Screenshot 1
Screenshot 1Build Excel Models using Advanced Formulas, VBA, Power Query
Build Excel Models using Advanced Formulas, VBA, Power Query – Screenshot 2
Screenshot 2Build Excel Models using Advanced Formulas, VBA, Power Query
Build Excel Models using Advanced Formulas, VBA, Power Query – Screenshot 3
Screenshot 3Build Excel Models using Advanced Formulas, VBA, Power Query
Build Excel Models using Advanced Formulas, VBA, Power Query – Screenshot 4
Screenshot 4Build Excel Models using Advanced Formulas, VBA, Power Query

Charts

Students
Price
Rating & Reviews
Enrollment Distribution
1325688
udemy ID
19/08/2017
course created date
15/06/2019
course indexed date
Bot
course submited by