• 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

Stand Out From the Crowd

Learn the skills you need to succeed in today's data driven workforce.

mynda treacy microsot mvp

20% OFF

power bi course

Power BI

Microsoft’s latest business intelligence (BI) & 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

20% OFF

excel dashboards course

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

20% OFF

power pivot and dax course

Power Pivot and 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

20% OFF

power query course

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

20% OFF

pivot table course

Pivot Tables : Quick Start

This short course will quickly have you building your own PivotTables with confidence.

Start with the ideal data layout for creating Pivot Tables.

Then move on to formatting, aggregation, pivot charts, filters, slicers and much more.

Course Details

20% OFF

advanced excel formulas course

Advanced Excel Formulas

Don't learn Excel formulas by trial and error. This course teaches you functions that are going to give you the biggest efficiency gains at work.

Covering the fundamentals for each function, and less obvious uses for them. It's these more advanced techniques that will really set you apart from the crowd.

Course Details

20% OFF

excel expert course

Excel Expert

Designed to take you from zero to hero so you can confidently list 'Advanced Excel Skills' on your resume/CV.

Starting with the essentials, then covering must-know skills like best workbook design, advanced formulas, pivot tables, conditional formatting, macros and much more.

Course Details

20% OFF

excel tables course

Excel Tables

Learn everything you need to work with Tables in less than 1 hour.

Make huge efficiency gains by using dynamic named ranges to automatically update formulas, Pivot Tables and charts.

Automate formatting like banded rows or columns; sorting and filtering; and totals and statistics

Course Details

20% OFF

financial modelling course

Financial Modelling

Everyone involved in the business decision making process should understand the Income Statement, Balance Sheet and Cash Flow Statement.

Only by understanding core concepts can you avoid common mistakes when working with these three statements.

Course Details

20% OFF

excel pivot tables course

Excel Pivot Tables

Learning to use Pivot Tables will allow you to quickly summarise and analyse large amounts of data - with just a few clicks of your mouse.

Quickly transform data into meaningful information and create reports that are easy to update and change.

Course Details

20% OFF

excel word and outlook courses

Excel, Word & Outlook

Choose just one of these, or choose any combination of the three.

Learn the core software tools any professional needs in a modern office environment.

Course Details

20% OFF

excel for customer service course

Excel for
Customer Service

Designed for professionals working in customer service or call center environments. Efficiently and accurately collect and analyze data. Create forecasts and generate clear, meaningful charts and reports.

Boost your skills in handling customer service and call center information.

Course Details

Popular Videos


Build an Excel Dashboard in 15 Minutes

Excel Project Management Dashboard

Easily Automate Boring Tasks with Power Query

Building Power BI Reports

10 Excel Things You Should Never Do

Excel COUNTIF and COUNTIFS

Excel Pivot Tables Made Easy

XLOOKUP Function Definitive Guide

People at some of the world's best known organizations learn with us


company logos

What People Are Saying About Us

Best Excel Resource on the Planet

5 star rating

ToddM in Dallas

Best Excel Training There Is

5 star rating

Rod R, GB

Simply Excellent Training Videos

5 star rating

Steve from CA

trustpilot excellent rating

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.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x