MrExcel Excel Videos

Excel 2007 features an amazing expanding formula bar. Todays podcast takes a look at how to handle extremely long formulas in Excel 2007. Episode 625 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 much ice cream will Sally sell on any given day? Todays Episode 624 tries to figure out a relationship between temperature, rain and ice cream sales. 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!

Sometimes the growth in a model is not linear, but it is exponential. In those cases, Excel has forecasting tools to replace LINEST and FORECAST. Episode 623 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!

Rather than using FORECAST to choose the next number, you can use LINEST to generate the slope and y-intercept of a line. Todays podcast graphs the results of LINEST so you can see how Excel is forecasting the next number in a series. Episode 622 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!

Today, we take a second look at Leons question how to forecast the next number in a sequence of numbers. But, in Episode 621, I show you how to solve this with one cell instead of 6 cells. 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!

Leon asks how to forecast the next number in a series of numbers. In Episode 620, I will take a look at a formula solution and a faster solution. 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 can you find the most recent record for each customer? The method I proposed in Episode 614 is not the fastest way. Richard from Jaguar Cars Ltd sends in a faster method. Episode 639 shows you how. The podcast will take off a couple of days for the U.S. Thanksgiving holiday and will resume on Monday. 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!

Joe Marten sends in todays tip; how to quickly navigate through the AutoFilter list when there are far too many entries in the list. Episode 638 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!

Ben asks todays question: Can I set up Validation Dropdowns where the list of items requires a unique entry? For example, once I choose ABC in a column, it should no longer be offered in that column. Episode 637 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!