Blog • Page 16 of 24 • My Online Training Hub

October 1, 2015

Save Settings in Registry Using Excel

If you want to save data from one Excel session to another, you can store this in the Windows registry.

September 25, 2015

Automatically Add Items to Data Validation List

If you are using data validation (and you should) to help you with your data entry, then you might find

September 15, 2015

New Charts in Excel 2016

With Office 2016 officially launching on September 22, 2015 I thought I’d give you a sneak peek at a few

September 11, 2015

Excel End of Period Dates

“Funny” days versus funny “Days” Guest post by Roger Govier, Microsoft Excel MVP Do you ever have “Funny” days? You

September 4, 2015

Add Data to Combo Box Drop Down List in Excel Form

If you've been following the previous posts in this series you'll know that by now we have a user form

August 25, 2015

Excel Flash Fill

Excel’s Flash Fill tool is so cool that you’ll be looking for reasons to use it! Introduced in Excel 2013

Excel forms, insert, update, delete data

August 21, 2015

Excel Forms – Insert, Update and Delete

Carrying on with the Excel form I created in an earlier post, I’m adding code to allow us to insert

August 11, 2015

Excel Fill Series

The Excel Fill Series tool is like having a bundle of tricks at your fingertips. It can help with one

August 4, 2015

Excel Copy and Paste Visible Cells Only

Have you ever wanted to only copy or paste visible cells? For example, below I have a table containing outstanding

July 28, 2015

Excel PivotTable Calculated Items by Position

A while back I wrote about how to create Excel PivotTable Calculated Items using the conventional approach of referencing the

July 23, 2015

Excel Sparklines

Put some spark in your chart! Excel Sparklines were introduced in Excel 2010 and are great for displaying the trend

July 9, 2015

Excel Form Data Validation

When creating Excel userforms it seems like a good idea to check the data going into the form before adding

July 9, 2015

Excel Date Picker

In my previous post about Excel forms the date picker I used was a 32 bit ActiveX control. If mentioning

July 2, 2015

Excel Forms

Excel forms, or Userforms, can be used to collect information from a user, validate it, then enter that data into

June 23, 2015

Excel Named Range Shortcut

An Excel Named Range is a powerful tool and something we should all be using to make our formulas quick

June 17, 2015

Apps for Office In Excel

I want to be clear that when I say apps for Office in Excel, what I am talking about are

June 9, 2015

Customize Default Excel Workbook

Did you know that when Excel opens a new workbook it uses a template called ‘Book’ to create the new

June 2, 2015

Excel Fill Value Down Rows based on Criteria

A few weeks ago one of our members, Kylie, sent me this question: “How can I fill column E

May 26, 2015

Pivot Charts

I’ve always thought after inserting a PivotTable that Excel should ask “would you like a PivotChart with that?”. I think

Highlight Selected Cell In Excel and Preserve Cell Format

May 20, 2015

Highlight Selected Cells in Excel and Preserve Cell Formatting

When you select a cell, or cells, in Excel, the row and column headers change color to indicate what you

May 12, 2015

Excel PivotTable Calculated Items

Inserting Excel PivotTable Calculated Items is a great way to analyse your data and automatically incorporate that analysis in your

May 6, 2015

Excel Slicers for Fiscal Years

There’s no built-in way to create Excel Slicers for fiscal years, however the solution is easily achieved by adding an

May 6, 2015

Excel Slicers for Rolling Periods

Excel Slicers for rolling periods, for example; the last 12 months, requires a column in your source data that looks

April 28, 2015

Create a Single Excel Slicer for Year and Month

In this tutorial we’re going to look at how we can create a single Excel Slicer for Year and Month,

April 20, 2015

Excel Worksheet Protection

Excel worksheet protection is a great way to prevent people accidentally messing up the reports you’ve spent hours creating. However,

April 14, 2015

Excel Chart Vertical Axis Text Labels

In this tutorial we’re going to look at how we can twist Excel’s arm into putting text labels on the

April 1, 2015

Charting Variances in Excel

In my previous life as an accountant one of my main tasks was to analyse budget vs actual variances and

March 30, 2015

Pausing or Delaying VBA Using Wait, Sleep or A Loop

You may want some way of pausing or delaying VBA code execution and you can do this with two functions

March 24, 2015

Excel Quick Analysis

A new feature in Excel 2013 is called Quick Analysis – it’s data analysis made easy, so easy my 6

March 17, 2015

Give me a SIGN, Excel

The Excel SIGN function returns a 1 if the number is positive, a zero if it’s zero and a -1