Blog • Page 22 of 24 • My Online Training Hub

March 27, 2012

Excel EOMONTH Function

Continuing on from last week’s EDATE function, today we’re looking at the Excel EOMONTH function. If you use Excel to

March 20, 2012

Excel EDATE Function

If you need to calculate due dates for projects or payments then Excel’s EDATE function will make life easy for

March 13, 2012

Excel MIN IF Array Formula

A few weeks ago Karine asked me if there was a way she could find the minimum value for

March 7, 2012

Calculate How Long to Make $1m with NPER

James wrote to me and asked: if he buys shares worth $2000 and gets 4% return, how many times does

March 1, 2012

SUMIFS Formula Referencing Cells Containing Dates

Formulas containing dates and time in Excel can be frustrating if you don’t understand how they work. And even if

February 22, 2012

Excel Evaluate Formula Tool

From time to time I get asked the question “what order do formulas evaluate?” The acronym BEDMAS can help you

February 15, 2012

VLOOKUP Multiple Criteria

I had an email from Bobcat today asking how to lookup data that is spread across multiple columns. Table

February 8, 2012

Excel Data Validation With Dependent Lists

Using Data Validation to restrict what gets entered in a cell or range of cells is great for standardising your

February 3, 2012

What If Analysis Using Excel Scenarios

What if my side eBay bike business sold an extra 10%, what if I increased my price by $15 per

January 27, 2012

Excel AVERAGE, AVERAGEIF and AVERAGEIFS

Let’s say that a baby learning to crawl is an analogy for learning the AVERAGE function in Excel. Then learning

January 18, 2012

ROUNDUP and ROUNDDOWN with a Twist

Last week I had a question from Dan that I’d never come across before. Dan has a dress shop with

January 12, 2012

INDEX MATCH With a Twist

My Toughest Excel Challenge So Far! Recently a member contacted me with a VLOOKUP question, but when I further understood

December 14, 2011

Excel INDIRECT Function

The Excel INDIRECT Function has many applications and perhaps its simplest is to fix a range of cells you want

December 7, 2011

Excel VLOOKUP Multiple Values

For some of us we use the VLOOKUP function all the time and for the most part is does exactly

November 30, 2011

Excel LARGE and EOMONTH Array Function

I’m working on a dashboard for a client and I’ve set it up so that they can choose which month

November 23, 2011

Cool INDEX Function Trick

What say you want to find the percentage increase or decrease for the last value in a list compared to

November 16, 2011

Excel Average Top 3 Values

You may already know you can find the 3rd highest value using the LARGE function, but what if you want

November 10, 2011

Excel Advanced Filter Unique Records

Do you ever want to extract a list of unique records from a massive list like the one in column

November 2, 2011

Excel Conditional Formatting Zebra Stripes

It's ok, no zebras get hurt in this process, it's actually all built in to Excel's Conditional Formatting 🙂 Conditional

October 25, 2011

Top 5 Mistakes With Reports in Excel

There's a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some

October 21, 2011

Excel Dynamic Text Formulas Trick [FREE VIDEO]

Inserting text into a text box is one cool trick, but being able to have that text update when your

October 4, 2011

Excel Photo Album of Our New Zealand Trip

We just arrived back from two weeks travelling around New Zealand with 3 other families. While there we managed to

September 28, 2011

Excel TIME Function

The Excel TIME function combines separate hour, minute and second values and converts them into a time serial number. If

September 21, 2011

Excel CONVERT Functions

With a family of 4 fussy eaters to feed (well actually, 3 fussy eaters and myself) I do a lot

September 14, 2011

Excel Paste Shortcut

The other day I was in an Excel forum helping answer some questions. I like to help, because….well, I like

September 7, 2011

Easy Excel Database Functions

Excel Database functions have been around for donkey's years so it's surprising that not many people know about them. They

August 31, 2011

Excel Wildcards in your SUMIF, COUNTIF and VLOOKUP

Wildcards *?~....what am I talking about? And no, it's not an expletive. Let’s start with an example. COUNTIF using Wildcards

August 24, 2011

Excel SEARCH and You Will FIND

In Excel there are two almost identical functions; SEARCH and FIND. The SEARCH and FIND functions allow you to find

August 17, 2011

Create a Pivot Table Direct From Access

Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data

August 10, 2011

Excel Chart Axis Label Tricks

So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look