MrExcel Excel Videos

Calculate Sales over Quota using either the IF or MAX functions. Episode 348 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!

Andy "Cyber" Walker once asked me what seemed like a simple question - he wanted to use conditional formatting to change records to green if the total of all records for that day exceeded $1000. While this sounds simple, it actually is incredibly complex to set up. Episode 347 walks you through the amazing conditional formatting option to allow this to happen. 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!

Change the decimals in your spreadsheet to display as fractions. Excel offers options for halves, quarters, etc., but Episode 346 shows you how to create a custom format to display in thirty-secondths or even five-hundred-eighty-eighths. 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 make a value that is slightly too large for a column automatically fit. Episode 345 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!

The complete guide to applying borders to a selection. Learn what all of those icons actually do on the borders tab. Episode 344 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!

Tricks for adding a double underline to your cells. Episode 343 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!

Do you get annoyed when you copy a formula and the borders get copied along with the formula? Episode 342 shows you a cool trick to prevent the borders from being copied as you extend a formula. 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 print your worksheet with the row and column headings visible. Episode 341 shows you how to make your printout look just like your Excel screen, plus two reasons why you would want to do this. Learn how to print formulas instead of values and how to print your cell comments at the bottom of the sheet. 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 every TRUE value in your worksheet get a little purple triangle? You can thank some out-of-business company with the stock ticker of TRUE for that one. In Episode 340, we'll take a look at how to selectively turn off SmartTags for one company. 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!