Variance Analysis (Budget vs Actuals) using MS Excel

Variance Analysis (Budget vs Actuals) using MS Excel

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.

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

Url: View Details

What you will learn

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

Rating: 3.9

Level: All Levels

Duration: 1.5 hours

Instructor: Saurav Kumar Agrawal