Name: Advanced Excel Modelling Course with Formulas, VBA, Power Query
Price: 299 GBP
Rating: 4.6 (7 reviews)

Overview

Excel is one of the most popular applications of today’s time. It contributes not only to the business world but also to education and personal data organisation. Grasp the most common yet highly demanding skills of all time with our Advanced Excel Modelling Course with Formulas, VBA, Power Query course.

The Advanced Excel Modelling Course with Formulas, VBA, Power Query course is a popular course prepared to help the learner build the exceptional skills of Excel software for their personal and professional life. Excel works as part and parcel of our life due to our dependency on it for either our business activities or jolting daily lists. Discover and master the excel formulas, models, amortisation calculation, power query and pivot table usage, and many more with our highly crafted and latest course modules.

The course is divided into ten modules with several short videos expected to be complete in 6 hours and 8 minutes. Enjoy an uninterrupted learning experience with a one-year access validity to the course materials and gain an authorised certificate.

Join today and excel the Excel sheet effortlessly.

Aims & Goals Of Canadian Tax Accounting Course

From the Advanced Excel Modelling Course with Formulas, VBA, Power Query course, you will:

Discover the advantages and disadvantages of prepaid expenses
Learn about the Date Function EOMONTH, DATEVALUE, IF functions etc.
Get familiarised with the model and control panel tab
Learn about data validation controls
Be able to use array formulas

What Inside?

Who is this course for?

Freshers
Corporate personnel
IT professionals
Individual seeking resourceful skills for career advancement

Career possibilities

Having formally recognised skills will give you a head start in your career. By completing our Advanced Excel Modelling Course with Formulas, VBA, Power Query course, you can add significant value to your CV and career prospects.

Requirements

The Advanced Excel Modelling Course with Formulas, VBA, Power Query course is open to all. There are no specific requirements and you can take the course from anywhere in the world. The course is accessible via any modern device with an internet connection and you can study at your own pace.

Certification

After successfully completing the course by passing the assessment, you will be qualified to get a CPD accredited certificate. We provide both PDF and hardcopy certificates.

You can get a PDF certificate for £4.99, hardcopy certificate for £9.99 and both for only £11.99.

Review

COURSE REVIEWS

Course Reviews

4.6

4.6

7 ratings

5 stars0
4 stars0
3 stars0
2 stars0
1 stars0

No Reviews found for this course.

Related Courses

SAGE 50 Payroll: Beginner to Advanced
~~$511.29~~ $85.50
50
4.9
Business Strategy Planning for Beginner to Advanced
$511.29
63
4.7
Banking and Finance Accounting with Financial Modelling
$511.29
58
4.7
6 Figure Business Course for Beginners
$511.29
61
4.7
Investment Banking for Startups
$511.29
58
4.9
Data Analysis - Hands On Training
$511.29
61
4.7

Related Courses

SAGE 50 Payroll: Beginner to Advanced
~~$511.29~~ $85.50
50
4.9
Business Strategy Planning for Beginner to Advanced
$511.29
63
4.7
6 Figure Business Course for Beginners
$511.29
61
4.7

Introduction
	Course Outline and Introduction	00:04:00
	Minimum Requirements for the Course	00:01:00
Prepaid Expenses Models: Resources Download
	Prepayments Introduction	00:01:00
	Month End Date Prepaid Expenses Amortization Calculation	00:00:00
	Exact Prepaid Expenses Payment Date Calculation	00:00:00
Accounting for Prepaid Expenses
	Prepaid Expenses Accounting Definition: Prepayments	00:03:00
	Prepaid Expense Example: How Accounting works for Prepayments	00:03:00
	Advantages and Disadvantages of Prepaid Expenses	00:03:00
Excel Formulas Detailed: Introduction to three Excel Models
	Introduction to PRO Excel Models and Formulas	00:06:00
	Date Function	00:05:00
	EOMONTH Function	00:04:00
	DATEVALUE function	00:03:00
	IF Function	00:08:00
	IFS Function (Office 365 Only)	00:07:00
	VLOOKUP Function	00:07:00
	MATCH Function	00:05:00
	INDIRECT Function	00:02:00
	NAMED Ranges: Name Manager	00:03:00
	Advanced Version of VLOOKUP Function	00:07:00
Formula Based Prepaid Expenses Model
	Introduction to Model and Control Panel Tab (Important Sheet Tab)	00:08:00
	Formula Based Prepaid Expenses Model – Deep Dive (Part 1)	00:05:00
	Formula Based Prepaid Expenses Model – Deep Dive (Part 2)	00:06:00
	Formula Based Prepaid Expenses Model – Deep Dive (Part 3)	00:06:00
	IFS Function – Month End date Prepayment calculation	00:04:00
	Prepaid Expenses – Closing Balance Summary Tab (Formula Based Summary)	00:09:00
	Protecting Formulas Cells and Fields in the Model	00:04:00
Calculate Prepaid Expenses Amortisation from Exact Start Date
	Exact Date Prepaid Amortisation calculation Intro	00:03:00
	Formulas update and Model Changes for Exact Prepaid Exps Calculation	00:03:00
	Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1)	00:04:00
	Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2)	00:03:00
	Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3)	00:02:00
	Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4)	00:07:00
	IFS Function – Exact Date Prepayments Amortisation	00:04:00
	Data Validation Controls (Enhancing Data Input Controls with Protection)	00:10:00
	Bonus: Prepayment Model with Opening Balance Calculation (Part 1)	00:08:00
	Bonus: Prepayment Model with Opening Balance Calculation (Part 2)	00:09:00
	Additional Material: Resources	00:00:00
Prepaid Expenses Summary with Power Query and Pivot Table
	Power Query and Pivot Table Prepayment Summary Table Intro	00:06:00
	What is Power Query and Some Awesome Resources for Power Query learning	00:10:00
	Power Query and Pivot Table Summary – Deep Dive (Part 1)	00:05:00
	Power Query and Pivot Table Summary – Deep Dive (Part 2)	00:04:00
	Power Query and Pivot Table Summary – Deep Dive (Part 3)	00:05:00
	Power Query and Pivot Table Summary – Deep Dive (Part 4)	00:09:00
	Using Array Formulas to Add Formula Protection	00:04:00
	Bonus: Allocate Prepaid Expenditure Cost Centre Wise – 1	00:02:00
	Bonus: Allocate Prepaid Expenditure Cost Centre Wise – 2	00:08:00
	Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version)	00:13:00
Advanced VBA Prepaid Expenses Amortisation Model
	Changing Macros Security in Excel	00:05:00
	Complete Walkthrough – Advanced VBA Prepaid Expenses Amortisation Model	00:06:00
	Bonus : New Version – Excel VBA Model for Prepayment Expenditure	00:08:00
BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way
	Dynamic Dashboard Overview	00:07:00
	Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets	00:08:00
	Creating Dynamic Data Validation	00:02:00
	Creating Named Ranges for Dynamic Table Arrays	00:03:00
	Dynamic Date Column Headings for each Divisional PL Table	00:02:00
	Dynamic Month and YTD Dashboard tables headings (PRO TIP)	00:03:00
	Dynamic VLOOKUP Formula – Preparing First section of the Dashboard	00:04:00
	Creating Rolling Dashboard with Dynamic VLOOKUP Function	00:08:00
	IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP)	00:03:00
	Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function)	00:05:00
	Visualization: AREA Charts for Month – Revenue, Gross Profit and Net Profit	00:05:00
	Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1)	00:03:00
	Visualization: DONUT Charts: Revenue, Gross Profit and Net Profit (Part 2)	00:06:00
Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic
	Introduction – Formula-less Dashboard – Fully Dynamic and easily refreshed	00:05:00
	Understanding the data files before building dashboard	00:02:00
	Consolidating Reports with Power Query (Get & Transform) , How to install PQ	00:08:00
	Dynamic File Path Trick in Power Query with Parameters (Amazing trick)	00:06:00
	Conditional Cumulative totals with SUMIFS Function	00:04:00
	Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code)	00:06:00
	Dashboard Creation – Pivot Table showing Month and YTD KPIs division wise	00:06:00
	Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast)	00:08:00
	Dashboard Creation – Line Charts	00:08:00
	Update Dashboard with Additional Divisional Data with Few Click (Magical)	00:03:00
Thankyou
	Thank you	00:02:00
	Ultimate Prepaid Expenditure Model (Super Bonus)	00:02:00

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Advanced Excel Modelling Course with Formulas, VBA, Power Query

Course Curriculum

Overview

Aims & Goals Of Canadian Tax Accounting Course

What Inside?

Who is this course for?

Career possibilities

Requirements

Certification

COURSE REVIEWS

Course Reviews

4.6

Related Courses

SAGE 50 Payroll: Beginner to Advanced

Business Strategy Planning for Beginner to Advanced

Banking and Finance Accounting with Financial Modelling

6 Figure Business Course for Beginners

Investment Banking for Startups

Data Analysis - Hands On Training

Related Courses

SAGE 50 Payroll: Beginner to Advanced

Business Strategy Planning for Beginner to Advanced

6 Figure Business Course for Beginners

This course includes

Certificate Code

LOGIN

Advanced Excel Modelling Course with Formulas, VBA, Power Query

Course Curriculum

Overview

Aims & Goals Of Canadian Tax Accounting Course

What Inside?

Who is this course for?

Career possibilities

Requirements

Certification

COURSE REVIEWS

Course Reviews

4.6

Related Courses

Related Courses

This course includes