Excel Formulas Archives • Page 5 of 7 • My Online Training Hub

June 30, 2013

Excel ACCRINT Function

The Excel ACCRINT function returns the accrued interest for a security that pays interest periodically. The Syntax is: ACCRINT(issue, first_interest,

June 25, 2013

Excel Bank Reconciliation Formula

This week I had a question from Dominique that took me back to my accounting days. She asked “how can

June 12, 2013

Excel Find Column Containing a Value

Last week I had an email from Mike asking how he can lookup a suburb in a range of columns

May 29, 2013

Excel Formulas

Here you'll find a list of common Microsoft Excel formulas and functions explained in plain English, and applied to real

May 16, 2013

VLOOKUP Multiple Values in Multiple Columns

A few weeks ago David T asked me to help him understand a VLOOKUP formula in a workbook he’d inherited

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.

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 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 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 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

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 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

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

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 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

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 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