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

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

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

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

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

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,

March 10, 2015

Excel Filters 4 Ways

Filters are one of my most used Excel tools. They’re not fancy, but they sure do earn their keep. I’ve

January 19, 2015

Excel Custom AutoFilter with Wildcards

Excel’s Custom AutoFilter can perform a myriad of tasks that are often overlooked. Just last week we had a question

December 2, 2014

Excel Find Tool

You’ll be Amazed at what you can CTRL+F in Excel Excel’s Find tool is one of the first features you’re

November 25, 2014

Excel Advent Calendar

Today I’ve got a Christmas treat for you with an Excel Advent Calendar that Phil and I created. Before you

November 12, 2014

My 2014 Microsoft MVP Summit Experience

I arrived back from the 2014 Microsoft MVP Summit in Seattle on Sunday a little tired but bounding with excitement

September 15, 2014

Excel Custom Data Validation to Limit Entries

In this tutorial we're going to look at how Santa is using Excel Custom Data Validation to limit the number

July 8, 2014

Excel Protect Ranges with Different Passwords

Did you know you can set different passwords to protect specific ranges of your Excel worksheets? It’s called Allow Users

June 9, 2014

Excel Paste Special Operations

Copying and Pasting are two of the most common tasks you’ll perform in Excel. This is especially true for me

March 21, 2014

Excel Custom Number Formats

One of the most useful features in Excel are custom number formats yet they remain largely underused. In my Excel

March 5, 2014

Excel Designed Minecraft Cake

Each year our sons choose a cake they want me to make for their birthday. Now, I am no baker

February 12, 2014

Who Needs Word When Excel Has Got Fill Justify Text

They say the true Excel fan has uninstalled Word from their PC, and removed the F1 key from their keyboard

January 30, 2014

Curse You Excel Cursor

The Scenario You need to change the range referenced by your chart/conditional formatting/named range so you merrily open the Edit

January 10, 2014

Mac Excel Keyboard Shortcuts Cover

If you’re frustrated using Excel on a Mac because you don’t know the shortcut keys you’re used to using on

November 20, 2013

Excel Hyperlink Buttons

I like to use Excel hyperlink buttons in my Excel workbooks to help with navigation. I link them to a

November 7, 2013

Favourite Excel Shortcuts

Sometimes it’s the little things that make a big difference so today I’m going to share with you a few

October 30, 2013

Excel Tabular Data Format

Today I want to share with you an Excel secret. It’s so powerful that when you know this your Excel

August 28, 2013

Extracting Text Strings Using Excel’s Text to Columns

The Easy Way In this example I’m going to show you how you can extract the domain name from a