Excel subtotals: straight to the point

Description

Why Have a Book on Subtotals -- Preparing Your Data and Adding Subtotals -- How to Set up Your Data for Subtotals -- How to Fit a Multiline Heading into One Cell -- No Tiny Blank Columns Between Columns -- How to Sort Data -- Sort Days of the Week -- Sort a Report into a Custom Sequence -- Add Subtotals to a Data set -- Subtotal Tricks & Techniques -- Use Group & Outline Buttons to Collapse Subtotaled Data -- Manually Apply Groups -- Group Report Sections -- Subtotals Above Each Group -- Copy Just Totals from Subtotaled Data -- Sort Largest Customers to the Top -- Format the Subtotal Rows -- Add Other Text to the Subtotal Lines -- Subtotal One Column and Count Another Column -- Subtotal by Month With Daily Dates -- Subtotals by Product Within Region -- Add a Page Break For each Group -- My Manager Wants a Blank Line After Each Subtotal -- Add a Calculation Only to the Subtotal Rows -- Shift Subtotals One Column to the Right -- Finding G/L Accounts Not in Balance -- Why Is Final Subtotal Row Appearing After Many Blank Rows? -- Enter a Grand Total of Data Manually Subtotaled -- Why Does Subtotal Dialog Sometimes Default to Count? -- Adding Subtotals to Dozens of Columns -- Can You Get Medians? -- Horizontal Subtotals -- Subtotals Don't Work with Tables -- Using the SUBTOTAL function without Invoking the Command -- Adding a Total Visible Below a Filtered Data Set -- Using 109 For Rows Manually Hidden -- The 9 Basic Arguments -- The 9 New Arguments -- SUMIF or COUNTIF of Filtered Data -- Introducing AGGREGATE -- New Arguments for What to Ignore -- New Arguments for AggregatE Function Number -- Some Functions Require a Fourth Argument in AGGREGATE -- How is SMALL or LARGE Different From MIN or MAX? -- Doing MINIFS or MAXIFS Before They Existed -- Using VBA with Subtotals -- Creating Subtotals Using VBA -- VBA & TEXTJOIN to Subtotal Dozens of Columns -- Replacing Subtotals With Power Query Why Have a Book on Subtotals -- Preparing Your Data and Adding Subtotals -- How to Set up Your Data for Subtotals -- How to Fit a Multiline Heading into One Cell -- No Tiny Blank Columns Between Columns -- How to Sort Data -- Sort Days of the Week -- Sort a Report into a Custom Sequence -- Add Subtotals to a Data set -- Subtotal Tricks & Techniques -- Use Group & Outline Buttons to Collapse Subtotaled Data -- Manually Apply Groups -- Group Report Sections -- Subtotals Above Each Group -- Copy Just Totals from Subtotaled Data -- Sort Largest Customers to the Top -- Format the Subtotal Rows -- Add Other Text to the Subtotal Lines -- Subtotal One Column and Count Another Column -- Subtotal by Month With Daily Dates -- Subtotals by Product Within Region -- Add a Page Break For each Group -- My Manager Wants a Blank Line After Each Subtotal -- Add a Calculation Only to the Subtotal Rows -- Shift Subtotals One Column to the Right -- Finding G/L Accounts Not in Balance -- Why Is Final Subtotal Row Appearing After Many Blank Rows? -- Enter a Grand Total of Data Manually Subtotaled -- Why Does Subtotal Dialog Sometimes Default to Count? -- Adding Subtotals to Dozens of Columns -- Can You Get Medians? -- Horizontal Subtotals -- Subtotals Don't Work with Tables -- Using the SUBTOTAL function without Invoking the Command -- Adding a Total Visible Below a Filtered Data Set -- Using 109 For Rows Manually Hidden -- The 9 Basic Arguments -- The 9 New Arguments -- SUMIF or COUNTIF of Filtered Data -- Introducing AGGREGATE -- New Arguments for What to Ignore -- New Arguments for AggregatE Function Number -- Some Functions Require a Fourth Argument in AGGREGATE -- How is SMALL or LARGE Different From MIN or MAX? -- Doing MINIFS or MAXIFS Before They Existed -- Using VBA with Subtotals -- Creating Subtotals Using VBA -- VBA & TEXTJOIN to Subtotal Dozens of Columns -- Replacing Subtotals With Power Query Using Power Query to Get #2 View of Subtotals -- Index.