Blog • Page 11 of 24 • My Online Training Hub

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

February 22, 2018

Shortcut for Duplicating Formulae, Text and Objects in Excel

If you want to duplicate something you can copy (CTRL+C) and paste (CTRL+V). But there's a quicker way that only

February 14, 2018

Excel Infographics

Excel infographics, like the one below, are easy to build and there are loads of tools you can use to

February 5, 2018

Excel Forecast Sheet

The Excel Forecast Sheet and charts are a new feature available in Excel 2016. In just a few clicks you

January 31, 2018

Labelling Events in Excel Charts

Plotting data over time can reveal patterns and trends, but often blips in the data require further explanation. We can

December 14, 2017

Excel Chart Formatting Tips

Format your dashboards and reports fast with these pro Excel chart formatting tips. Watch the Video Pro Tip 1 –

December 6, 2017

Excel Dot Plot Charts

Dumbbells and Lollipop Charts Excel Dot Plots, dumbbells and lollipop charts are good for comparing one, two or three points

November 30, 2017

Visualizing Parts to a Whole in Excel Charts

When you think of visualizing parts to a whole in Excel charts the first thing that’s likely to come to

November 24, 2017

Writing UDFs in Excel With Python

My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to

November 17, 2017

Plot an Equation in Excel Using Python

Something I've wanted to do easily in Excel is plot equations. If I have something like 2x2 + 3x +

November 6, 2017

Excel PivotTable Error Handling

Obviously, we don’t want our PivotTables littered with #DIV/0! and #NULL! errors if we’re presenting them in a report (like

November 2, 2017

Excel PivotTable Percentage Change

PivotTables can make quick work of summarising and analysing data and they have some handy built in percentage calculations available

October 26, 2017

Excel 4.0 Macro Functions

Before VBA there were XLM macros. VBA was introduced in Excel version 5, so these Excel macros are also known

October 25, 2017

Extract Date or Time from a Date and Time

We often need to extract the date or time portion from a date-time serial number for use in other functions.

October 25, 2017

Excel DATE Function

The Excel DATE function combines separate year, month and day values and converts them into a date serial number formatted

October 25, 2017

Convert Month Names to Numbers

Often, we'll have a list of month names that we want to convert to a date, or even just convert

October 24, 2017

Convert Dates to Text

If you want to use a date in a chart label, or you want to concatenate a date with some