• 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

Where To Start

You are here: Home / Where To Start

Which Course Is Right For Me?

Whether you're a complete beginner or have experience with Excel, this guide will help you find the right course for you.

Use the buttons below to select the type of course you're looking for.

Everything Beginner Intermediate Experienced Specialist
function logo

Advanced Excel Formulas

Course Details

Master Excel's functions to work faster and more efficiently.
Covering fundamentals and advanced uses for functions.
excel table

Excel Tables

Course Details

Automate formatting like banded rows and columns.
Quickly sort, filter and total your data and see other statistics.

Pivot Tables : Quick Start

Course Details

Introduction to Pivot Tables. Start with the ideal data layout then cover formatting, aggregation, pivot charts, filters, slicers and more.

Excel

Course Details

Everything you need to know to work with Excel.
30+ hours of video lessons supported with practice workbooks.
function logo

Excel, Word, Outlook

Course Details

Learn the core software tools any professional needs in a modern office environment. Choose just one of these, or choose any combination of the three.

Excel Expert

Course Details

Designed to take you from zero to hero in Excel. Covering advanced topics like array formulas, named ranges, dynamic array functions, advanced functions, conditional formatting, macros and more.

Xtreme Pivot Tables

Course Details

Harness the power of Pivot Tables to quickly summarise and analyse large amounts of data. Transform data into meaningful reports that are easy to update and change.

Pivot Tables

Free Webinar

With Pivot Tables you can rapidly summarise and analyse massive amounts of data. Learn to create reports extremely quickly with just a few mouse clicks.
power query

Power Query

Course Details

Extract data from almost any source. Speed up and simplify the process of cleaning and transforming that data, ready for analysis in Excel, Power Pivot or Power BI.
power pivot

Power Pivot and DAX

Course Details

Import millions of rows of data and create relationships between data sources. Quickly transform this data into meaningful interactive reports.

Creating Excel Dashboards

Free Webinar

Using nothing more than Excel, build interactive Dashboard reports that you can update in less than one minute.

Excel Dashboards With Power Query & Power Pivot

Free Webinar

Use Power Query to get data from multiple sources, filter and clean it, send the data to Power Pivot and mash it up in Pivot Tables to create an interactive Excel Dashboard.

Excel Dashboards

Course Details

Dashboards provide insight, analysis and alerts by displaying key trends, comparisons and data in interactive reports. Filter data and change views to find answers to questions and problems.

Power BI Dashboards

Free Webinar

Power BI Dashboards are built with a drag & drop interface. Interactive visualisations allow cross highlighting and filtering by clicking on the charts. Users can drill down to lower levels and even examine underlying data.

Power BI

Course Details

Microsoft’s Business Intelligence tool allows you to quickly develop stunning interactive dashboards. Use Power Query and Power Pivot to prepare data, and embed Excel charts, tables, Pivot Tables and Excel dashboards in your Power BI dashboards. Data refresh can be scheduled so your dashboards are always up to date.

Financial Modelling

Course Details

A step-by-step guide to to create your own financial model including Income Statement, Balance Sheet and Cash Flow Statement. At the end of this course you will have a complete set of financial statements and will be able to repeat the process to build your own models.

Excel for Decision Making

Course Details

Use Excel's existing tools to make business decisions under uncertainty by performing Monte Carlo simulations, using Decision Trees and Forecasting with the Data Analysis Toolpak. Ideal for executives, analysts and all levels of business school students.

Excel for Financial Analysis

Course Details

Leverage Excel tools for financial analysis including Time value of Money functions, What-If analysis, Goal Seek, Amortization, Depreciation, and Solver. Ideal for accountants, executives, analysts and all levels of business school students.

Excel Analysis Toolpak

Course Details

Statistics for the non-statistician. Quickly and efficiently calculate and report the statistics of data and make decisions based on statistical output. Use the Excel Analysis Toolpak to generate descriptive statistics, histograms, correlations, regression, rank & percentile, random numbers, and sampling.

Excel for Operations Management

Course Details

This course is ideal for those involved in managing the daily operations of a business. If your job entails tasks such as calculating breakeven, optimizing shipping, allocating funds to maximize NPV/profit, or managing staff scheduling, the lessons and examples in this course will teach you how to do this. Includes an introduction to Excel Solver and how to create Gantt Charts.

Excel for Customer Service

Course Details

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.

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.