1How This Book Can Help You
387.4. How to Count the Number of Unique Entries
2How to Use the Demo Videos & Exercise Files
397.5. How to Use Conditional Formatting to Highlight Formula Cells
31. Seven Significant Shortcuts
407.6. How to Perform Calculations Without Formulas
41.1. How to Enter Data or Formulas in Non-adjacent Cells Simultaneously
418. Operational Shortcuts
51.2. How to Copy Data or Formulas Down a Column
428.1. How to Insert, Delete, Hide and Unhide Columns and Rows
61.3. How to Instantly Enter Today's Date or Time
438.2. How to Realign Imported Text
71.4. How to Convert Formulas to Values with a Simple Drag
448.3. How to Select and Manipulate Blank Cells
81.5. How to Display All Worksheet Formulas
458.4. How to Collapse and Expand Detail with Group and Ungroup Buttons
91.6. How to Create Charts with these Keystroke Shortcuts
468.5. How to Create Double-spaced or Triple-spaced Printouts
101.7. How to Zoom In and Out Quickly
479. Formatting Shortcuts
112. Ribbon & Quick Access Toolbar Tips
489.1. How to Use Keystroke Shortcuts for Frequently Needed Numeric Formats
122.1. How to Access Ribbon Commands with Alt Key Sequences
499.2. How to Accentuate Data with Alignment Tools
132.2. How to Expand/Collapse the Ribbon and Full-screen Views
509.3. How to Add a Color Background to Every 5th Row in a Range
143. Display Shortcuts
519.4. How to Use Conditional Formatting Based on Comparison Criteria
153.1. How to Create Split Screens and Frozen Titles in a Flash
529.5. How to Use Special Formats for Times Over 24 Hours
163.2. How to Restore Missing Labels and Hide Repeating Labels
539.6. How to Add and Remove Strikethrough and Borders with Keystroke Shortcuts
173.3. How to Customize the Display of Status Bar Totals
549.7. How to Display Values in Thousands or Millions without Formulas
184. Navigation & Selection Shortcuts
559.8. How to Format Phone and Social Security Numbers
194.1. How to Navigate Between Workbooks and Worksheets Efficiently
5610. Data Management Techniques
204.2. How to Navigate Within Worksheets Efficiently
5710.1. How to Clean up Spaces with the TRIM Function
214.3. How to Open, Close, Save and Create New Workbooks with Keystrokes
5810.2. How to Split Column Data Using Text to Columns and Flash Fill
224.4. How to Select an Entire Row, Column, Region or Worksheet
5910.3. How to Join Data with the TEXTJOIN Function and Flash Fill
234.5. How to Select Non-contiguous Ranges and Visible Cells Only
6010.4. How to Ensure Unique Entries with Data Validation Rules
245. Data Entry and Editing Shortcuts
6110.5. How to Display Unique Items from Large Lists
255.1. How to Accelerate Data Entry
6211. Charting and Visual Object Tips
265.2. How to Enter Dates and Date Series Efficiently
6311.1. How to Manipulate Chart Placement and Sizing with Dragging Techniques
275.3. How to Enter Times and Time Series Efficiently
6411.2. How to Create Chart Titles from Cell Content
285.4. How to Use Custom Lists for Data Entry and List-based Sorting
6511.3. How to Create and Manipulate Shapes with the Shift, Ctrl and Alt Keys
295.5. How to Enhance Editing Tools
6611.4. How to Create Linked Dynamic and Linked Static Images
306. Drag & Drop Techniques
6712. Pivot Tips
316.1. How to Accelerate Copy and Move Tasks Within Cells and Worksheets
6812.1. How to Adjust Report Layouts to Allow Totals on Top or Bottom
326.2. How to Drag and Insert Cells with the Shift Key
6912.2. How to Revisit Relevant Source Data with the Drill Down Feature
336.3. How to Display the Paste Special Options
7013. Ten Tiny Tips (Cheat Sheet): 13.1. How to Become a More Proficient Excel User with Ten Tiny Tips
347. Formula Shortcuts
7114. How to Download the Demo Videos and Exercise Files
357.1. How to Create Formulas Rapidly
7214.1 How to Get Further Help & Answers to Your Questions
367.2. How to Select All Dependent or Precedent Cells
7314.2 More Helpful Resources
377.3. How to Use AutoSum Shortcuts
