• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Plan v Actual Excel Dashboard

You are here: Home / Excel Dashboard / Plan v Actual Excel Dashboard
act v plan dashboard
August 11, 2020 by Mynda Treacy

Reporting on plan v actual variances can be a very dry topic and often the audience for these reports are not from a financial background. To aid business management, we can create visually appealing interactive reports like the plan v actual Excel dashboard below.

plan v actual excel dashboard

It needn’t be a lot of work either. This dashboard can be constructed in just over 30 minutes, as demonstrated step by step in the video below. And once built, it can be updated with the click of one button!

Watch the Video

Subscribe YouTube



Trustpilot


Download Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook and follow along. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Plan v Actual Excel Dashboard Techniques Used

I used several techniques to build this dashboard and you’ll find links to the individual tutorials on these topics below:

  1. Excel Tables
  2. PivotTables
  3. GETPIVOTDATA function
  4. Pivot Charts
  5. Slicers
  6. TEXT function
  7. Conditional Formatting with Formulas
  8. Custom Number Formats
  9. Excel Icons

Learn More

The topics above are a great start, but if you’d like to take your Excel skills further, please consider our courses below:

Excel Dashboards Course – A comprehensive course designed to give you the skills to build dashboards for any industry.

Excel PivotTable Quick Start – this course will help you overcome your fears and challenges with building PivotTables. It’ll have you up and running in under 2 hours.

Excel Advanced Formulas - I’ve designed this course to get you quickly up to speed with the functions that are going to give you the biggest efficiency gains. Many of the functions are considered advanced, but when you’ve finished the course, you’ll know like I do, that everything is easy once you know how.

Excel Expert Course – This course includes the PivotTable Quick Start and Advanced Formulas course as well as a load more topics covering everything from beginner topics (which you can skip if you already know them) to more advanced topics.

Power BI Course - Power BI offers functionality we can only dream of in Excel. Including secure sharing of reports on any device, clickable chart elements that cross filter and highlight other charts, and much more.

act v plan dashboard

More Excel Dashboard Posts

excel infographic tools

Excel Infographic Tools

Excel infographic tools are many and varied. In this tutorial I take you through step by step building an Excel infographic.
ai dashboard design

AI Dashboard Design

AI dashboard design can give you some great ideas for design and color combinations, but it’s not smart enough to create useful reports…yet!
dark theme dashboards

Dark Themed Excel Dashboards

Dark Themed Excel Dashboards enable you to use formatting techniques that make your data pop and get your audience's attention.
excel dashboards custom backgrounds

Custom Excel Dashboard Backgrounds

Custom Excel Dashboard Backgrounds bring a level of polish and professionalism to reports and they’re super easy to create using PowerPoint

Embedding Excel Dashboards in a Web Page

Embedding Excel Dashboards in a Web Page from files on SharePoint or OneDrive for Business or OneDrive Personal.
excel student performance dashboard

Excel Student Performance Dashboard

How to build an Excel student performance dashboard from scratch. Download the completed Excel file for reference.
5 Pro excel dashboard design tips

5 Pro Excel Dashboard Design Tips

Excel Dashboard Design Tips you can use in both Excel and Power BI to ensure your reports and quick and easy to read.
excel interactive personal finance dashboard

Interactive Personal Finance Dashboard

Excel Interactive Personal Finance Dashboard to help you visualise and keep track of and manage where you’re spending your money.

Non-financial Excel Dashboards

Step by step how to build Excel Dashboards with non-financial data. Uses Power Query and Power Pivot to visualise NASA data.

Secrets to Building Excel Dashboards in Under 15 Minutes

Learn how to build interactive, clean and focussed dashboards that communicate the important information you want readers to know.


Category: Excel Dashboard
Previous Post:Connecting to an OAuth API Like PayPal With Power QueryConnecting to an OAuth API Like PayPal With Power Query
Next Post:Import Data from a PDF to ExcelImport Data from a PDF to Excel

Reader Interactions

Comments

  1. MT

    December 26, 2021 at 6:38 am

    always neat lectures.. I’m excited to go back and practice the basic excel tricks to create dashboards and then power things up.

    Reply
    • Mynda Treacy

      December 26, 2021 at 2:00 pm

      Great to hear!

      Reply
  2. Harry

    November 13, 2021 at 5:12 pm

    Hello , my name Harry from Indonesian student, i have office 2016 in my PC desktop, can i use Excel 2016 to learning Plan v Actual Excel Dashboard , i want try to follow your video in Excel 2016.

    Thanks for advice

    Regards,
    Harry

    Reply
    • Mynda Treacy

      November 13, 2021 at 7:27 pm

      Hi Harry, Yes, you can build this dashboard with Excel 2016.

      Reply
  3. Paul Paul

    July 1, 2021 at 4:06 am

    Hi,

    How do you link slicer connection if i have more than 2 data table sources?

    Reply
    • Mynda Treacy

      July 1, 2021 at 9:33 am

      Hi Paul,

      If you have multiple source tables then you must use Power Pivot (the data model) and create relationships between the tables (usually via a dimension table). If you’d like to learn how to use Power Pivot, please consider my Power Pivot course.

      Mynda

      Reply
  4. Genevè

    June 23, 2021 at 4:33 am

    Hi,
    Exactly what I need but am not sure how to go forward with this. What if the plan is based on COA mapping. So let’s say for the whole year, you have a budget of 100k on Cleaning and 50k on Cleaning Consumables. In January, you receive an invoice from supplier for Cleaning and for a period of 3 months (quarterly) and 3 invoices for Consumables (varies every month). What is the easiest way divide/split yearly budget each month on that sheet? I think I missed that information on your video. Would be nice how if you can show the input on the Data tab., Thanks.

    Reply
    • Mynda Treacy

      June 23, 2021 at 10:00 am

      Hi Geneve,

      My data is already split by month, so there is no need to do this in the tutorial. If your budget is rolled up to the total value for the year then you can use Power Query to split it. I don’t have any blog posts I can point you to, but I cover this in my Power Query Course.

      Mynda

      Reply
  5. ahm

    June 21, 2021 at 5:41 am

    Can you provide supply chain dashboard?

    Reply
    • Mynda Treacy

      June 21, 2021 at 9:33 am

      I don’t have any supply chain dashboards, sorry. If you have some data I can use then I can try to make one as an example tutorial.

      Reply
  6. Henok woldegiorgis

    June 16, 2021 at 4:19 pm

    you have done nicely

    Reply
    • Mynda Treacy

      June 16, 2021 at 7:29 pm

      Glad it was helpful, Henok!

      Reply
  7. Roy Castro

    May 15, 2021 at 6:11 am

    Very cool.

    Reply
    • Mynda Treacy

      May 15, 2021 at 1:33 pm

      Glad you liked it, Roy!

      Reply
  8. Matthew Carlson

    April 28, 2021 at 1:56 am

    I have the data. Would you or your team build a dashboard or is that something that you guys do not do?

    Reply
    • Mynda Treacy

      April 28, 2021 at 8:44 am

      Hi Matthew, I don’t do consulting, but I’ll email you with the contact details for a consultant who can help.

      Reply
  9. Peter

    March 28, 2021 at 7:38 am

    How can I download actual excel workbook? I can’t se the link

    Reply
    • Mynda Treacy

      March 28, 2021 at 9:56 am

      When you enter your email address the download link becomes available on the page.

      Reply
      • Ramesh

        April 10, 2021 at 10:56 pm

        Not able to down load the Excel data file? How do I get it?

        Reply
        • Mynda Treacy

          April 11, 2021 at 11:15 am

          Hi Ramesh, you enter your email address to reveal the download links on this page.

          Reply
  10. Salah Abdeldayem

    March 25, 2021 at 7:01 pm

    Excellent course, short but comprehensive and direct to the point, well done and appreciated.

    Reply
    • Mynda Treacy

      March 25, 2021 at 8:59 pm

      Glad it was useful, Salah!

      Reply
  11. SIMON

    December 26, 2020 at 9:50 am

    Hi,

    As a financial controller, I am looking for a file that can help me for my month end closing.
    Typically, once the accounting team have performed their entries, I am downloading the actuals periodically and year to date. From this, I am then inserting the data as Pivot Table to understand the trends BU per BU or Account by account, company by company etc…This is the step when I am reviewing my accruals, and see if there could be a missing accrual or an entry to reclass etc..

    Ideally, I have seen once a kind of Pivot (fully loaded of VBA) that enabled to insert value in an inserted column of a pivot that was then updating its own database.
    (E.G: You manually input 10€ in the pivot column and this creates the right reference line in the database).
    Do you have a similar way to proceed something like that (using a pivot as visualizing but active tool as well when you aiming to insert Forecast also for instance) ?

    Reply
    • Mynda Treacy

      December 27, 2020 at 12:57 pm

      Hi Simon,

      I don’t have any templates that would allow you to enter a value into a PivotTable and then update a database, sorry. This sounds like a bespoke application that someone has developed for this specific purpose.

      Mynda

      Reply
  12. Peter Booysens

    December 23, 2020 at 3:33 pm

    Thank you for all the help.

    This is much appreciated.

    Reply
    • Mynda Treacy

      December 23, 2020 at 3:54 pm

      Glad it was helpful, Peter!

      Reply
  13. John Redden

    December 18, 2020 at 7:07 am

    If you only knew how long I have been trying to learn this. You make it to the point and easy to learn. Thanks so much and Merry Christmas

    Reply
    • Mynda Treacy

      December 18, 2020 at 9:18 am

      So pleased you found it helpful, John!

      Reply
  14. FREDERIC DURAND

    December 9, 2020 at 4:32 am

    Many thanks it is really helpful, clear and fast to apply 🙂

    Reply
    • Mynda Treacy

      December 9, 2020 at 10:51 am

      Great to hear, Frederic!

      Reply
  15. Irina

    November 26, 2020 at 4:49 am

    This is a great video. Exactly what I was looking for. You are inspiring me to do a dashboard course.

    Reply
    • Mynda Treacy

      November 26, 2020 at 8:43 am

      Great to hear, Irina! Please consider my Excel Dashboard course.

      Reply
  16. Marina

    November 7, 2020 at 3:25 pm

    This course is awsome! Thank You very much for all your knowleadge!!!

    Reply
    • Mynda Treacy

      November 7, 2020 at 8:26 pm

      So pleased you enjoyed it, Marina!

      Reply
  17. Adonna Garrett

    September 25, 2020 at 6:58 am

    Great videos! So glad I found you all. Have you ever done a tutorial on doing a zero based budget template for a corporations? ZBB is making a come back and not a lot out there on using it in a larger scale, just for personal finances.

    Reply
    • Mynda Treacy

      September 25, 2020 at 11:02 am

      Thanks, Adonna! I haven’t done anything on zero based budgeting. Back in my investment banking days that was a big part of my role, but I haven’t done any budgeting for a long time! I’d have thought it would be very difficult to build a one size fits all template for budgeting as it’s so unique to each business.

      Reply
  18. Kiran Mane

    September 24, 2020 at 11:18 am

    Hi
    Just saw your video on YouTube..it was nice..!!awesome..!!

    Can it be published to web so that end user can access the dashboard easily ?

    Reply
    • Mynda Treacy

      September 24, 2020 at 2:15 pm

      So pleased to hear you found the video helpful! You can use the Excel WebApp to embed the Dashboard in a web page.

      Reply
  19. Abdellatif Abdalla Elfaki Ibrahim

    August 18, 2020 at 7:12 pm

    That is great

    Reply
    • Mynda Treacy

      August 18, 2020 at 7:21 pm

      Glad you found it useful 🙂

      Reply
  20. Monica

    August 18, 2020 at 8:40 am

    Hi Mynda
    Another great post, so well presented. Thanks for your helpful tutorials!

    One request – would you be able to fix the link to the excel file so I can download it?

    Reply
    • Mynda Treacy

      August 18, 2020 at 8:56 am

      Thanks, Monica! There’s nothing wrong with the link to the file. If you’re getting an error please get in touch via email (website at MyOnlineTrainingHub.com) so we can help you troubleshoot.

      Reply
  21. klin hong

    August 12, 2020 at 9:39 pm

    it’s a pretty good video.want to learn it.

    Reply
    • Mynda Treacy

      August 13, 2020 at 8:42 am

      Glad you enjoyed it, Klin 🙂

      Reply
  22. Ken McMillan

    August 12, 2020 at 2:50 am

    Awesome job as usual! I love your lightning speed!

    Reply
    • Mynda Treacy

      August 12, 2020 at 8:53 am

      Thanks so much, Ken!

      Reply
  23. James

    August 12, 2020 at 1:50 am

    When I enable editing, it does not allow me to save the dashboard to modify. Can you fix this?

    Reply
    • Mynda Treacy

      August 12, 2020 at 8:55 am

      Hi James, there’s no security on this file and you shouldn’t need to ‘enable editing’. I’m not sure why you’re seeing this message. Please get in touch via email (website at myonlinetraininghub.com) with screenshots of the process you followed to download the file and the messages you’re seeing so we can help troubleshoot.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.