• 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 Custom Number Format Conditions

September 17, 2020 by Mynda Treacy

Custom number format conditions allow you to specify a different format based on the size of a number. In this tutorial we’ll look at the different ways we can use them, including some fun with emojis! In the examples below I’ve used emojis with custom number formats to visualise temperatures. And instead of boring old …

Read moreExcel Custom Number Format Conditions
data from picture icon

Import Data from a Picture to Excel Mobile

August 27, 2020 by Mynda Treacy

A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your data and import it to an Excel worksheet. The import data from a picture to Excel feature is available to all mobile app users. No 365 subscription is necessary! If you have a Mac with …

Read moreImport Data from a Picture to Excel Mobile
Gather Data with Excel Forms

Gather Data with Excel Forms

May 13, 2020 by Mynda Treacy

Excel Forms are super useful if you collate data manually, for example via email or PDF forms. Or even if you’ve set up an Excel template for your users to enter data into, that you then spend time converting into a layout suitable for use with formulas and PivotTables. Excel Forms don’t require any complex …

Read moreGather Data with Excel Forms
Visio for Excel Free Add-in

Visio for Excel Free Add-in

April 30, 2020 by Mynda Treacy

Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts linked to cells like this: And org charts like this: And because they’re linked to cells, you simply refresh the connection and the diagrams update! Watch the Visio for Excel Free Add-in Video Download Workbook …

Read moreVisio for Excel Free Add-in
Searchable Drop Down List in Excel

Searchable Drop Down List in Excel

April 9, 2020 by Mynda Treacy

Creating this searchable drop down list in Excel is so easy I’m wondering why I never thought of it before. It doesn’t require any formulas or VBA and it has all the bells and whistles you’d expect from a searchable drop down list, including automatic sorting, ignoring duplicates and an option to select ‘All’: Watch …

Read moreSearchable Drop Down List in Excel

20 Pro Excel Keyboard Shortcuts

March 5, 2020 by Mynda Treacy

This post contains 20 Excel keyboard shortcuts used by Excel pros. I’m not talking about CTRL+Z, and the like, these are keyboard shortcuts that will take your skills to the next level of productivity. As you read through the list please make a note of the keyboard shortcuts that amaze you, then please share them …

Read more20 Pro Excel Keyboard Shortcuts
Excel Hash 2019

Excel Hash 2019 – Dynamic Playoffs Table

December 11, 2019 by Mynda Treacy

Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular cooking show, Chopped. The one where chefs are given a mystery box of four ingredients to make a meal from. 2018 was the inaugural year for Excel Hash and I was honoured to win! It’s …

Read moreExcel Hash 2019 – Dynamic Playoffs Table
Excel Freeze Panes vs Split Panes

Excel Freeze Panes vs Split Panes

June 3, 2019 by Mynda Treacy

One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes set. They’re easily confused, so I thought I’d explain the difference. Watch the Video Excel Freeze Panes Freeze Panes is used when you want to fix the top row(s) and or left most column(s) in …

Read moreExcel Freeze Panes vs Split Panes
Excel Data Types

Excel Data Types

October 2, 2018 by Mynda Treacy

AI powered Excel Data Types will transform the way we work with Excel by enabling a cell to contain much more than text, numbers or formulas. There are currently two Excel data types available to Office 365 users*; Stocks and Geography. Let’s start with the Geography Data Type that can take a table of countries …

Read moreExcel Data Types
Excel Threaded Comment

Excel Threaded Comments

September 27, 2018 by Mynda Treacy

There is a new style of comment available in Excel for Office 365 users*. They’re technically called Threaded Comments, but they’ll be known as ‘Comments’ and they look like this: *Threaded comments are being made available to Office 365 users on a gradual basis over several weeks. Excel threaded comments allow you to string several …

Read moreExcel Threaded Comments
  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • 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.