August 26, 2021
Dynamic Dependent Data Validation
Before we had the luxury of dynamic array functions, creating dependent data validation lists typically required using multiple tables and
Read More
May 5, 2021
Share and Collaborate in Excel
We’ve been able to share and collaborate in Excel files simultaneously with our co-workers for quite some time. However, recently
Read More
April 7, 2021
Excel Workbook Protection
When you spend days crafting your latest report, the last thing you need are well meaning users messing with your
Read More
September 17, 2020
Excel Custom Number Format Conditions
Custom number format conditions allow you to specify a different format based on the size of a number. In this
Read More
August 27, 2020
Import Data from a Picture to Excel Mobile
A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your
Read More
May 13, 2020
Gather Data with Excel Forms
Excel Forms are super useful if you collate data manually, for example via email or PDF forms. Or even if
Read More
April 30, 2020
Visio for Excel Free Add-in
Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts
Read More
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.
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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.
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More