• 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

Excel Dashboard

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
  • Previous
  • Go to page 1
  • Go to page 2

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.