Data

MrExcel’s Learn Excel #929 – Data Consolidate

               

Yet another solution to matching data from two different worksheets…the Data Consolidate command. Episode 929 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!

Episode 881 – Chart Quarters or Months

               

Tom from Cincinnati asks how to create a chart which can show either monthly or quarterly data. Episode 881 shows how to manually set up group and outline symbols to achieve the result. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every(…)

Episode 849 – Remove Group

               

After adding subtotals by Customer, Excel adds three group and outline buttons. Most people use the #2 and #3 buttons but rarely use the #1 button. Could you simply remove the #1 button? Podcast 849 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a(…)

Episode 831 – Consolidate

               

During a recent seminar, someone asked me to show the audience how to use the Consolidate command. I launched into the technique shown in Episode 831 – using consolidate to collapse a single range down to one line per customer. In tomorrow’s podcast, we will look at alternate uses for consolidate. This blog is the(…)

Episode 826 – Data in Headers

               

It is frustrating when section headers contain data that applies to all records in that section. You really want to get that header data down onto every row in the section. Episode 826 shows you one method for doing this. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.(…)

Learn Excel from MrExcel