Blog • Page 11 of 24 • My Online Training Hub

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 19, 2018

Remove Formatting from a Table

Let's say you have a range that you want to convert to a table Something like this that has fills,

September 11, 2018

Listing and Deleting Custom Styles

If you end up with a workbook that contains custom styles, removing all of these may be a pain depending

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

August 31, 2018

Using SUBSTITUTE Function to Find and Count Text

The SUBSTITUTE function allows you to change text in a string, or a range of strings, but there is more

August 21, 2018

Excel Chart Titles

Excel Chart titles are often a wasted opportunity to connect with your audience and drive home your message. So, let’s

August 14, 2018

Excel Analyze Data

Understanding your data and creating Excel charts has never been easier with Excel's Analyze Data (previously known as Excel Ideas

August 8, 2018

Excel Waterfall Charts

Excel Waterfall charts are now available to Office 365 users via the Insert > Charts menu. It makes light work

August 2, 2018

Real Time Data Add-In for Excel

Last week I looked at getting real time data into Power BI using PubNub. This week I want to take

July 27, 2018

Real Time Data in Power BI Using PubNub

In this post I'm going to look at getting real time data (RTD) into Power BI using a real time

July 19, 2018

Excel Functions Translator

It’s often difficult enough to figure out the correct Excel functions to use, but it’s significantly harder if you also

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

calling vba in an add-in from another vba module

July 3, 2018

Calling VBA in an Add-In From Other VBA Modules

If you've written subs or functions in your own add-in, you can use them in your worksheet as you would

June 25, 2018

Excel Slicer Formatting

Excel Slicers are great, but they’re a bit on the chunky side and that can be a pain when you’re

June 19, 2018

Power Query Consolidate Excel Sheets

Splitting data over multiple sheets is perhaps one of the worst Excel crimes I see. It’s a crime because it

June 12, 2018

Excel Power Query Add Column from Example

The Power Query Add Column from Example feature simplifies a task many of us perform daily. For example, how often

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

May 16, 2018

Excel Mini Charts

Excel mini charts are a great alternative to Sparklines. Mini charts are just regular charts made really small. You might

May 8, 2018

Excel Multi-colored Line Charts

Excel multi-colored line charts are a little gimmicky, after all we don’t need color to tell if a line is

May 3, 2018

Excel 3D Maps

Excel 3D Maps in 2016, or Power Map as it’s known in Excel 2013, enable you to visualise data in,

April 25, 2018

Excel PivotTable Quick Explore

With PivotTable Quick Explore we can filter and drill down in PivotTables and Pivot Charts without the field list exposed.

April 19, 2018

Timer or Stopwatch in Excel VBA

We had a post on the forum recently asking how to create a timer in Excel, to record how long

April 13, 2018

Volatile User Defined Functions

Excel has the concept of volatile and non-volatile functions. Microsoft define a volatile function as one that is recalculated every

April 4, 2018

Relative Named Ranges

Excel Named Ranges is a vast topic that includes some simple techniques that we all can and should use to

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

March 22, 2018

Excel ADDRESS Function

The Excel ADDRESS Function returns a cell address for specified row and column coordinates. Optional arguments allow you to specify

March 14, 2018

Excel Online PivotTables

Inserting PivotTables in Excel Online is now possible. It’s still in its infancy with many features you may be used

March 9, 2018

AutoSUM Shortcut in Excel

The AutoSum shortcut, ALT+= (ALT and = at the same time), allows you to automatically sum rows and/or columns. How