Variance Analysis (Budget vs Actuals) using MS Excel

Interactive analysis of Variance in Budget vs Actuals using waterfall charts and conditional formatting

3.90 (18 reviews)
Udemy
platform
English
language
Finance
category
Variance Analysis (Budget vs Actuals) using MS Excel
119
students
1.5 hours
content
Jun 2021
last update
$34.99
regular price

What you will learn

Conduct 'Variance Analysis' of Profit and Loss (Budget vs Actuals) using waterfall charts and conditional formatting in MS Excel

Description

In this course, we will learn how to look at the Management Profit and Loss Statement and analyse the same for insights from the following lenses:

1.Variance Analysis : How to conduct variance analysis of Management Profit and Loss Statement using the following time periods:

  • Budget (For the Month)

  • Actuals (For the Month)

  • Budget (Year to Date)

  • Actuals (Year to Date)

2.Interactivity : Capability to conduct variance analysis for different time periods at the click of a button

We will use interactive report and waterfall charts to derive insights that will enable decision making by the management.

There are sub topics which will be covered in details before creating the final dashboard. The concepts are as below:

  • HLOOKUP

  • Data Validation

  • SUM using Relative Referencing and Absolute Referencing

  • Waterfall Chart

  • Conditional Formatting for quick insights

  • Detailed understanding of Management Profit and Loss Statement

  • Difference between Management Profit & Loss Statement and Financial Profit & Loss Statement

At the end of the course, we will be able to carry out variance analysis given any two comparative across time dimensions.  And cherry on the cake is the interactivity (using which data across different time dimensions can be analysed at the click of a button). 

This course will give you an edge in terms of the articulation of multi faceted data for simplification and deriving powerful insights in the least amount of time.

Content

Introduction

Introduction

Features & Functions required for the variance analysis

How to use 'Data Validation'?
How to use HLOOKUP for interactivity in Excel?
How to use Absolute and Relative Referencing with SUM function in MS Excel?
How to create Waterfall Chart and use of Linked Picture?

Creation of Final Dashboard

Drawing up schema and basic skeleton of the dashboard
Calculating respective percentages and variances
Waterfall Charts and Complete Dashboard

Reviews

Lily
January 31, 2022
Get to the point, and easy to learn. If there are more ways to present the variance analysis would be better.

Charts

Price

Variance Analysis (Budget vs Actuals) using MS Excel - Price chart

Rating

Variance Analysis (Budget vs Actuals) using MS Excel - Ratings chart

Enrollment distribution

Variance Analysis (Budget vs Actuals) using MS Excel - Distribution chart
4104730
udemy ID
6/6/2021
course created date
6/13/2021
course indexed date
Bot
course submited by