MrExcel Articles

Dont Fear The Spreadsheet and Create That Chart

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

Need a Chart? Never Created a Chart? Here is how you do it!

Learn Excel 2010 for More or Less Validation

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

Further adjusting on the Data Validation of Episode 1606

Learn Excel 2010 for Truly Dependent Validation

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

A Visit to Episode 1583 brings us to Validation of 1606 - Watch this!

Dont Fear The Spreadsheet just Protect It

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

Mark as Final will NOT protect your Workbook - but here is a secret

Dont Fear The Spreadsheet and Copy The Formula Down

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

Its Easy To Copy Down A Formula! Check this out!

Dont Fear The Spreadsheet just Hide Those Columns

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

How to Hide - Unhide and Keep Sensitive Data Out Of Sight!

Learn Excel 2010 to Conditional Format Chart Data

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

Conditional Formatting for My Chart? Yes- We Have That!

Dont Fear The Spreadsheet and Work With Those Hyperlinks

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

Learn How to Select -or Not Select- Hyperlinks in Excel Workbooks

Special 1600TH Podcast Education Bundle Offer Today Only

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

Expires At 6PM EDT TODAY! The Clock Is Ticking - Go Get Your Resources!

Learn Excel 2013 for Web Based Data Manipulation

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

Excel 2013 is Really Made for Use with Web-Based Stuff! Check this out!

Learn Excel 2010 to know Where is My Userform

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

The Userform will not show - simple code and button but no Userform?

Learn Excel 2013 with a Real GUASS Function Help Topic

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

Bill thought that the Excel 2013 Help topic for GAUSS was less than helpful - so he made his own.

More Excel 2013 Reviews from MrExcel

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

Can we convince Bill to get the next weeks worth of Excel 2013 Review ready for Next Week!?

Dont Fear The Spreadsheet just Compare That Data

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

Does the Data in these 2 Identical Looking Workbooks Match? Find Out!

Learn Excel 2010 and Create Several Charts from One Pivot Table

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

Is it possible to Create and Refresh Several Charts from just One Pivot Table?

Learn Excel 2010 to Remove the Data Match Error

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

Today Bill demonstrates a tip from Anna in Boston to Remove the Data Match Error

Dont Fear The Spreadsheet Creates A Formula

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

Learn How to Create Your Very First Formula - Right Now!

Learn Excel 2010 and Fix That Chart Legend Gap

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

Bill looks at why a Chart Legend may be spaced oddly and what to do to fix it

Learn Excel 2013 because It Has Its Own App Store

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

Yes Excel 2013 comes with an App Store and Much More!

Learn Excel 2013 to see Message Boxes with Attitude

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

Today a review of New Message Boxes in Excel 2013 AND A Contest!

Learn Excel 2013 for Awesome Pivot Tables

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

Bill Loves Pivot Tables and So Will You with Excel 2013!

Learn Excel 2013 is The Excel For Rookies

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

Absolutley Brand New to Excel - then Excel 2013 Is Your Version!

Prelimary Review of Excel 2013 by Bill Jelen

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

Its a New Version of Excel and Bill is Excited to Share his findings!

Learn Excel 2013 from MrExcel

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

Today Begins A Week-Long Look At Microsoft Excel 2013

Learn Excel 2010 to Move Rows in Excel

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

Bill has a Better Technique for Moving Rows of Data for us today!

17 Billion Cells per Worksheet

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

Insert Your Data into Exisiting Data in Excel

Learn Excel 2010 to use Worksheet Level Names

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

Whats In A Name? Lets Look At It From Worksheet Level!

Learn Excel 2010 and get a Paste Surprise

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

Its Like Excel Trick or Treat Today - See How Excel and the Clipboard Do Not Communicate

Learn Excel 2010 to Remove Invalid Cell References

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

The Worksheet is gone and there are no dependencies but I still have #REF! in Name Manager

MrExcel Goes To Print

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

Bill Tours Hess Print Solutions to learn how a book is printed and assembled!

Named Range Box Expand and Implicit Intersection

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

Today Bill looks at Named Ranges, Expanding the Name Box and Implicit Intersections - Part I of IV

Dont Fear The Spreadsheet Makes Dollar Wise Sense

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

My Attempts at Dollars n Cents Formatting Are Not Adding Up!

Learn Excel 2010 to Chart Cluster Stack Charts Again

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

Stacks, Clusters, Side-by-Side with Customization

Learn Excel 2010 to Match List Contents

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

Two Lists with One Goal - Find The Matches

Learn Excel Interactive View from MrExcel

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

No Words for This One - Just Watch The Podcast!

Why Does My Number Data Keep Corrupting

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

Pound Signs, Hash Marks, Number Signs - they are Everywhere!

Learn Excel 2010 and Lock Formulas in All Directions

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

Even at 33K Feet Excel Performs Surprising Tasks

Learn Excel 2010 to save the day with a Pivot Table

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

See how Bill Transforms a Two-Way Table to a Linear Table with a Pivot Table

Dueling Excel and The Electoral College

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

A Wednesday Edition - Using State by State Electoral College Statistics

Advanced Pivot Tables Today at 2PM

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

MrExcel and CFO get together for Advanced Pivot Tables Webcast 18Jul12 at 2PM EDT

Get The Job Impress Your Friends Learn Excel from The Beginning

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

Excel from the first icon click! Dont Fear The Spreadsheet - Read about it Here!

Learn Excel 2010 to use VLOOKUP in a Range

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

A VLOOKUP that actually ends with TRUE today!

Why is my 1 Page Report now Several Pages of Cut Off Data

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

Page Breaks Printing and Making A Neat One Page Report

Today at 2PM EDT Pivot Table Fundamentals

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

A Brand NEW Pivot Table Fundamentals Webcast with Bill Jelen and CFO TODAY

Dueling Excel looks at Descriptive Statistics

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

Bill Uses a Pivot Table to wrangle Functions and Mike approaches it differently

How Can I Access Frequently Used Commands in Excel

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

Dont move from Tab to Tab - Use The Quick Access Toolbar!

MrExcel and CFO Look at Pivot Tables 29Jun2012

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

Pivot Table Fundamentals 2PM Eastern on CFO - Click for Details!

Learn Excel 2010 to Get Only Gold Stars

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

Alternate methods to apply icons in your workbook for grading, rating, fun

CFO and MrExcel Today with VLOOKUP

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

Follow the link to get registered for todays event starting at 2pm EDT!!

Learn Excel 2010 and Extract by Sevenths

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

Extract Every Nth Item from The List

Bill Jelen on CFO today at 2pm EDT

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

90 Minute Power Excel with MrExcel and CFO 22-June-2012 at 2pm EDT

I Selected My Range and Why Is The Corner Cell Always White

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

The Cell I start in to select a Range is always white - why wont it select?

Learn Excel 2010 to Change Your Currency Formatting

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

Remove or Replace Decimals and Commas or Rearrange them to reflect Currecy Values

Why Did Excel Change My Numbers to Dates

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

Dont Fear The Spreadsheet - 12-13 is now 13-Dec, why?

A Microsoft Excel Beginner Book Like No Other

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

Dont Fear The Spreadsheet - learn about it!

Learn Excel to Paste Special without Blank Cells

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

From the book Excel Outside the Box by Bob Umlas, Bill shows us this technique

Dont Fear The Spreadsheet is Available

bill@mrexcel.com (Bill Jelen) — Sun, 17 Jun 2012 09:01:02 GMT

The Beginners Book of Beginners Books for Microsoft Excel! Learn About it!

Learn Excel to Create a Circular Reference to pull Data

bill@mrexcel.com (Bill Jelen) — Sun, 17 Jun 2012 09:01:02 GMT

Find out how to get Data into Merged Cells

Learning Excel from MrExcel REALLY Pays Off

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

Harini871 Won The Lottery Using Podcast 453 - check it out!

Learn Excel 2010 finding Auto Average

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

Today MrExcel Learns Excel 2010 with a Excel Novice Question

Learn Excel Special Weekend Edition Podcast

bill@mrexcel.com (Bill Jelen) — Sat, 28 Apr 2012 09:01:02 GMT

The Microsoft Calculator Utility - have you ever really checked it out?

Dueling Excel works out Adding Characters Based on Conditions

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

If This Exists In That Place Add These and If Not Then Add These In This Other Place

Get that FREE 25GB of Space Before Its Gone

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

Time is Running Out for the FREE 7GB to 25GB UpGrade with Microsoft SkyDrive

Learn Excel Looks at The Free SkyDrive Upgrade

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

UpGrade to the FREE 25GB Storage Before Its Gone

Learn Excel 2010 then Adjust Your Prices

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

Add N Percent to Reflect New Current Price

Dueling Excel and the continuation of the LOOKUP Debate

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

Mike and Bill further debate the LOOKUP Function and whether it is ambiguous or dynamic

Learn Excel 2010 to Print Record with A Macro

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

In Part 4 of 4 Bill shows us how to Print our Record with a Macro

Happy Birthday T Nash

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

Drop by Twitter to wish Holy Macro! Books -Copy Editor- T Nash a Happy Birthday!

Learn Excel 2010 to Get Next Record using OFFSET

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

In Part 3 of 4 Bill looks at Pulling Data from Another Worksheet in the Current Workbook

Reminder Mrexcel on CFO Online with Mastering Excel Charts

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

Today 19-April-2012 at 2PM - Improve Your Charting Skills

Mastering Excel Charts

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

Webcast with CFO Online 19-April-2012 at 2PM

Learn Excel 2010 Get Next Record

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

In Part 2 of 4 Bill Looks at Moving Through the Data Set per Record

Learn Excel 2010 Print Form from Database

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

In Part 1 or 4 Bill Examines the Data and Expectations

Save The Date for MrExcel and CFO Online Go Charting 19 April 12

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

Mastering Excel Charts for Finance Professionals

Dueling Excel and The Data Dump Count

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

Learn to Count Between and Get Totals

An Newsletter About Excel

bill@mrexcel.com (Bill Jelen) — Sun, 15 Apr 2012 09:01:02 GMT

The CFO Excel Pro eNewsletter

MrExcel on Facebook

bill@mrexcel.com (Bill Jelen) — Sun, 15 Apr 2012 09:01:02 GMT

Is anyone tracking that satellite launch?

MrExcel and CFO Online Go Charting 19 April 12

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

Mastering Excel Charts for Finance Professionals

Learn Excel Looks at The Sakai Grade Book Part 3

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

Calculating the Total Possible Points from Non-Blank Cells in Sakai

MrExcel on Facebook

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

What Profile Pic Do We Use - ie - Ambiguous Green Square

Learn Excel Looks at The Sakai Grade Book Part 2

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

Making the Sakai Grade Book more Dynmaic with only Formulas - no Macro

Learn Excel Looks at The Sakai Grade Book Part 1

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

Changing the CSV output to a Live and more Dynamic Tool Part I of IV

Learn Excel 2010 to Remove Hidden Columns

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

Keeping Hidden Columns of Data Hidden

Learn Excel with Conditional Diagonal Borders

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

Cross out the numbers but leave the Text open

We Are Going To Need A Bigger Week

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

VLOOKUP WEEK 2012 is into Week II and going strong

Learn Excel 2010 to create Conditional Diagonal Borders

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

How can we cross out values in cells using Conditional Formatting

VisiCalc Timewarp with Bill Jelen

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

Bill looks at VisiCalc from 1979 to find the origins of The Lookup Function

Sale Ends Today VLOOKUP Awesome Quick

bill@mrexcel.com (Bill Jelen) — Sat, 31 Mar 2012 09:01:02 GMT

Ehanced ebook for iPad Sale Ends Today March 31 2012