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

May 9, 2013

Excel BETWEEN Formula

A little while ago Brendan asked me how he could check if values in a list fall between two limits.

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 25, 2013

Excel Step Charts

I recently came back from a family skiing vacation in Whistler, Canada, which by the way was fantastic. Here we

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

April 2, 2013

Excel PivotTable Month Comparison [Video]

In this last tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how

March 26, 2013

Excel PivotTable Grouping

Battling to consolidate monthly figures into quarters, or segment data into numeric bands? Perhaps you're aiming for a bespoke grouping

March 19, 2013

Excel PivotTable Add Percentage of Total Column [Video]

Excel PivotTables make light work of analysing data but there are a few tricks once you get past the basics.

March 13, 2013

World’s Most Accurate Pie Chart

As fun as this chart is, it actually makes a valid point and that is; pie charts are (typically) not

March 6, 2013

Excel Conditional Formatting with Formulas

Excel’s Conditional Formatting tool is diverse with loads of built in rules that you simply point and click to use,

February 27, 2013

Excel PivotTables Unique Count 3 Ways

PivotTables are the Origamists of Excel. Folding and summarising data into almost any shape. I say 'almost' because until Excel

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

February 13, 2013

Excel Shortcut When Using Dates as Formula Criteria

Working with Dates in Excel can be frustrating because a date criteria in one formula doesn’t always work in another.

February 6, 2013

Excel Ignore Blanks in Data Validation List

Last week I showed you how you can extract a list that excludes blank cells for use in a data

February 1, 2013

Excel Remove Blank Cells from a Range

Last week Keith asked how he can ignore blanks in a range referenced by a Data Validation list. I think

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

January 17, 2013

Excel CONVERT Function

I don’t know about you but I’m forever converting things. In Australia we use the metric system. Our pounds are

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

December 12, 2012

Excel Wildcard Quirk Solved

Last week I wrote about using less than and greater than operators with letters like this: =COUNTIF(grade,"<B*") Here’s the post.

December 5, 2012

Excel COUNTIF Using Text Criteria

Last week Ann emailed me a question and before I had a chance to even look at it she emailed

November 27, 2012

Excel NETWORKDAYS Function

The Excel NETWORKDAYS function returns the number of whole working days between two date serial numbers, excluding weekends (Saturday &

November 21, 2012

Excel VLOOKUP Multiple Sheets

This week I had a question from Diedre asking if she can use VLOOKUP to check multiple sheets…. 17 different

November 15, 2012

Excel Time Calculation Tricks

The past few weeks I have had endless questions about time calculations in Excel. So this week I thought I

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

October 31, 2012

Excel Factor 21 Hyperlink Triptych

These Excel Factor tips were sent in by Zoran Stanojevic of Belgrade, Serbia. Words by Mynda Treacy Zoran has prepared

October 24, 2012

Excel Factor 20 Custom Number Format Disguise

This Excel Factor tip was sent in by Marc Joannette of Montreal, Canada. Words by Mynda Treacy. Marc's job involves

October 17, 2012

Excel Factor 19 Dynamic Dependent Data Validation

This Excel Factor tip was sent in by Roberto Mensa of Italy. Words by Mynda Treacy. Data validation lists are

October 10, 2012

Excel Factor 18 Dynamic Hyperlinks and the Magic Hash

This Excel Factor tip was sent in by Jerry Beaucaire of Bakersfield, California. Words by Mynda Treacy Hyperlinks can make

October 3, 2012

Excel Factor 17 Lookup and Return Multiple Matches

This Excel Factor tip was sent in by Bob Cooke of Lincolnshire, England. Words by Mynda Treacy Last week Bob

September 22, 2012

Excel Factor 16 Dynamic Lookup

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Words by Bryon Smedley. Enter your email