MrExcel Excel Videos

How to highlight part of a line chart using a second area chart series. This trick works in Excel 2007, but not 2003. Episode 1016 shows you how. This video is the 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!

In today's dueling podcast, how to turn a range upside down. Episode #1015 shows you how. This video is the 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!

In our second look at Formula Recalc, a 750x improvement in formula recalc times by using some helper cells. Episode 1014 shows you how. This video is the 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!

Andre provides a set of formulas to chart the last rolling six months of data. Episode 1013 shows you how. This video is the 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!

Vaibhav asks how to group a pivot table up to fiscal quarters. While this is easy if your fiscal years ends on December 31, it is not so easy for other year-ending dates. Episode 1012 shows you how. This video is the 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!

Jason sends in our question today. He has a single column of cells that contain 5 bits of information in each cell. There arent any good delimiters and the fields are not fixed width. To extract the necessary information from the cell, Episode 479 shows how to combine MID, FIND, and FIND to locate the important data. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy.

Today, an interview with Andrew Engwirda, author of the JMT utilities for Excel. Andrew is an Excel MVP from Australia. Episode 478 explains how one of the utilities works.

Play ball! In honor of baseballs opening day, learn how to display a number in fractions, such as the Innings Pitched column in Cy Youngs lifetime stats. Episode 477 shows you how. This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Bills favorite Excel-related April Fools day trick will freak out your manager. Take a look at how this old trick plays out in the old Excel, the new Excel, and in Vista. Episode 476 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!