• 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
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Dashboard

excel project management dashboard custom periods

Project Management Dashboard Dynamic Periods

April 20, 2023 by Mynda Treacy

One of my most popular tutorials has been my Excel Project Management dashboard with nearly 2M views to date. However, I often get asked if there’s a way to switch between viewing the projects by day, week or month. The answer is yes and, in this tutorial I’m going to show you how we can …

Read moreProject Management Dashboard Dynamic Periods
excel infographic tools

Excel Infographic Tools

February 9, 2023 by Mynda Treacy

In this tutorial I’m going to share with you some hidden Excel chart techniques that will make your reports stand out and draw your readers in. These techniques are often used for infographic style reports, but that’s not to say you can’t use them in dashboards or even PowerPoint presentations. Infographics are a one off …

Read moreExcel Infographic Tools
ai dashboard design

AI Dashboard Design

February 2, 2023 by Mynda Treacy

Designing dashboards and reports can be a time consuming task, particularly if you’re not artistically inclined. In 60 seconds, AI generated four dashboard designs for me for free! All I had to do was give it a sentence worth of instructions and it returned the four bicycle sales dashboards you see below. I think you’ll …

Read moreAI Dashboard Design
dark theme dashboards

Dark Themed Excel Dashboards

November 17, 2022 by Mynda Treacy

If you’re going to build dark themed Excel dashboards, then you need to have some tricks up your sleeve in order to give them that wow factor. In this tutorial I’m going to show you some techniques that work well with dark colours that will have your data popping. In the video below I build …

Read moreDark Themed Excel Dashboards
excel dashboards custom backgrounds

Custom Excel Dashboard Backgrounds

September 29, 2022 by Mynda Treacy

Custom Excel dashboard backgrounds are super easy to create and can bring a level of polish and professionalism to your reports. Taking your reports from this: To this: And the good news is they’re super easy to create using PowerPoint. Watch the Video Custom Excel Dashboard Backgrounds Step by Step The first step is to …

Read moreCustom Excel Dashboard Backgrounds

Embedding Excel Dashboards in a Web Page

May 26, 2022 by Mynda Treacy

Embedding Excel dashboards in a web page is a great way to securely share reports. All you need to do is save your file on OneDrive or SharePoint and get the embed code. There are different approaches required depending on whether you have OneDrive Personal, or OneDrive for Business or SharePoint. The latter two offer …

Read moreEmbedding Excel Dashboards in a Web Page
excel student performance dashboard

Excel Student Performance Dashboard

May 9, 2022 by Mynda Treacy

I've used a range of techniques to build the interactive Excel student performance dashboard below, which are covered in the video and there are links to further tutorials beyond. Building dashboards for student data requires different techniques to typical Excel dashboards because there is a lot of data to fit into a relatively small space. …

Read moreExcel Student Performance Dashboard
5 Pro excel dashboard design tips

5 Pro Excel Dashboard Design Tips

February 10, 2022 by Mynda Treacy

Design can make or break how well your dashboard communicates your message. Unfortunately, there are some common mistakes I see again and again. At best they make you look like an amateur and at worst they make your report difficult to read and can even be misleading. Thankfully there are some easy things we can …

Read more5 Pro Excel Dashboard Design Tips
excel interactive personal finance dashboard

Interactive Personal Finance Dashboard

November 18, 2021 by Mynda Treacy

Manage and monitor where your money goes with this personal finance dashboard. Even if you’re not interested in building your own interactive personal finance dashboard, in this step by step tutorial you’ll learn a load of tips, tricks and techniques you can apply to any dashboard you build. There are no fancy tools or add-ins …

Read moreInteractive Personal Finance Dashboard

Non-financial Excel Dashboards

May 20, 2021 by Mynda Treacy

Dashboards give a visual snapshot of your business performance. They typically show data spread over time and grouped by category. The most common dashboard examples are based on financial data, so in this video tutorial I’ll show you how to build non-financial Excel dashboards. I’ll be including some techniques I haven’t demoed in any of …

Read moreNon-financial Excel Dashboards

Secrets to Building Excel Dashboards in Under 15 Minutes

April 27, 2021 by Mynda Treacy

Building Excel Dashboards doesn't need to be a slow process. When your data is structured correctly you can use the built in tools (that you probably already know), to build dashboards super fast. Let me show you how in the video below. Download Workbook Enter your email address below to download the sample workbook. Get …

Read moreSecrets to Building Excel Dashboards in Under 15 Minutes
personal share portfolio dashboard

Personal Stock Portfolio Dashboard

February 4, 2021 by Mynda Treacy

Keeping track of your share trading is easy with this personal stock portfolio dashboard. It uses the latest Excel tools* including Data Types and the STOCKHISTORY function to create a report that’s connected to live data and updates at the click of a button. *Note: requires Microsoft 365. Not suitable for Excel 2019 and earlier. …

Read morePersonal Stock Portfolio Dashboard
power bi v excel dashboards

Excel Dashboards vs Power BI Dashboards

November 10, 2020 by Mynda Treacy

One of the most common questions I get is: Should I be using Power BI to build dashboards instead of Excel? If the person you ask this of has only used one tool or the other, then you're likely to get a biased answer. I have taught thousands of people how to build dashboards using …

Read moreExcel Dashboards vs Power BI Dashboards
act v plan dashboard

Plan v Actual Excel 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. It needn’t be a lot of work either. This dashboard can …

Read morePlan v Actual Excel Dashboard
project management dashboard

Excel Project Management Dashboard

March 25, 2020 by Mynda Treacy

Managing projects or tasks can be improved with a visual representation of progress and milestones. Thankfully, an Excel project management dashboard like the one below is relatively easy to build, requiring no programming or add-ins. Download Workbook Download the Excel file containing the Excel project management dashboard and step by step instructions. Enter your email …

Read moreExcel Project Management Dashboard
real time data in power bi using pubnub

Real Time Data in Power BI Using PubNub

July 27, 2018 by Philip Treacy

In this post I'm going to look at getting real time data (RTD) into Power BI using a real time messaging service called PubNub. This is intended for use with the Power BI online service, not Power BI Desktop. Power BI provides a few different ways to get RTD : Push Data, Streaming Data and …

Read moreReal Time Data in Power BI Using PubNub
interactive excel web app dashboard

Interactive Excel Web App Dashboard

May 14, 2014 by Mynda Treacy

Warning: this is a long post. Get supplies so you don’t dehydrate or suffer from low blood sugar levels before reaching the end 🙂 Don't let the length of this post put you off though. The process is fairly straight forward and there aren't really that many steps...honest. Embedded below is an interactive Excel dashboard …

Read moreInteractive Excel Web App Dashboard
sports league tables excel dashboard

Excel Football Dashboard Extreme Makeover

October 23, 2013 by Mynda Treacy

Phil plays 6 a-side football (soccer) in a Supa-Oldie league. They’re all over 35 and that’s considered supa-old in football! Personally I think it’s an excuse to have a beer with the lads, anyway… Darryl, the fellow who updates the scores, explained to Phil that every week it was taking him 2 hours to prepare …

Read moreExcel Football Dashboard Extreme Makeover
Tour de France Excel Dashboard

Tour de France Excel Dashboard

July 23, 2013 by Mynda Treacy

Since Phil is somewhat of a cycling fan I have been subjected to late night TV of le Tour. Personally I don’t understand all the complexities of it, what with different jerseys (some of which I must say are a little feminine), how the team aspect works, why crazy fans are allowed to jump out …

Read moreTour de France Excel Dashboard
excel dynamic text formula trick

Excel Dynamic Text Formulas Trick [FREE VIDEO]

October 21, 2011 by Mynda Treacy

Inserting text into a text box is one cool trick, but being able to have that text update when your data changes without you having to lift a finger is another. Here's an example below. You can see when the selection in the PivotTable is changed, the labels on the chart automatically update too. Watch …

Read moreExcel Dynamic Text Formulas Trick [FREE VIDEO]
excel dashboard reports

Excel Dashboard Reports

February 11, 2011 by Mynda Treacy

The dashboard in your car is one of the key tools you use to monitor how it’s running, so it’s appropriate that the business world has borrowed the term and applied it to a series of graphs and key information that fits onto one page. A dashboard view of your business’s performance, if done well, …

Read moreExcel Dashboard Reports

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.