Learn Excel from Bill Jelen with this daily 2 minute video podcast.
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.
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
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.
Labels: Data, Data wrangling, header
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
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.
Labels: consolidate, Data, Paste Special, subtract
posted by Bill at 9:00 AM
An introduction to using Data Consolidate to add two data sets. Episode 786 introduces the concept. Tomorrows episode will throw in an interesting twist.
Labels: consolidate, Data
posted by Bill at 9:00 AM
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.
Labels: Data
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
Kerry asks: after adding automatic subtotals, how can you copy only the subtotal rows? Episode 731 will show you how.
posted by Bill at 9:00 AM
