Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Tuesday, February 28, 2006

Episode 199 - Floating Along

Why does that simple price show up as $2.0999999999999? Episode 199 will show you why and what to do about it.

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

Monday, February 27, 2006

Episode 198 - Round Up to the Nearest 5

Today, MrExcel handles yet another maddening request from a manager. Episode 198 shows you how to unglue yourself from the ceiling the next time your manager asks you to adjust list prices.

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

Friday, February 24, 2006

Episode 197 - Max, Abs and Forecast Error

Bill Jelen is the only guy on the planet who wants to measure forecast accuracy this way. Under the guise of trying to teach you about the powerful MAX and ABS functions, Bill tries to persuade the forecasting Intelligentsia that there is a better way. Episode 197 will show you how.

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

Thursday, February 23, 2006

Episode 196 - Steven Spielberg

Question: What do Steven Spielberg, an 8th grade math student, and someone with bad numbers to report all have in common? They can all learn something useful from today's podcast. Episode 196 provides a review of four obscure (but potentially fun!) math functions in Excel.

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

Wednesday, February 22, 2006

Episode 195 - Starbucks or the Lottery?

I spend a couple bucks a day on Starbucks, UNLESS the local lottery jackpot is so unbelievably huge that the odds are in my favor. In today's episode, learn how to use a simple function in Excel to figure out the probabilty of your local lottery game. Episode 195 will show you how.

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

Tuesday, February 21, 2006

Episode 194 - Like a Big Pizza PI

Whether you are figuring out the best pizza deal or how much water is in your round pool, you will have to use the constant PI. Episode 194 will reveal the ugly truth about the pricing of that small pizza you were going to order for lunch.

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

Monday, February 20, 2006

Episode 193 - Growth Rate

Your company is growing, but how fast? The formula for a compounded growth rate is complicated but something everyone should be able to calculate. Episode 193 shows you how.

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

Friday, February 17, 2006

Episode 192 - The Root of the Problem

How to calculate square roots, cube roots, fourth roots of any number. Any time that I use the word "algabraically" on a Friday, there is something wrong. Still, Episode 192 will show you how to take any root of a number.

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

Thursday, February 16, 2006

Episode 191- Powers in Excel

Exponents gave me headaches in math class, but they are easy in Excel. Episode 191 will show you how.

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

Wednesday, February 15, 2006

Episode 190 - Running Percentage of Total

I hate it when a calculation requires two different formulas, but that is the case in today's podcast. To calculate a running percentage of total, episode 190 shows the annoying situation where the formula in the first row of data needs to be different from the formulas in the remaining rows.

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

Tuesday, February 14, 2006

Episode 189 - Calculate Percentage of Total

How to enter a formula to calculate percentage of total using just 8 keystrokes. Episode 189 will show you how.

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

Monday, February 13, 2006

Episode 188 - Formula Frustrations!

Frustrated because you've entered a formula and instead of an answer, Excel just shows you the formula? Learn the three most common reason why and how to solve this. Episode 188 will show you how.

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

Friday, February 10, 2006

Episode 187 - Quick Calculator

One of the simplest tricks in Excel. See how to do a quick calculation. Episode 187 will show you how.

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

Thursday, February 09, 2006

Episode 186 - Debug a Formula

Do you have a complicated formula? Use the F9 key to calculate individual terms in the formula. Episode 186 will show you how.

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

Wednesday, February 08, 2006

Episode 185 - Multiple Regression

Why does Sally's ice cream stand either have a boom or bust day? Could it be tied to temperature and rain? Podcast 185 shows you how to set up a multiple regression model to test that theory.

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

Tuesday, February 07, 2006

Episode 184 - Straight Line Estimate

One of the simplest ways of forecasting is to assume that the sales are increasing along a straight trendline. Excel offers a function to calculate a trendline, but it is one of the most bizarre functions. If you don't know the secret to using LINEST, it will try and describe a line with a single value, like "208". This is enough to confuse even the rocket scientists. Let MrExcel show you the simple (but non-intuitive) steps to entering an array formula. Episode 184 will show you how.

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

Monday, February 06, 2006

Episode 183 - Calculate a Moving Average

When you are trying to analyze product demand for a sales forecast, smooth out the spikes in demand by using a three month moving average. Episode 183 shows you how.

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

Friday, February 03, 2006

Episode 182 - Commenting a Formula

Have you just racked your brain to figure out an obscure formula? Why not leave yourself a note explaining the formula? Episode 182 will show you how to do this without using cell comments.


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

Thursday, February 02, 2006

Episode 181 - Kissing Your Sister

Ties can really screw up the RANK function. Learn how to workaround this problem by using COUNTIF. Episode 181 shows you how.

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

Wednesday, February 01, 2006

Episode 180 - Sorting With A Formula

Need a Top Sellers Report? Use the VLOOKUP Function to sort your ranked data. Episode 180 will show you how.

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