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

Cart

You are here: Home / Cart
Currency
Choose Currency
sectigo secure seal
Secured by Sucuri Badge
30 day guarantee small
PayPal and Stripe Credit Card Logos

Buy Multiple Courses To Get 20% Off Each One.


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

Course Syllabus and Details

Online
Online + Download

$39Add to cart

$39Add to cart

$79Add to cart

$79Add to cart



Learn to use Excel Tables and save lots of time as they automate things like formatting, sorting and filtering.

They provide dynamic named ranges that automatically update in formulas, Pivot Tables and charts.

Course Syllabus and Details

Online
Online + Download

$19Add to cart

$19Add to cart

$39Add to cart

$39Add to cart



Get quickly up to speed with the functions that are going to give you the biggest efficiency gains.

Using real world examples to cover the fundamentals for each function as well as advanced, less obvious, uses for them.

Course Syllabus and Details

Online
Online + Download

$69Add to cart

$69Add to cart

$138Add to cart

$138Add to cart


 

Your cart is currently empty.

Return to shop

__

Add Other Courses And Get 20% Off Each One

  • Excel Tables Course

    Excel Tables

  • Learn to use Excel Tables and save lots of time as they automate things like formatting, sorting and filtering.
  • Online Only

    $19Add to cart

    $19Add to cart

    $19Add to cart

  • Online + Download

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Excel Tables Course InformationCourse Videos : 0hr 51min
  • Getting started with Tables
  • Sorting, Filters and Slicers
  • Formulas
  • Structured References and Absolute References
  • Limitations and Workarounds
  • Sample Excel Workbooks and Data
  • Advanced Excel Formulae Course

    Advanced Excel Formulas

  • Get quickly up to speed with the functions that are the heart of Excel.
  • Online Only

    $69Add to cart

    $69Add to cart

    $69Add to cart

  • Online + Download

    $138Add to cart

    $138Add to cart

    $138Add to cart

  • Advanced Excel Formulas Course InformationCourse Videos : 5hr 4min
  • Course includes: Conditional Functions
  • Lookup Functions and Formula Errors
  • Text Functions, Math Functions
  • Array Formulas and Dynamic Arrays
  • Named Ranges, and more ...
  • Practice Questions and Sample Excel Workbooks
  • Pivot Tables Quick Start

    Pivot Tables Quick Start

  • This course will quickly have you building your own PivotTables with confidence.
  • Online Only

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Online + Download

    $79Add to cart

    $79Add to cart

    $79Add to cart

  • Pivot Tables Quick Start Course InformationCourse Videos : 1hr 27min
  • Learn the correct data layout, and
  • Pivot Charts, Filters, Slicers and Timelines
  • Formatting, Grouping and Sorting
  • GETPIVOTDATA Function
  • Calculated Fields and Items, and much more
  • Download Sample Excel Workbooks and Data
  • premium course

    Premium

  • Master the core tools any professional needs : Excel, Word & Outlook.
  • Online Only

    $199Add to cart

    $199Add to cart

    $199Add to cart

  • Online + Download

    $399Add to cart

    $399Add to cart

    $399Add to cart

  • Excel Course Information30+ hours of videos : Excel 2007, 2010, 2013, 2016, 2019 & O365
  • Word Course Information20+ hours of videos : Word 2007, 2010, 2013, 2016, 2019 & O365
  • Outlook Course Information30+ hours of videos : Outlook 2007, 2010, 2013, 2016, 2019 & O365
  • Download Sample Excel Workbooks and Word Documents
  • Customized Learning : Only Learn What You Need
  • excel pivot table course

    Xtreme Pivot Tables

  • Quickly summarise, analyse and transform large amounts of data into meaningful reports.
  • Online Only

    $149Add to cart

    $149Add to cart

    $149Add to cart

  • Online + Download

    $299Add to cart

    $299Add to cart

    $299Add to cart

  • Excel Pivot Table Course Information9h 28m of videos
  • Download Sample Excel Workbooks and Practice Data
  • Real Life Case Studies
  • excel expert course

    Excel Expert

  • Start with the essentials then cover must-know skills to go from Zero to Hero in Excel
  • Online Only

    $119Add to cart

    $119Add to cart

    $119Add to cart

  • Online + Download

    $239Add to cart

    $239Add to cart

    $239Add to cart

  • Excel Expert Course Information35+ hours of videos
  • Download Sample Excel Workbooks
  • 102 Excel Tips & Tricks Videos
  • BONUS eBook : CTRL + SHIFT + ENTER Mastering Excel Array Formulas by Mike Girvin
  • Financial Modelling Course

    Financial Modelling

  • This course breaks down the process of Financial Modelling into small parts that are easily digestible.
  • Online Only

    $298Add to cart

    $298Add to cart

    $298Add to cart

  • Online + Download

    $597Add to cart

    $597Add to cart

    $597Add to cart

  • Financial Modelling Course InformationCourse Videos : 6+ hours
  • 465 Interactive Slides
  • 1 financial model broken into 28 easy steps
  • 25 Questions
  • 30+ hands-on Excel workbooks
  • Interactive Case Study
  • excel for finance course

    Excel for Finance

  • Leverage Excel's tools for financial analysis. Ideal for accountants, executives, analysts and busines school students.
  • Online Only

    $19Add to cart

    $19Add to cart

    $19Add to cart

  • Online + Download

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Excel for Finance Course Information1h 24m of course videos
  • Time Value of Money
  • What-if Analysis
  • Future Value
  • Amortization
  • Depreciation
  • Case Study
  • excel for customer service course

    Excel for Customer Service

  • Efficiently and accurately collect and analyze data in customer service or call center environments.
  • Online Only

    $49Add to cart

    $49Add to cart

    $49Add to cart

  • Online + Download

    $99Add to cart

    $99Add to cart

    $99Add to cart

  • Excel for Customer Service Course Information2h 52m of course videos
  • Download Workbooks & Practice Data
  • Download 36 Excel Software Models
  • Detailed 215 Page Reference Guide
  • excel for decision making course

    Excel for Decision Making

  • Make business decisions using Monte Carlo simulations, Decision Trees and Forecasting with the Data Analysis Toolpak
  • Online Only

    $49Add to cart

    $49Add to cart

    $49Add to cart

  • Online + Download

    $99Add to cart

    $99Add to cart

    $99Add to cart

  • Excel for Decision Making Course Information2h 14m of course videos
  • Download Workbooks and Practice Data
  • Examine Real Business Case Studies
  • Practice Exercises
  • excel analysis toolpak course

    Excel Analysis Toolpak

  • Statistics for the non-statistician. Histograms, correlations, regression, rank & percentile, random numbers and sampling.
  • Online Only

    $19Add to cart

    $19Add to cart

    $19Add to cart

  • Online + Download

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Excel Analysis Toolpak Course Information1h 20m of course videos
  • Download Workbooks and Practice Data
  • Examine Real Business Case Studies
  • Practice Exercises
  • Excel for Operations Management Course

    Excel for Operations Management

  • Ideal for those involved in managing the daily operations of a business.
  • Online Only

    $19Add to cart

    $19Add to cart

    $19Add to cart

  • Online + Download

    $39Add to cart

    $39Add to cart

    $39Add to cart

  • Excel for Operations Management Course InformationCourse Videos : 1hr 31m
  • Calculating Breakeven
  • Introduction to Excel Solver
  • Assignment Problem and Shipping Optimization
  • Allocating Capital Investment
  • Optimizating Staff Scheduling
  • Sample Excel Workbooks and Exercises
  • 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
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

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