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

Excel Hash Interactive Bug Menu

September 4, 2018 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. The four mystery ingredients we’ve been given are: MAX function FREQUENCY function Form Controls 3D …

Read moreExcel Hash Interactive Bug Menu
using azure machine learning in excel

Using Azure Machine Learning in Excel

July 13, 2018 by Philip Treacy

In this post I'm going to look at how you can create an Azure Machine Learning experiment to predict diamond prices. Then set up the experiment as a web service, connect Excel to it, and use it to estimate the prices of diamonds. If I had to explain what machine learning meant, in this context, …

Read moreUsing Azure Machine Learning in Excel

Office 365 vs Perpetual Licences

June 6, 2018 by Mynda Treacy

From time to time I get asked which Microsoft Office licence* should I get; Office 365 subscription, or the one-time payment for a perpetual licence i.e. perpetual licences are the ones you pay for once and own forever…or until you decide to upgrade. The answer is simple really; perpetual licences are dead. There I said …

Read moreOffice 365 vs Perpetual Licences
Real time data in Excel using sockets

Real Time Data in Excel Using Sockets

May 31, 2018 by Philip Treacy

Last week I wrote about getting real time data into Excel using PyXLL and Python code. I described a way to do this using HTTP connections. HTTP is the type of connection your browser uses to read web pages. In this article I'm looking at using sockets to get real time data into Excel. Sockets …

Read moreReal Time Data in Excel Using Sockets
real time data in excel

Real Time Data in Excel

May 24, 2018 by Philip Treacy

Updated April 2020 Excel does support getting real time data into the worksheet with the RTD function, but this requires programming a COM server with which the RTD function communicates. Power BI is able to make use of streaming data via API connections or PubNub, but what if I just want to pull some live …

Read moreReal Time Data in Excel
ALT codes for symbols and characters

ALT Codes for Symbols and Characters

March 29, 2018 by Philip Treacy

On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the ALT key and then using the numeric keypad to type the ASCII or Unicode code for that character. For example, holding down ALT and then typing 184 on the numeric keypad, prints ©, the copyright …

Read moreALT Codes for Symbols and Characters
essential excel shortcuts

23 Essential Excel Keyboard Shortcuts

January 16, 2018 by Philip Treacy

There are hundreds of Excel keyboard shortcuts but we don't use them all frequently. There'll be some that you use more often than me, but in this post I'm listing the keyboard shortcuts I use all the time. It was hard to pick just a few, it was like being asked to pick your favourite …

Read more23 Essential Excel Keyboard Shortcuts
Fix Excel dates formatted as text

Fix Excel Dates Formatted as Text

October 23, 2017 by Mynda Treacy

Dates incorrectly entered or imported as text are a showstopper. We need our dates entered as date serial numbers to be able to leverage the Date Functions, use them in math and lookups, or even use them in PivotTables. So, often the first thing we need to do is fix Excel dates formatted as text. …

Read moreFix Excel Dates Formatted as Text
Excel Date and Time Formatting

Excel Date and Time Formatting

October 20, 2017 by Mynda Treacy

Even though dates and time are actually stored as a regular number known as the date serial number, we can make use of extensive Excel date and time formatting options to display them just the way we want. We can access some quick date and time formats from the Home tab > in the Number …

Read moreExcel Date and Time Formatting
excel date and time

Excel Date and Time

October 17, 2017 by Mynda Treacy

The objective of this post is to teach you how Excel handles date and time and provide you with all the tools you will need. It’s designed to be read in conjunction with the accompanying Excel file, which you can download below. Download the Files Enter your email address below to download the comprehensive Excel …

Read moreExcel Date and Time
  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • 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.