| Description |
1 online resource |
|
text file |
| Physical Medium |
polychrome |
| Contents |
Intro; Dedication; About the Author; About the Contributors; Foreword; Introduction; Part 1: The Top 54 Tips; #1 Double-Click the Fill Handle to Copy a Formula; #2 Break Apart Data; #3 Filter by Selection; Bonus Tip: Total the Visible Rows; #4 The Fill Handle Does Know 1, 2, 3a Bonus Tip: Fill Jan, Feb ..., Dec, Total; Bonus Tip: Fill 1 to 100,000 in a Flash; #5 Fast Worksheet Copy; Bonus Tip: Put the Worksheet Name in a Cell; Bonus Tip: Add a Total Row and a Total Column with One AutoSum; Bonus Tip: Power Up the Status Bar Statistics. |
|
Bonus Tip: Create a SUM That Spears Through All WorksheetsBonus Tip: Use INDIRECT for a Different Summary Report; #6 Use Default Settings for All Future Workbooks; Bonus Tip: Understand that Changes are Cumulative; Bonus Tip: Replace the Comma Style in Book.xltx; #7 Recover Unsaved Workbooks; #8 Create Perfect One-Click Charts; #9 Paste New Data on a Chart; Bonus Tip: Create Interactive Charts; Bonus Tip: Show Two Different Orders of Magnitude on a Chart; #10 New in Excel 2016: Create Waterfall Charts and More; Bonus Tip: Create Funnel Charts in Office 365. |
|
Bonus Tip: Create Filled Map Charts in Office 365#11 Add Meaning to Reports Using Data Visualizations; #12 Sort East, Central, and West Using a Custom List; #13 Sort Left to Right; Bonus: Another Way to Move Columns; #14 Sort Subtotals; Bonus Tip: Fill in a Text Field on the Subtotal Rows; Bonus Tip: Format the Subtotal Rows; Bonus Tip: Copy the Subtotal Rows; #15 Sort and Filter by Color or Icon; #16 Consolidate Quarterly Worksheets; #17 Create a Year-over-Year Report in a Pivot Table; Bonus Tip: Change the Calculation in a Pivot Table; #18 Find the True Top Five in a Pivot Table. |
|
#19 Specify Defaults for All Future Pivot TablesBonus Tip: Change What Drives You Crazy About Excel; Bonus Tip: Make Pivot Tables Expandable Using Ctrl+T; Bonus Tip: Use Ctrl+T with VLOOKUP and Charts; #20 Replicate a Pivot Report for Each Rep; #21 Use a Pivot Table to Compare Lists; Bonus Tip: Show Up/Down Markers; Bonus Tip: Compare Two Lists by Using Go To Special; #22 Build Dashboards with Sparklines and Slicers; Bonus Tip: Make Your Workbook into a Web App; Bonus Tip: Line Up Dashboard Sections with Different Column Widths; Bonus Tip: Use Picture Lookup. |
|
#23 See Why GETPIVOTDATA Might Not Be Entirely Evil#24 Eliminate VLOOKUP with the Data Model; Bonus Tip: Count Distinct; #25 Compare Budget Versus Actual via Power Pivot; Bonus Tip: Portable Formulas; #26 Use F4 for Absolute Reference or Repeating Commands; Bonus Tip: Use a Named Range Instead of Absolute References; #27 Quickly Convert Formulas to Values; Bonus Tip: Skip Blanks While Pasting; #28 See All Formulas at Once; Bonus Tip: Highlight All Formula Cells; Bonus Tip: Trace Precedents to See What Cells Flow into a Formula; Bonus Tip: See Which Cells Depend on the Current Cell. |
| 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) |
|
COMPUTERS -- Desktop Applications -- Spreadsheets. |
| Genre/Form |
Electronic books.
|
| Other Form: |
Print version: 1615470565 9781615470563 (OCoLC)1004539714 |
| ISBN |
9781615472390 (electronic book) |
|
1615472398 (electronic book) |
|
9781615473625 (electronic book) |
|
1615473629 (electronic book) |
|
9781615470563 |
|
1615470565 |
|
