_Banner_Tips-Tricks_Yelo.webp)
Chapter 9
Operational Shortcuts
Insert, Delete, Hide & Unhide Columns & Rows
Chapter 9
Operational Shortcuts
Re-align Imported Text
Chapter 9
Operational Shortcuts
Select and Manipulate Blank Cells
Chapter 9
Operational Shortcuts
Collapse & Expand Detail with Outlining Shortcuts
Chapter 9
Operational Shortcuts
Create Double-Spaced or Triple-Spaced Printouts
Chapter 10
Formatting Shortcuts
Keystroke Shortcuts for Frequent Numeric Formats
Chapter 10
Formatting Shortcuts
Accentuate Data with Alignment Tools
Chapter 10
Formatting Shortcuts
Add Color Background to Every 5th Row in a Range
Chapter 10
Formatting Shortcuts
Conditional Formatting Based on Comparison Criteria
Chapter 10
Formatting Shortcuts
Conditional Formatting to Highlight Formula Cells
Chapter 10
Formatting Shortcuts
Create Custom Formats. Dot Leaders and More
Chapter 10
Formatting Shortcuts
Use Special Formats for Times over 24 hours
Chapter 10
Formatting Shortcuts
Add/Remove Strikethrough & Borders with Keystrokes
Chapter 10
Formatting Shortcuts
Quickly Format Phone and SS Numbers
Chapter 11
Data Management Techniques
Sort Data with Single Buttons
Chapter 11
Data Management Techniques
Clean up Spaces with the TRIM Function
Chapter 11
Data Management Techniques
Identify and Eliminate Duplicates
Chapter 11
Data Management Techniques
Split Column Data using Text to Columns & Flash Fill
Chapter 11
Data Management Techniques
Join Data with the TEXTJOIN Function & Flash Fill
Chapter 11
Data Management Techniques
Ensure Unique Entries with Data Validation
Chapter 11
Data Management Techniques
Force Typed Dates to be Weekdays Only with Data Validation
Chapter 11
Data Management Techniques
Display Unique Items from Large Lists
Chapter 12
Charting and Visual Objects Tips
Manipulate Chart Placement with Dragging Techniques
Chapter 12
Charting and Visual Objects Tips
Create Chart Titles from Cell Content
Chapter 12
Charting and Visual Objects Tips
Create & Manipulate Shapes with Shift, Ctrl & Alt keys
Chapter 12
Charting and Visual Objects Tips
Create Linked Dynamic & Linked Static Images
Chapter 13
Ten Tiny Tips
Be a More Proficient Excel user with these Short Tips
Chapter 13
Conclusion
Goodbye
