Build Excel Models using Advanced Formulas, VBA, Power Query

Online Course

Udemy

Go to Udemy

Start Learning

What is the course about?
Prerequisites & Facts
Cost, Certificate & Degree
Reviews & Experiences

What is the course about?

Build Excel Models using Advanced Formulas, VBA, Power Query

The course Build Excel Models using Advanced Formulas, VBA, Power Query is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Learn to design robust Excel Models and Dashboards for Reporting and Analytics using Formulas, Excel VBA & Power Query

Course description

Build Excel Models using Advanced Formulas, VBA, Power Query

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

Basics of Double Entry Accounting System
Basics of Microsoft Excel (also basics of Pivot Tables)
A Computer with Microsoft Excel Installed (preferably: 2007 or later versions)

6 hours on-demand video
6 articles
13 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of Completion
Prashant Panchal, ACA

Start Learning

Prerequisites & Facts

Build Excel Models using Advanced Formulas, VBA, Power Query

Course Topic

Excel Modeling, Microsoft, Office Productivity

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

Build Excel Models using Advanced Formulas, VBA, Power Query

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.

Udemy

Build Excel Models using Advanced Formulas, VBA, Power Query

provided by Udemy

Start Learning