Description |
1 online resource : illustrations. |
Physical Medium |
polychrome |
Description |
text file |
Series |
Straight to the point
|
|
Straight to the point.
|
Note |
Includes index. |
Contents |
Intro; About the Author; 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 LinesSubtotal 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 SubtotalsSubtotals 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 ColumnsReplacing Subtotals With Power Query; Using Power Query to Get #2 View of Subtotals; Index. |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Business -- Data processing.
|
|
Business -- Data processing. |
|
COMPUTERS -- Desktop Applications -- Spreadsheets. |
Genre/Form |
Electronic books.
|
Other Form: |
Print version: Jelen, Bill. Excel Subtotals Straight to the Point. Chicago : Holy Macro! Books, ©2018 |
ISBN |
9781615472437 (electronic book) |
|
1615472436 (electronic book) |
|
9781615473656 (electronic book) |
|
1615473653 (electronic book) |
|