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

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

July 10, 2013

Excel Form Controls

Written by Alan Murray of Computergaga. Form controls such as option buttons, combo boxes and check boxes allow you to

June 5, 2013

Excel Combo Box KO’s Data Validation

Data Validation or Drop Down Lists are one of Excel’s greatest features, but I have one gripe with them, and

using excel table as data validation source

April 30, 2013

Excel Tables as Source for Data Validation Lists

I’ve set up a table with some team names that I want to use in a Data Validation list. The

April 18, 2013

Excel Advanced Filters

To be honest I don’t use Advanced Filters much. I tend to use the regular AutoFilter, or if I need

April 10, 2013

No More Back and Forth Between Tabs

Moving back and forth between worksheets in a large workbook can be tedious. Of course you can use the shortcut

February 20, 2013

Excel Surveys (Forms) an Easy Way to Collect Data

Note: Excel Survey is now called Forms. A while back Quiara asked me if there was a way she could

January 30, 2013

Excel Same Same but Different

Help! Do you use a non-US-English version of Excel? If so, now is your chance to help out the wider

December 19, 2012

Merry Christmas 2012 and Happy New Year 2013

2012 has been an amazing and rewarding year at My Online Training Hub and we’re excited to see what 2013

November 7, 2012

Excel Factor Voting Roundup

Back in June this year I had an idea to hold an X-Factor style competition where anyone could submit an