www.myonlinetraininghub.com Open in urlscan Pro
192.124.249.160  Public Scan

Form analysis
1 forms found in the DOM

GET https://www.myonlinetraininghub.com/

<form class="search-form" method="get" action="https://www.myonlinetraininghub.com/" role="search"><label class="search-form-label screen-reader-text" for="searchform-1">Search site</label><input class="search-form-input" type="search" name="s"
    id="searchform-1" placeholder="Search..." required=""><button class="search-form-submit button-secondary" type="submit" value="Search"><span class="screen-reader-text">Submit search</span><svg xmlns="http://www.w3.org/2000/svg"
      viewBox="0 0 512 512" class="search-form-submit-icon" width="24" height="24"><!-- Font Awesome Pro 5.15.3 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license (Commercial License) -->
      <path
        d="M508.5 468.9L387.1 347.5c-2.3-2.3-5.3-3.5-8.5-3.5h-13.2c31.5-36.5 50.6-84 50.6-136C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c52 0 99.5-19.1 136-50.6v13.2c0 3.2 1.3 6.2 3.5 8.5l121.4 121.4c4.7 4.7 12.3 4.7 17 0l22.6-22.6c4.7-4.7 4.7-12.3 0-17zM208 368c-88.4 0-160-71.6-160-160S119.6 48 208 48s160 71.6 160 160-71.6 160-160 160z">
      </path>
    </svg></button>
  <meta content="https://www.myonlinetraininghub.com/?s={s}">
</form>

Text Content

My Online Training Hub
Data and Cookie Consent
In order to provide a more personal user experience, we and our 219 partners use
technology such as cookies to store and/or access device information.
By clicking “Accept” you consent to these technologies which will allow us and
our partners
to process non-sensitive data such as IP address, unique ID, and browsing data
for the purposes of serving personalized ads and content, ad and content
measurement, audience insights, and to develop and improve products.
Your choices on this site will be applied only for this site. You can change
your settings at any time, including withdrawing your consent, by going to the
Privacy Policy
page of this site.
Manage Settings
Accept

Update Privacy Settings
 * 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

Menu
 * 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
 * 
 * Search
   Search siteSubmit search
 * Login

 * Courses
 * Pricing Sub Menu
   * 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 Sub Menu
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function Sub Menu
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel Sub Menu
     * 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 Sub Menu
   * Login
   * Password Reset
 * Blog
 * Excel Webinars
 * Excel Forum Sub Menu
   * Register as Forum Member
 * 
 * Login


EXCEL DASHBOARD


QUICK AND EASY DATA ANALYSIS IN 10 MINUTES

January 23, 2024 by Mynda Treacy

In today's data-driven landscape, mastering the art of data analysis is an
essential skill that can open doors. Join us as we delve into the fundamental
stages of data analysis, encompassing everything from data collection and
cleansing to insights that empower you to make informed decisions. As a data
analyst your role revolves around harnessing …

Read moreQuick and Easy Data Analysis in 10 Minutes


PERSONAL BUDGET IN EXCEL

January 2, 2024 by Mynda Treacy

With the cost-of-living crisis affecting everyone, it's essential to get control
of your finances. Having a personal budget can be your most valuable tool, but
creating a budget spreadsheet from scratch can be intimidating, time-consuming,
and, for some, a downright chore. In this post I'll step you through creating a
personal budget in Excel, that's …

Read morePersonal Budget in Excel


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

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

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 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


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

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

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


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 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


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


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


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

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

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


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

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 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

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

 * AI in Excel
 * Excel
 * Excel Charts
 * Excel Dashboard
 * Excel Formulas
 * Excel Office Scripts
 * Excel PivotTables
 * Excel Shortcuts
 * Excel VBA
 * General Tips
 * Online Training
 * Outlook
 * Power Apps
 * Power Automate
 * Power BI
 * Power Pivot
 * Power Query

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

COMPANY

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


SUPPORT

 * Contact
 * Forum
 * Helpdesk – For Technical Issues

Copyright © 2024 · 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.



76 Shares
Share
Tweet
Pin
Share
Share
Print
Share
Email
Share