Excel Archives • Page 3 of 6 • My Online Training Hub

April 9, 2020

Searchable Drop Down List in Excel

Creating this searchable drop down list in Excel is so easy I’m wondering why I never thought of it before.

March 5, 2020

20 Pro Excel Keyboard Shortcuts

This post contains 20 Excel keyboard shortcuts used by Excel pros. I’m not talking about CTRL+Z, and the like, these

December 11, 2019

Excel Hash 2019 – Dynamic Playoffs Table

Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular

June 3, 2019

Excel Freeze Panes vs Split Panes

One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes

October 2, 2018

Excel Data Types

AI powered Excel Data Types will transform the way we work with Excel by enabling a cell to contain much

September 27, 2018

Excel Threaded Comments

There is a new style of comment available in Excel for Office 365 users*. They’re technically called Threaded Comments, but

September 4, 2018

Excel Hash Interactive Bug Menu

Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular

July 13, 2018

Using Azure Machine Learning in Excel

In this post I'm going to look at how you can create an Azure Machine Learning experiment to predict diamond

June 6, 2018

Office 365 vs Perpetual Licences

From time to time I get asked which Microsoft Office licence* should I get; Office 365 subscription, or the one-time

May 31, 2018

Real Time Data in Excel Using Sockets

Last week I wrote about getting real time data into Excel using PyXLL and Python code. I described a way

May 24, 2018

Real Time Data in Excel

Updated April 2020 Excel does support getting real time data into the worksheet with the RTD function, but this requires

March 29, 2018

ALT Codes for Symbols and Characters

On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the

October 23, 2017

Fix Excel Dates Formatted as Text

Dates incorrectly entered or imported as text are a showstopper. We need our dates entered as date serial numbers to

October 20, 2017

Excel Date and Time Formatting

Even though dates and time are actually stored as a regular number known as the date serial number, we can

August 22, 2017

Excel Extract a Unique List

As with most things in Excel, there are many ways to extract a list of unique or distinct values from

August 15, 2017

Excel Find and Remove Duplicates

Sometimes we want to find and remove duplicates in Excel, other times we just want to identify or highlight duplicates.

June 6, 2017

Script Lab – Explore the Office JavaScript API & Learn to Build Add-Ins

Microsoft recently announced a project called Script Lab, previously known as 'Add-In Playground', which aims to help you learn how

May 17, 2017

Excel Themes

Excel Themes are a bundle of default colors, font styles and Shape effects. There are lots of built in Excel

April 20, 2017

Excel Row and Column Shortcuts

Inserting, copying, moving, or cutting and pasting rows and columns is something we do every day in Excel. And there

February 22, 2017

Excel Conditional Formatting Highlight Matches in List

In this tutorial we’re going to look at how we can use Excel Conditional Formatting to highlight rows in a

February 17, 2017

Excel Custom Number Format Guide

I’ve put together this Excel custom number format guide as a resource for our members. There are loads of ways

February 9, 2017

Excel Conditional Formatting to Highlight Matches

Using Excel Conditional Formatting to highlight matches is easy when you team it up with a data validation list like

January 17, 2017

Locating Values in Large Excel Tables

By Harold Graycar XL Numerics Developer of Excel for Customer Service Professionals The previous post on this topic included a

January 12, 2017

Finding a Needle in an Excel Haystack

By Harold Graycar XL Numerics Developer of Excel for Customer Service Professionals When dealing with large tables containing ‘buckets’ of

January 5, 2017

Toggle Excel Conditional Formatting On and Off

One of the nice features of Excel Tables is the banded row formatting, which makes it easier to read and

December 29, 2016

Excel Icons

An awesome new feature available in Office 365 are Icons. You’ll find Excel Icons in the Insert tab of the

September 28, 2016

Excel Styles

Using Excel Styles in your workbooks can not only make formatting them quicker and easier, but also result in more

July 12, 2016

Excel Clipboard

The Excel Clipboard is an extremely useful tool that’s very well hidden. Most of us are familiar with being able

November 24, 2015

Excel Advent Calendar 2015

Around this time last Year I created an Advent Calendar in Excel: To Count Up or To Count Down? Now,

November 10, 2015

Excel User Voice

I bet there's been the odd time you've said to yourself "wouldn't it be nice if Excel had..." Or maybe