MrExcel.com | Microsoft Excel Tips, Tricks and Support

Your One Stop for Excel Tips & Solutions

About MrExcel

Consulting Services

Learn Excel Resources

Excel - Visual Learning

Challenge of the Month

Click Add as Fan in top right
of our Facebook page

MrExcel's Articles for Strategic Finances Magazine

Bill Jelen - "MrExcel" - writes monthly for the IMA periodical, 'Strategic Finanace Magazine'. Below you will find selected articles (in PDF Format) to enhance your proficiency using Microsoft Excel. Click the link for the issue you wish to view and download the zip file. Extract and read. It's that simple.

Be advised that these articles are the property of Strategic Finance Magazine and are not available for reproduction electronically or in print, neither in part nor in their entirety.

January 2010: "Year Over Year Analysis Using Excel"

March 2009: "Two Condition Formulas: SUMIF vs. SUMPRODUCT"

November 2008: "Creating Running Totals in a Pivot Table"

October 2008: "Referring to a Variable Range with OFFSET"

September 2008: "Looking Up Data from Worksheets Using INDIRECT"

August 2008: "Preparing Journal Entries with Pivot Tables"

July 2008: "Performing Two-Way Lookups Using MATCH and INDEX"

May 2008: "Subtotal Tricks"

April 2008: "Fill Handle Tricks"

March 2008: "Calculating Elapsed Days"

February 2008: "Replacing Nested IF Functions with a Lookup"

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

There are over 150,000 pages at MrExcel.com
Use Google
to search our site:

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel^TM is a registered trademark of Tickling Keys, Inc.