Learn Excel from MrExcel Video Podcast

Dueling: Paper/Sticker - 1055 - Learn Excel Podcast

consult@MrExcel.com (Bill Jelen) — Fri, 10 Jul 2009 13:00:00 GMT

Faizee from Youtube posts a question about looking for certain words in a cell in order to create a category. While this sounds simple, Bill and Mike manage to come up with a number of possible formulae in Episode 1055!

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Axel Font for Excel! - 1054 - Learn Excel form MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Thu, 9 Jul 2009 13:00:00 GMT

Erik Spiekerman has designed a font that is ideal for use in Excel. The Axel font is designed to be narrow yet highly readable both on screen and on paper. In Episode 1054, we will take a look at the Axel font.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Finding Cell Styles - 1053 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Wed, 8 Jul 2009 13:00:00 GMT

If Jerry from podcast 1052 had been using cell styles to mark his input cells, he could have used advanced options in the Find dialog to clear all of the input cells. Episode 1053 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Clearing Input Cells - 1052 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Tue, 7 Jul 2009 13:00:00 GMT

Jerry has a model with input cells and formula cells. He wants to copy the model for next month and clear out all the input cells. Episode 1052 will show you how to clear out the numeric input cells.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

No-Header Sort - 1051 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Mon, 6 Jul 2009 13:00:00 GMT

Jeffrey wonders why the top row of his data wonât sort. He has a blank row between the data and the headers, which looks great, but is fooling the Intellisense. Episode 1051 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Count >5 Minutes - 1050 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Fri, 3 Jul 2009 13:00:00 GMT

Today's dueling Excel podcast question is how to count all cells with times greater than five minutes. Episode 1050 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Tracing Error - 1049 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Thu, 2 Jul 2009 13:00:00 GMT

You have a large formula which is generating an error. To find which reference in the formula is causing the problem, use the Evaluate Formula tool to step through the formula. Episode 1049 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Shift-Tab - 1048 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Wed, 1 Jul 2009 13:00:00 GMT

Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit cooler.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Rounding Correctly - 1047 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Tue, 30 Jun 2009 13:00:00 GMT

After yesterdayâs podcast about ASTM E29 rounding, I produce a function in VBA that will correctly do the bankers rounding algorithm in Excel. Episode 1047 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

ASTM E29 Rounding - 1046 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Mon, 29 Jun 2009 13:00:00 GMT

If you have to round 0.5, do you think it should round to 0 or 1? I bet that you learned in school that it should round to 1. However, this will introduce errors. Episode 1046 talks about the errors introduced by this rounding.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dueling: Percentage Scrollbar - 1045 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Fri, 26 Jun 2009 13:00:00 GMT

Izhak asks how to add a scrollbar to a worksheet for selecting a percentage. In this dueling Excel podcast Episode 1045, Bill and Mike will show you two ways to solve the problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Multi-Column Find - 1044 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Thu, 25 Jun 2009 13:00:00 GMT

Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Parsing Variable Length - 1043 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Wed, 24 Jun 2009 13:00:00 GMT

Dawn's file has name in A and address in B. Except: the address field in column B contains the name again. Episode 1043 shows how to parse the variable-length name out from column B.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Indian Pay Rounding - 1042 - Learn Excel from MrExcel

consult@MrExcel.com (Bill Jelen) — Tue, 23 Jun 2009 13:00:00 GMT

Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round down. Otherwise round up. While Excelâs built-in functions donât handle this, Episode 1042 shows you how to handle this using three functions in Excel.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Future IF - 1041 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Mon, 22 Jun 2009 13:00:00 GMT

Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games. In Episode 1041, I take a look at how to modify the original formula to calculate nothing until a score has been entered.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dueling: Frequency Distribution - 1040 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Fri, 19 Jun 2009 13:00:00 GMT

In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Round & Round - 1039 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Thu, 18 Jun 2009 13:00:00 GMT

Gopal asks how to round a number up to the next whole number. Episode 1039 takes a look at several different functions available for rounding numbers in Excel.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Multiple Scatter - 1038 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Wed, 17 Jun 2009 13:00:00 GMT

In Episode 1038 - a better way to create the multiple scatter charts from Episode 1031 and 1032. Thanks to everyone who wrote in with this better way to set up the data.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

2nd Smallest - 1037 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Tue, 16 Jun 2009 13:00:00 GMT

If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Better 1016 - #1036 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Mon, 15 Jun 2009 13:00:00 GMT

Tom and Thor send in better ways to force the area chart under a portion of a line chart to drop to zero. Episode 1036 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dueling: Up/Down Symbols - 1035 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Fri, 12 Jun 2009 13:00:00 GMT

Jonathan asks how to insert an Up/Down arrow as the result of an IF statement. In Dueling Excel Episode 1035, Bill and Mike show you a few ways how to do this.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Count Visible Rows - 1034 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Thu, 11 Jun 2009 13:00:00 GMT

Isabel asks how to count only the visible entries in a range. =COUNTA() is returning all of the values. Episode 1034 will show you how to count or sum the visible rows in a range.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Fiscal Quarter UDF - 1033 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Wed, 10 Jun 2009 13:00:00 GMT

If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In Episode 1033, you will see how to add a couple of user-defined functions to your personal macro workbook to simplify the conversion of date to Fiscal Quarter or Fiscal Year.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Multiple XY II - 1032 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Tue, 9 Jun 2009 13:00:00 GMT

Yesterday's podcast showed a tedious method for creating a chart with 5 XY series. Today, Episode 1032 shows a method for streamlining the creation of this chart.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Multiple XY Series - 1031 - Learn Excel from MrExcel Podcast

consult@MrExcel.com (Bill Jelen) — Mon, 8 Jun 2009 13:00:00 GMT

Pierre wants to create a chart with multiple XY series on the same chart. While this is possible, it is not extremely easy. Episode 1031 shows you one method for doing this.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!