My Online Training Hub

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

Mynda treacy Microsoft MVP

Succeed in a Data Driven World

Learn Career Transforming Skills That Get You Noticed and Promoted, FAST

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 are up to speed fast

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 Preparation

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

Some of Our Blog Posts

August 27, 2024

Multi-level Dependent Drop-down Lists

Creating multi-level dependent drop-down lists in Excel streamlines data entry and reduces errors.

Read More
August 20, 2024

Excel Automation Tricks

Learn 5 Excel automation tricks for common tasks like updating drop-down lists, ranges, consolidating data, and creating dynamic text labels.

Read More
July 30, 2024

AI Dashboard Generation

Dashboards are time consuming to make, but this AI dashboard generation tool can make them in under a minute, and it's not ChatGPT!

Read More
June 11, 2024

Must Know Excel Tools

Hidden within Excel (sometimes in plain sight) are game-changing tools that most users overlook.

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
apartmentenvelopelicensefilm-playusersphonecalendar-fulllaptop-phoneheart-pulsediamondcoffee-cupbriefcasemustachebugearth