Mynda Treacy, Author at My Online Training Hub • Page 16 of 19

September 19, 2012

Excel Factor 15 The Lazy Lookup

This Excel Factor tip was sent in by Kathy Carmel of Santa Barbara, California. Words by Mynda Treacy. Kathy uses

September 12, 2012

Excel Factor 14 Interleave Data from Two Columns into One

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. I have to admit, this problem doesn't come up

September 5, 2012

Excel Factor 13 Handy Tips & Tricks

These Excel Factor tips are from Dr Isaac Gottlieb, professor at Temple University in Philadelphia. Every month Isaac publishes a

August 29, 2012

Excel Factor 12 Secret EVALUATE Function

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Suppose you receive a spreadsheet with calculations,

August 22, 2012

Excel Factor 11 Forecasting Tricks

These Excel Factor tips were sent in by David Kramer of Denver, Colorado, USA. Tip 1: Include or exclude parts

August 15, 2012

Excel Factor 10 Conditional Formatting Painting by Numbers

This Excel Factor entry was sent in by Rob Anderson of Oxfordshire, UK. Project planning and other tracking worksheets can

August 8, 2012

Excel Factor 9 Count Unique Items in a List

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. There are times when you wish to

August 3, 2012

Excel Factor 8 Highlight Cells Containing Formulas

This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or

July 25, 2012

Excel Factor 7 In Cell Charts

This Excel Factor tip is from Dr Isaac Gottlieb, professor at Temple University in Philadelphia. Words by Mynda Treacy Excel

July 18, 2012

Excel Factor 6 Auto Refresh PivotTables

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Excel PivotTables are one of the greatest

July 13, 2012

Excel Factor 5 Dynamic Print Area

The following Excel Factor entry was sent in by Daniel Ferry, founder of Excel enthusiast blog, Excel Hero. Often an

July 11, 2012

Excel Factor Entry 4 INDEX and MATCH Two Criteria

The need to look up and match multiple criteria is quite common; however as with most things in Excel there

July 4, 2012

Excel Factor Entry 3 Re-format Data Using Formulas

Importing data into Excel from other systems rarely goes without the need to fix formatting before you can even use

June 27, 2012

Excel Factor Entry 2 – AutoFilter

If you use Excel Filters then you’ll love this time saving tip. This tip was sent in by Mohammed Mustafa

June 20, 2012

Excel Factor Entry 1 – Reverse PivotTable

How to Create a Reverse PivotTable - this is genius. This tutorial was sent in by Bryon Smedley of Bristol,

June 20, 2012

Calling All Excel Enthusiasts – Excel Factor Competition

Got a cool Excel trick you're proud of? I thought it'd be fun to hold an Excel Factor competition. Think

June 6, 2012

Secret Excel DATEDIF Function

Want to calculate the number of months between two dates? One little known way is to use the secret Excel

May 29, 2012

Excel COUNT Coloured Cells

From time to time I get asked; “how can I count cells formatted in a particular colour”. Aka 'color' if

May 24, 2012

Find the Last Value in a Column

The other day a member emailed me the following question: “I created a check book in Excel 2010 and I

May 16, 2012

Funky Shapes and Fills in Excel Comments

Did you know you can jazz-up your Excel Comments using Shapes, or even insert a Picture that conveys your message?

May 10, 2012

List Sheet Tab Names with Excel VBA

As I promised last week, today’s tutorial is a dead easy macro that will allow you to extract a list

May 2, 2012

Excel 3D SUMIF Across Multiple Worksheets

No, no, no, no, no I’m not talking about the latest 3D animated movie. I’m talking about how you can

April 25, 2012

Force Excel to Open on a Specific Sheet

A few weeks ago one of our members, Perrin asked; “Is there a way to force a workbook to always

April 19, 2012

Excel RANK, RANK.AVG and RANK.EQ Functions

No prizes for guessing what the Excel RANK functions do and I’ll cover them in a moment. But first you

April 10, 2012

Invest $x at 4.75% for 5 Years to Make $15,000

I received an email from Stacey a few weeks ago asking: “Which formula would I use to find the initial

April 3, 2012

Excel Go To Special is Very Special Indeed!

I can’t believe I haven’t already written a tutorial about Excel’s Go To Special feature. It is one of my

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