• 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
  • Login
Mynda treacy Microsoft MVP

Succeed in a Data Driven World

Learn Career Transforming Skills to Sky-Rocket Your Career

Our Courses

Why Learn With Us?

Developed by Experts

Our courses have been created by Microsoft MVP's and industry experts.

Practice What You Learn

Use course workbooks and supporting files to practice the skills you are learning

Certificate of Completion

Complete a course to receive a certificate you can use to show off the new skills you've learned

Learn at Your Own Pace

Watch course videos anytime you like, as many times as you like

Short Videos

Videos that are to the point, with no waffle, means you make the most of your valuable time

Support

Use the Members Only forum to get support if you have a question, or get stuck

Benefit from our expertise and knowledge

10
Years as a Microsoft MVP
20+
Years of Industry Experience
1M+
Happy Students

Popular Courses

Data Preparationn

Power Query

Get data from almost any source (a database, the web, Excel, Sharepoint, Salesforce, OData etc), then clean, transform, merge and append data to your query.

Load the data into Excel or Power Pivot for analysis, report preparation or export.
Course Details
Data Analysis & Presentation

Excel Dashboards

Dashboards provide insight, analysis and alerts by displaying key trends, comparisons and data in interactive reports.

The reader can filter data and change views to find answers to their questions and problems.
Course Details
Data Analysis & Presentation

Power BI

Microsoft's business intelligence & data visualization tool enables you to quickly develop stunning interactive dashboards.

Embed Excel charts, tables, Pivot Tables and dashboards in your Power BI dashboards, then securely share your dashboards to any device.
Course Details
Data Modeling

Power Pivot & DAX

Import millions of rows of data, create relationships between different data sources, and build interactive reports.

Quickly transform huge volumes of data into meaningful information to get the answers you need.
Course Details
See All Courses

We Teach People Like You At Places Like These

Microsoft LogoMITciscoibmaccentureintel

Student Feedback

customer leanne baker

Leanne Baker

Excellent content and great value for money

I have purchased a number of courses from My Online Training Hub in the past. The content and pace of the courses are great. No unnecessary hours of demo's and chatter, just all the important content delivered in an easy to learn format with downloadable exercise files to follow along. Great value for money and I would recommend to all.
customer-brian-avatar

Brian Wied

A New Standard for How We Use Excel

I've bought your Power Query, Power Pivot and Dashboards courses. Well worth it by far. Not only have I saved a tremendous amount of time, but set a new standard for how we use Excel in my company. The courses are packaged in small, easy to digest pieces (2-5 min) that make it really easy to get through and implement right away.
customer steve avatar

Steve Holland

Simply excellent training videos

This is my go-to place for Excel. Training videos are clear, thorough yet succinct, well-paced and cover the types of scenarios we commonly encounter. Has helped me evolve to use newer capabilities as they are introduced, as well as become more efficient in my regular usage.
customer-al-avatar

Al Boldt

Excellent content and support

The courses that Mynda does are fast paced, cover the essentials and much more - the course files are annotated as required and integrated into the video content. Furthermore - both Mynda and Phil are ultra responsive to emails.

We Teach People Like You At Places Like These

airbusnikeneckpmgpwcroche

Our Latest Blog Posts

September 5, 2023

8 Built-In Excel AI Tools

Excel has a load of AI tools already built-in that we can use to improve productivity and make our lives easier.

Read More
August 25, 2023

Interactive Python Charts in Excel

Make use of the amazing Python charts now available in Excel.

Read More
August 22, 2023

How to Use Python in Excel Natively

Python is now available in Excel.


Write Python like an Excel formula and use libraries like Pandas, NumPy, Seaborn and Matplotlib.

Read More
August 15, 2023

Excel Dynamic Named Ranges

If you frequently edit cell ranges that are referenced by formulas, PivotTables, charts, and other Excel features, then using dynamic named ranges will save you a substantial amount of time.

Read More
More Blog Posts

We Teach People Like You At Places Like These

deloittesiemensstanfordklmdellunicef

Popular Videos

How to Build Interactive Excel Dashboards

Learn how to create an interactive Excel dashboard from scratch, using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel.

Download Dashboard Template

Automate Boring Tasks With Power Query

Learn how Power Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button!

Read Tutorial

Power Query if  Statements

How to Write Power Query if Statements including Nested ifs, if + or, if + and

Read Tutorial

Interactive Project Management Dashboard

Step by step tutorial on how to build an interactive Project Management Dashboard in Excel.

Example dashboard file to download for free.

Download Dashboard Template
More Videos
starapartmentenvelopelicensefilm-playusersphonecalendar-fulllaptop-phoneheart-pulsediamondcoffee-cupbriefcasemustachebugearth

Blog Categories

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

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