• 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

Excel

excel templates

Where to Find Free Excel Templates

January 26, 2023 by Philip Treacy

Excel templates can save you time designing, setting up and standardising forms and reports. There are hundreds of free templates covering many types of documents and themes available for all Excel users. Excel templates work in the Excel desktop app and Excel Online. Watch the Video Free Excel Templates You’ll find free Excel templates via …

Read moreWhere to Find Free Excel Templates
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

August 11, 2022 by Philip Treacy

In most cases you can easily remove Excel password protection if you’ve forgotten the password. However, the likelihood of your success depends on which password protection method was used, as some of the four options below are more robust than others. Excel password protection is available for: Sheets Workbooks File Open File Edit Each method …

Read moreEasily Remove Excel Password Protection
Import data from a picture to Excel

Import Data from a Picture to Excel

July 28, 2022 by Philip Treacy

New to Windows is the ability to import data from a picture to Excel*. No more typing data manually into spreadsheets. It works with image files or screen captures on your clipboard. It's available on the Data tab of the Ribbon > From Picture, as shown below: *Import data from a picture requires a Microsoft …

Read moreImport Data from a Picture to Excel
excel online

5 Excel Online Features Better than Desktop

July 14, 2022 by Mynda Treacy

Microsoft are massively investing in Excel Online and as a result there are some features that are now better than they are in the desktop version of Excel. The great news is that anyone can use Excel Online for free. You don’t need an Excel license or 365 membership! Watch the Video Download Workbook Enter …

Read more5 Excel Online Features Better than Desktop

10 Common Excel Mistakes to Avoid

September 30, 2021 by Mynda Treacy

I’ve received a lot of Excel files from our members over the years and I see the same mistakes time and again. In this post I’m going to list the 10 things you should never do in Excel and what to do instead to avoid trouble when working in Excel. Watch the Video Download Workbook …

Read more10 Common Excel Mistakes to Avoid
new Excel features

Cool New Features in Excel for Microsoft 365

September 16, 2021 by Mynda Treacy

In this tutorial I’m going to highlight some cool new Excel features that might have slipped under your radar, a couple of which we’ve wanted forever. These are available to Microsoft 365 users, and some are so new that they’re only available to Office Insiders users on the Beta Channel. If ever there was a …

Read moreCool New Features in Excel for Microsoft 365
dynamic dependent data validation

Dynamic Dependent Data Validation

August 26, 2021 by Mynda Treacy

Before we had the luxury of dynamic array functions, creating dependent data validation lists typically required using multiple tables and named ranges, as shown here. Setting them up was laborious, however now that we have dynamic array functions, creating dynamic dependent data validation lists is much easier. Note: this technique requires a Microsoft 365 license …

Read moreDynamic Dependent Data Validation
QAT

Excel Quick Access Toolbar

June 2, 2021 by Mynda Treacy

The Excel Quick Access Toolbar or QAT as it’s also known is not only a handy place for commonly used icons, but it also enables some super easy keyboard shortcuts for your favourite tools. The QAT sits either above or below the ribbon. I prefer to place it above the ribbon as this takes up …

Read moreExcel Quick Access Toolbar

Share and Collaborate in Excel

May 5, 2021 by Mynda Treacy

We’ve been able to share and collaborate in Excel files simultaneously with our co-workers for quite some time. However, recently there have been some significant improvements to the Excel co-authoring experience that will blow you away. All you need to co-author in Excel is a Microsoft 365 subscription and an internet connection. You can even …

Read moreShare and Collaborate in Excel
Workbook Protection

Excel Workbook Protection

April 7, 2021 by Mynda Treacy

When you spend days crafting your latest report, the last thing you need are well meaning users messing with your file. In this tutorial I’m going to show you how to use Excel workbook protection which will allow your users to experience the report as you intended. They can: Click Slicer buttons Refresh data connections …

Read moreExcel Workbook Protection
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 12
  • Next
  • 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.