Data

Episode 799 – Quick Hide/Unhide

               

Travis has a spreadsheet where you can quickly hide and unhide detail rows using the tiny “1” and “2” buttons. In Episode 799, I will show how to add these Group and Outline symbols to your worksheet. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new(…)

Episode 787 – Consolidate Minus

               

A question from a seminar… how can you use the consolidate command to subtract one data set from another data set? Episode 787 shows you the workaround. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the(…)

Episode 786 – Data Consolidate

               

An introduction to using Data Consolidate to add two data sets. Episode 786 introduces the concept. Tomorrows episode will throw in an interesting twist. This blog is the video 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(…)

Episode 782 – Leader Lines……

               

Hamilton sends in a question about parsing data that has leader……lines between the columns. This ends up being trickier than you might think. Episode 782 shows you how I approached the problem. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday(…)

Episode 773 – Google Calendar

               

Pau asks how to take a CSV file from one website and convert it for importing to Google Calendar. In Episode 773, I turn on the macro recorder and attempt to fix the file. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video(…)

Learn Excel from MrExcel