MrExcel Articles

Laissez les bons temps rouler

bill@mrexcel.com (Bill Jelen) — Tue, 21 Feb 2012 09:01:02 GMT

Check out the Wikipedia Write up to Learn Mardi Gras 2012

Learn Excel 2010 to Use MAXIF

bill@mrexcel.com (Bill Jelen) — Tue, 21 Feb 2012 09:01:02 GMT

A Column of Dates and Products but when did it ship last?

Learn Excel 2010 looks at Words with Dates

bill@mrexcel.com (Bill Jelen) — Mon, 20 Feb 2012 09:01:02 GMT

Text and Dates in the same Cell

MrExcel and CFO Webcast 9 Feb 2012

bill@mrexcel.com (Bill Jelen) — Wed, 08 Feb 2012 09:01:02 GMT

12 Excel Formulas That Will Cut Hours Out of Your Work Day

MrExcel and CFO Webcast 3 Feb 2012 at 2PM EDT

bill@mrexcel.com (Bill Jelen) — Thu, 02 Feb 2012 09:01:02 GMT

Excel Macros for Finance Teams

MrExcel Webcast with CFO Today at 2PM EDT

bill@mrexcel.com (Bill Jelen) — Wed, 01 Feb 2012 09:01:02 GMT

Making Workbooks Look Great Today

Learn Excel 2010 to Stop Speak On Enter

bill@mrexcel.com (Bill Jelen) — Mon, 30 Jan 2012 09:01:02 GMT

Turn Off the Text To Speech Function in Excel

Dueling Excel and Total All LOOKUPs

bill@mrexcel.com (Bill Jelen) — Fri, 27 Jan 2012 09:01:02 GMT

Methods that use SUMPRODUCT ARRAYs and More

WEBCAST TODAY MrExcel on CFO Online at 2PM

bill@mrexcel.com (Bill Jelen) — Fri, 27 Jan 2012 09:01:02 GMT

Learn Pivot Table Fundamentals

MrExcel and CFO Onlin Webcast 27 January 2012

bill@mrexcel.com (Bill Jelen) — Thu, 26 Jan 2012 09:01:02 GMT

Pivot Table Fundamentals

Learn Excel 2010 to Move Rows Where You Want Them

bill@mrexcel.com (Bill Jelen) — Thu, 26 Jan 2012 09:01:02 GMT

Bill looks at a few methods to move Rows

Learn Excel using Pivot Tables to Count Between Ranges

bill@mrexcel.com (Bill Jelen) — Tue, 24 Jan 2012 09:01:02 GMT

Today Bill uses a Pivot Table to Count Between Ranges

Learn Excel to Remove An Extra Chart Series

bill@mrexcel.com (Bill Jelen) — Mon, 23 Jan 2012 09:01:02 GMT

Remove an unwanted, additional series from a chart

VLOOKUPS Awesome Quick e-Media Book Intro Sale

bill@mrexcel.com (Bill Jelen) — Fri, 20 Jan 2012 09:01:02 GMT

First of Its Kind VLOOKUP Book for Beginner to Advanced

Dueling Excel Conditionally Formats 15 Percent Change

bill@mrexcel.com (Bill Jelen) — Fri, 20 Jan 2012 09:01:02 GMT

Mike and Bill Look at Conditional Formatting in a Different Way

MrExcel and CFO Online Today 19 January 2012

bill@mrexcel.com (Bill Jelen) — Thu, 19 Jan 2012 09:01:02 GMT

Advanced Budgeting and Forecasting Webcast

Learn Excel 2010 while Counting Between Ranges

bill@mrexcel.com (Bill Jelen) — Thu, 19 Jan 2012 09:01:02 GMT

Use your =COUNTIF Formulas to find values between ranges

CFO Excel Pro Weekly E Newsletter

bill@mrexcel.com (Bill Jelen) — Wed, 18 Jan 2012 09:01:02 GMT

Featuring MrExcel

Learn Excel or Show Us Your MS Excel Tattoo

bill@mrexcel.com (Bill Jelen) — Mon, 16 Jan 2012 09:01:02 GMT

Do you have a Microsoft Excel Tattoo

MrExcel Rocks iTunes with the Learn Excel App

bill@mrexcel.com (Bill Jelen) — Fri, 13 Jan 2012 09:01:02 GMT

Learn Excel on your iPhone or iPad

Learn Excel and Bill Jelen Rock The Blogoshpere at Microsoft

bill@mrexcel.com (Bill Jelen) — Fri, 13 Jan 2012 09:01:02 GMT

MrExcel Featured on MS Office Blog

Learn Excel 2010 Random Numbers with Mean and Standard Deviation

bill@mrexcel.com (Bill Jelen) — Thu, 12 Jan 2012 09:01:02 GMT

Clever technique to Generate Random Realistic Numbers

MrExcel and CFO Webcast Reminder for 13 January

bill@mrexcel.com (Bill Jelen) — Wed, 11 Jan 2012 09:01:02 GMT

Excel for Budgeting and Forecasting January 13 2012

Learn Excel 2010 and Avoid Format Changes on Import

bill@mrexcel.com (Bill Jelen) — Wed, 11 Jan 2012 09:01:02 GMT

Avoiding Format changes when Importing to Excel

Learn Excel 2010 with Automatic Invoice Numbers

bill@mrexcel.com (Bill Jelen) — Tue, 10 Jan 2012 09:01:02 GMT

Generate The Next Invoice Number in Workbook

MrExcel Webcast with CFO Online 13 January 2012

bill@mrexcel.com (Bill Jelen) — Mon, 09 Jan 2012 09:01:02 GMT

Excel for Budgeting and Forecasting January 13 2012

Learn Excel to Improve the Save Form to Database

bill@mrexcel.com (Bill Jelen) — Mon, 09 Jan 2012 09:01:02 GMT

Part Two of this series looks at VBA Code Improvements

VLOOKUPS Awesome Quick e-Media Book on Sale Now

bill@mrexcel.com (Bill Jelen) — Fri, 06 Jan 2012 09:01:02 GMT

First of Its Kind VLOOKUP Book for Beginner to Advanced

Learn Excel to Save a Form to a Database

bill@mrexcel.com (Bill Jelen) — Thu, 05 Jan 2012 09:01:02 GMT

Part One of Two

Learn Excel VLOOKUPs with VLOOKUP Awesome Quick

bill@mrexcel.com (Bill Jelen) — Wed, 04 Jan 2012 09:01:02 GMT

Bill Jelen has a Brand New Enhanced Multimedia Guide to VLOOKUPS

Learn Excel 2010 using Running Total AutoFill

bill@mrexcel.com (Bill Jelen) — Wed, 04 Jan 2012 09:01:02 GMT

AutoFill a Formula as you enter new data in a Worksheet

Learn Excel 2010 with Dueling Sparkline Predictions

bill@mrexcel.com (Bill Jelen) — Tue, 03 Jan 2012 09:01:02 GMT

Will the Harlem Globetrotters Lose to The Generals

Learn excel 2010 while Filtering To Unique

bill@mrexcel.com (Bill Jelen) — Fri, 30 Dec 2011 09:01:02 GMT

Try out the Excel Advanced Filter

Learn Excel 2010 with The New Excel Help

bill@mrexcel.com (Bill Jelen) — Thu, 29 Dec 2011 09:01:02 GMT

You might see your favorite Excel guru in Excel Help from now on

Learn Excel 2010 with Two Subtotal Sets Above

bill@mrexcel.com (Bill Jelen) — Wed, 28 Dec 2011 09:01:02 GMT

Have Two Subtotals at the Top of Your Data Set

Learn Excel 2010 Revisits Copying Many Worksheets

bill@mrexcel.com (Bill Jelen) — Tue, 27 Dec 2011 09:01:02 GMT

A Few More Methods to Reproduce Worksheets Fast

Learn Excel and Post Your Worksheet to The Message Board

bill@mrexcel.com (Bill Jelen) — Mon, 26 Dec 2011 09:01:02 GMT

Post your worksheet to the MrExcel Message Board using HTMLMaker

Learn Excel looks at A New iPad Sampler Book

bill@mrexcel.com (Bill Jelen) — Sun, 25 Dec 2011 09:01:02 GMT

Bill shows us a great e-Media Book Sampler for FREE

Learn Excel 2010 Looks At Word for Gift Tags

bill@mrexcel.com (Bill Jelen) — Fri, 23 Dec 2011 09:01:02 GMT

Microsoft has Free Gift Tag Templates for YOU

Learn Excel with a Dropdown To Vary Your Chart

bill@mrexcel.com (Bill Jelen) — Thu, 22 Dec 2011 09:01:02 GMT

Use a Dropdown to show currency or units

Learn Excel from MrExcel Holiday Give Away

bill@mrexcel.com (Bill Jelen) — Wed, 21 Dec 2011 09:01:02 GMT

Tweet to Win a Free Deluxe Color Addin from MrExcel

Dueling Excel finds Text and Associated Cubic Feet

bill@mrexcel.com (Bill Jelen) — Fri, 16 Dec 2011 09:01:02 GMT

Search for Text and the Value associated with that specific Text

Today 16 December 2011 MrExcel and CFO Online

bill@mrexcel.com (Bill Jelen) — Fri, 16 Dec 2011 09:01:02 GMT

Excel Macros for Finance Teams

MrExcel and CFO Webcast 16 December 2011

bill@mrexcel.com (Bill Jelen) — Fri, 16 Dec 2011 09:01:02 GMT

Begin to Shave Hours off of Budgeting Forecasting and More

Learn Excel with Random Drug Testing

bill@mrexcel.com (Bill Jelen) — Thu, 15 Dec 2011 09:01:02 GMT

Set up a Code Free Workbook to Randomly Select for Monthly Screening

Todays Reminder for MrExcel and CFO Online Webcast

bill@mrexcel.com (Bill Jelen) — Thu, 15 Dec 2011 09:01:02 GMT

Excel Macros for Finance Teams

Learn Excel putting a Worksheet Name in a Cell

bill@mrexcel.com (Bill Jelen) — Wed, 14 Dec 2011 09:01:02 GMT

Use a MID of the Sheet Name to fill in the correct Date in a Cell

MrExcel and CFO Webcast 15 December 2011

bill@mrexcel.com (Bill Jelen) — Wed, 14 Dec 2011 09:01:02 GMT

Begin to Shave Hours off of Budgeting Forecasting and More

Learn Excel while Renaming 31 Worksheets with VBA

bill@mrexcel.com (Bill Jelen) — Tue, 13 Dec 2011 09:01:02 GMT

With One Line of Code Rename 31 Worksheets

MrExcel and CFO with Excel Macros for Finance Teams

bill@mrexcel.com (Bill Jelen) — Mon, 12 Dec 2011 09:01:02 GMT

Begin to Shave Hours off of Budgeting Forecasting and More

Learn Excel to Duplicate My Worksheets

bill@mrexcel.com (Bill Jelen) — Mon, 12 Dec 2011 09:01:02 GMT

Duplicate a Months Worth of Worksheets in Seconds

Dueling Excel Defends Excel

bill@mrexcel.com (Bill Jelen) — Fri, 09 Dec 2011 09:01:02 GMT

Mike and Bill Defend Excel and Its Capabilities

Today at 1PM MrExcel and CFO Webcast

bill@mrexcel.com (Bill Jelen) — Thu, 08 Dec 2011 09:01:02 GMT

Designing and Building Financial Dashboards with Excel

MrExcel Learns Excel 2010

bill@mrexcel.com (Bill Jelen) — Thu, 08 Dec 2011 09:01:02 GMT

Bill Learns that Zero Point Zero Two can be done easier

December 8 with MrExcel and CFO Online

bill@mrexcel.com (Bill Jelen) — Wed, 07 Dec 2011 09:01:02 GMT

Designing and Building Financial Dashboards with Excel

Learn Excel with a Picture Lookup

bill@mrexcel.com (Bill Jelen) — Wed, 07 Dec 2011 09:01:02 GMT

Use a VLOOKUP to return an Image instead of a Value

MrExcel and CFO present Financial Dashboards in Excel

bill@mrexcel.com (Bill Jelen) — Tue, 06 Dec 2011 09:01:02 GMT

Designing and Building Financial Dashboards with Excel

Cyber Monday II Sale Redux

bill@mrexcel.com (Bill Jelen) — Mon, 05 Dec 2011 09:01:02 GMT

This Sale will end without notice

Learn Mail Merge from Excel Data for Making Labels

bill@mrexcel.com (Bill Jelen) — Mon, 05 Dec 2011 09:01:02 GMT

Excel Data to Word 2010 for Labels

Dueling Excel looks at Rounding Invoices

bill@mrexcel.com (Bill Jelen) — Fri, 02 Dec 2011 09:01:02 GMT

Formatting as Facade and more

Learn Excel 2010 dealing with Table Frustrations

bill@mrexcel.com (Bill Jelen) — Thu, 01 Dec 2011 09:01:02 GMT

Steps in Resolving Frustrations with Formulas that point into Tables

Learn Excel 2010 To Repeat A Macro for Each Cell

bill@mrexcel.com (Bill Jelen) — Wed, 30 Nov 2011 09:01:02 GMT

Repeat A Macro for Each Cell in Column A

The ePub and Kindle Book Sale Is Still Going!

bill@mrexcel.com (Bill Jelen) — Tue, 29 Nov 2011 09:01:02 GMT

At least one more day to take advantage of this deal

Learn Excel 2010 Sums Over The Threshold

bill@mrexcel.com (Bill Jelen) — Tue, 29 Nov 2011 09:01:02 GMT

Sum the amts in a Range greater than a threshold stored in another cell.

Learn Excel and Column Widths in Excel 2008 for Mac

bill@mrexcel.com (Bill Jelen) — Mon, 28 Nov 2011 09:01:02 GMT

Applying Different Widths within The Same Column

Learn Excel 2010 Revisits Ranking Tie Breakers

bill@mrexcel.com (Bill Jelen) — Sun, 27 Nov 2011 09:01:02 GMT

Using a Temporary Column to Rank

Cyber Monday Deals are Available Now

bill@mrexcel.com (Bill Jelen) — Sun, 27 Nov 2011 09:01:02 GMT

Check out Cyber Monday Deals at The MrExcel Store

American Express small Business Saturday Deals

bill@mrexcel.com (Bill Jelen) — Fri, 25 Nov 2011 09:01:02 GMT

2 Book Reader and Tablet Deals on Sale Now

Black Friday Deals a Day Early on MrExcel

bill@mrexcel.com (Bill Jelen) — Thu, 24 Nov 2011 09:01:02 GMT

Black Friday Deal Weekend Starts Now

Learn Excel from MrExcel Podcast and BFSBSCM

bill@mrexcel.com (Bill Jelen) — Thu, 24 Nov 2011 09:01:02 GMT

Thanksgiving and Black Friday Weekend Specials at MrExcel

BlackFriday CyberMonday and Other Specials

bill@mrexcel.com (Bill Jelen) — Wed, 23 Nov 2011 09:01:02 GMT

Tomorrow The MrExcel Blog Podcast will have more details SaveThisLink

Learn Excel 2010 Numbers Only the Visible Rows

bill@mrexcel.com (Bill Jelen) — Wed, 23 Nov 2011 09:01:02 GMT

An example of The New AGGREGATE Function in Excel 2010

Black Friday Savings are Coming to MrExcel Stay Tuned

bill@mrexcel.com (Bill Jelen) — Wed, 23 Nov 2011 09:01:02 GMT

BlackFriday CyberMonday and More at the MrExcel Store starting late on Nov 24th

Learn Excel 2010 working with Latitude and Longitude

bill@mrexcel.com (Bill Jelen) — Tue, 22 Nov 2011 09:01:02 GMT

Bill looks at Custom Number Formats for Location

Learn Excel 2010 with a Date Stamp Next to a Yes

bill@mrexcel.com (Bill Jelen) — Mon, 21 Nov 2011 09:01:02 GMT

Add a date to the right of a cell where someone enters Yes

Dueling Excel Rank Ties by Weight

bill@mrexcel.com (Bill Jelen) — Fri, 18 Nov 2011 09:01:02 GMT

Dueling Excel looks at Scores and Tie Breaking

Learn Excel 2010 to Wrap and Resize

bill@mrexcel.com (Bill Jelen) — Thu, 17 Nov 2011 09:01:02 GMT

Combine Wrap Cells and Shrink to Fit using a little VBA

Learn Excel 2010 at Random with No Repeats

bill@mrexcel.com (Bill Jelen) — Wed, 16 Nov 2011 09:01:02 GMT

Select Random weeks without any repeats

TODAY MrExcel and CFO Online Covering Tricky Chart Work

bill@mrexcel.com (Bill Jelen) — Mon, 14 Nov 2011 09:01:02 GMT

Tricky Charts for Presentations