Learn Excel from MrExcel Video Podcast

Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514

consult@MrExcel.com (Bill Jelen) — Mon, 30 Jan 2012 17:01:41 +0000

VJ types a value into his spreadsheet and Excel speaks the entry; but VJ doesn't want Excel to speak the entry and 'Stop Speaking Cells' -on the Quick Access Toobar- is not making it stop. Why? Follow along with Bill in Episode #1514 to learn why the cells won't stop speaking and then learn how to turn off the 'Speak On Enter' function.

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Dueling Excel - "Total All Lookups": Podcast #1513

consult@MrExcel.com (Bill Jelen) — Fri, 27 Jan 2012 21:07:31 +0000

Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn more about the LOOKUP function, how to use SUM and SUMPRODUCT and Array Formulas in Episode #1513.

Dueling Excel Podcast #95…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - " Move Entire Rows ": Podcast #1512

consult@MrExcel.com (Bill Jelen) — Thu, 26 Jan 2012 20:48:00 +0000

Charlie -who admits he is relatively new to Microsoft Excel- needs to rearrange the rows of his spreadsheet. Today, in Episode #1512, Bill shows us several methods to accomplish this task.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Count Between Ranges-With A Pivot Table": Podcast #1511

consult@MrExcel.com (Bill Jelen) — Thu, 26 Jan 2012 20:43:21 +0000

We could not get Episode #1511 to load with Libsyn. Our Apologies. You may view the full length Blog Post and Video Podcast at the Learn Excel from MrExcel Blog on WordPress: Click Here To Visit

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Chart An Extra Series": Podcast #1510

consult@MrExcel.com (Bill Jelen) — Mon, 23 Jan 2012 16:56:00 +0000

Richard has a Data Series Set up with Year, Female, Male; after moving from Excel 2003 to Excel 2007, Richard noticed that the Chart is giving three (3) Series instead of two (2). With a few simple clicks in Episode #1510, Bill "MrExcel" Jelen solves the additional series issue.

Today's Episode is brought to you by... New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articles written by Microsoft MVP Bill "Mr. Excel" Jelen that provide readers with step-by-step solutions to nagging "real-world" Excel problems.

The Learn Excel from MrExcel Podcast Series - Visit Us Today!

Dueling Excel - "Conditional Format +/- 15%": Podcast #1509

consult@MrExcel.com (Bill Jelen) — Fri, 20 Jan 2012 17:05:37 +0000

Today's Dueling Challenge: "Conditionally Format End Values that have Increased or Decreased by 15%"

Initially, it appears that there is only one way to accomplish this task, but Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen find another way to tackle and solve this challenge. Follow along with Episode #1509 to see how its done!

and

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Count Between A Range": Podcast #1508

consult@MrExcel.com (Bill Jelen) — Thu, 19 Jan 2012 14:11:00 +0000

The Question: "I have a =COUNTIF to count values less than 10 and another to count values less than 20; but how do I count the values that fall between 10 and 20?" In 2007 and newer, there is a New Function called '=COUNTIFS". Follow along with Bill in Episode #1508 to learn how to solve this question - even if you are using Excel 2003 or earlier!

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507

consult@MrExcel.com (Bill Jelen) — Thu, 12 Jan 2012 15:05:24 +0000

Today's Learn Excel Question: "Can you use Excel to generate Random Numbers that are centered around a mean using a Standard Deviation?" =RANDBETWEEN won't do it, but a clever use of =RAND and =NORM.INV ["Normal Inverse"] will do it. In Episode #1507, Bill shows us how to generate Random Numbers with this method.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506

consult@MrExcel.com (Bill Jelen) — Wed, 11 Jan 2012 17:49:08 +0000

Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the " N-NN-NNNN " Format to Dates, by Excel. Today, how to prevent this from happening is the subject Bill works with in Episode #1506.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Next Invoice Number": Podcast #1505

consult@MrExcel.com (Bill Jelen) — Tue, 10 Jan 2012 14:04:54 +0000

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to 'Macro Enable' our Workbook and then create a short VBA Code routine to automatically generate Invoice Numbers with the press of a mouse button.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Saving Form to Database": Podcast #1504

consult@MrExcel.com (Bill Jelen) — Mon, 09 Jan 2012 15:03:00 +0000

John from New Zealand offers an improvement to Thursday's podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Saving Form to Database": Podcast #1503

consult@MrExcel.com (Bill Jelen) — Thu, 05 Jan 2012 19:28:04 +0000

Today, Bill shows off some of the truly dynamic functionability of Microsoft Excel. Oz wants to use a worksheet as a data entry form and then post the record to a database. In Episode #1503 - the first of a two part tutorial series - Bill shows us how to use some VBA to make this happen.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Running Total AutoFill": Podcast #1502

consult@MrExcel.com (Bill Jelen) — Wed, 04 Jan 2012 15:50:14 +0000

Mally wants a simple Spreadsheet - Two (2) Columns; she asks how to enter a Value in Column A and have the Running Total over in Column B automatically fill down. Episode #1502 shows you how to use the new Table functionality to solve this. Also, in reference to the Learn Excel from MrExcel Podcast Episode #1482, Bill readdresses a few more Table Topics, such as: 'Control-T' to define your Data Set as a Table or going to 'File > Options > Formulas > 'Working With Formulas' area and deselecting "Use Table Names in Formulas"

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Will The Globetrotters Lose?": Podcast #1501

consult@MrExcel.com (Bill Jelen) — Tue, 03 Jan 2012 13:53:44 +0000

"I am going out on a limb to predict that the four-point shot will lead to an accidental Washington Generals win this season", Bill said. Episode #1501 shows off a couple of dueling Win/Loss sparklines with my prediction. I don't know when, but sometime soon, the Harlem Globetrotters will fall to the Washington Generals.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Filter to Unique?": Podcast #1500

consult@MrExcel.com (Bill Jelen) — Fri, 30 Dec 2011 20:55:57 +0000

Today's question... can you use the AutoFilter dropdowns to filter to one row per unique customers? For a solution to this, you can move to the Advanced Filter or use Remove Duplicates on a copy of the data. Follow along with Episode #1500 as Bill shows us both methods.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Improved Excel Help": Podcast #1499

consult@MrExcel.com (Bill Jelen) — Thu, 29 Dec 2011 20:10:07 +0000

I'm sure [like myself] that some viewers will be somewhat confused when viewing this podcast today...I assume that many of us thought Bill "MrExcel" Jelen and the MrExcel Community was the 'Excel Help' function...but that would be only partially correct! Today, in Episode #1499, Bill focuses on Excel Help and how it has learned a new trick; Excel Help now includes Community Content! Episode #1499 shows us the ins and outs!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Two Subtotals At Top": Podcast #1498

consult@MrExcel.com (Bill Jelen) — Wed, 28 Dec 2011 13:58:19 +0000

Today, Amelie asks how to add Two sets of Subtotals, with the Subtotals appearing at the top! In Episode #1498 of the Learn Excel from MrExcel Podcast Series, Bill shows us how to get the Subtotals.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Sheets Revisted": Podcast #1497

consult@MrExcel.com (Bill Jelen) — Tue, 27 Dec 2011 15:42:00 +0000

Episodes #1488 and #1489 of the "Learn Excel from MrExcel Podcasts" generated a lot of email from viewers. Today, in Episode #1497, Bill revisits those episodes [that were dealing with making copies of worksheets]. Looking at several methods emailed in over the last week, Bill demonstates even more Copy Worksheet methods - including a VBA Macro routine!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Did Santa bring an iPad?": Podcast #1495

consult@MrExcel.com (Bill Jelen) — Mon, 26 Dec 2011 21:49:00 +0000

Today, Bill offers a quick tip on getting acclimated to your new iPad! Check out QUE Publishing. QUE is offering a free enhanced eBook sampler. This is a great way to show off your new iPad! See Episode #1495 for details – Bill shows you exactly how to get this FREE Sampler easily!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Holiday Gift Labels": Podcast #1494

consult@MrExcel.com (Bill Jelen) — Mon, 26 Dec 2011 15:31:23 +0000

MrExcel on Word for The Holidays!?

Running short of gift tag labels? They are available for Free, inside Microsoft Word 2007 or newer. Today, in Episode #1494, Bill "MrExcel" Jelen reminds you of the Office Online Templates that are available to you!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Variable Chart by Dropdown": Podcast #1493

consult@MrExcel.com (Bill Jelen) — Thu, 22 Dec 2011 19:54:33 +0000

Today, in Episode #1493, Mike from Athens, Greece asks how to create a control that would change a chart to show either units or revenue. Bill presents a borrowed solution from Mike Alexander at DataPigTechnologies.com, but when you see the solution, you will realize that the trick is barely a trick at all.

*Kindle is Coming to ‘The MrExcel Excel Store’! Stay Tuned!*

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Random Drug Testing": Podcast #1491

consult@MrExcel.com (Bill Jelen) — Wed, 21 Dec 2011 14:42:00 +0000

A small company has decided to start doing Random Drug Testing. They want to randomly select two (2) employees each month. In Episode #1491, Bill builds a handy Workbook for this task. Enter the Employee Names in B2:B101, then press F9 to select two (2) employees for the month. The Randomization is done with formulas – no VBA.

*Oh No! Podcast #1490 never launched; we apologize for the misfire!*

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Dueling Excel - "Find Cubic Feet": Podcast #1492

consult@MrExcel.com (Bill Jelen) — Fri, 16 Dec 2011 14:57:50 +0000

Today's Dueling Excel comes from France... Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen are looking for the words 'Top laod' or 'Front load', and then Cubic Feet. In the process they will also need to change the decimal in the value to a comma to make the value appropriate in French. Using Formulas, a little VBA and some creativity, Mike and Bill offer a few different solutions to the challenge in Episode #1492.

Dueling Excel Podcast #94…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490

consult@MrExcel.com (Bill Jelen) — Thu, 15 Dec 2011 14:33:11 +0000

All this week, Bill has been dealing with a Workbook with 31 sheets - one Worksheet per day. Today, in Episode #1490, Bill presents a bizarre Formula to put the Sheet Name in a Cell. Actually, today, I use a MID of the Sheet Name to fill in the correct Date in a Cell.

*Kindle is Coming to ‘The MrExcel Excel Store’! Stay Tuned!*

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489

consult@MrExcel.com (Bill Jelen) — Wed, 14 Dec 2011 18:47:29 +0000

Yesterday, in Podcast Episode #1488, Bill showed us a cool way to make 30 copies of a worksheet. However, after creating the worksheets we were left with strange names like Sheet1 (2), Sheet1 (3) and so on. Horrible! Today, in Episode #1489, Bill shows us how - with one line of code in the VBA Immediate Window - to solve the remaining issue of renaming the new Worksheets.

*Kindle is Coming to ‘The MrExcel Excel Store’! Stay Tuned!*

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!