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

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!

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!

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!

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!

Whether you are figuring out the best pizza deal or how much water is in your round pool, you will have to us 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!

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!

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!

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!

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!

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!

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!

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!

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!

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!