Microsoft Excel: 99 Pro Hacks and Tips New

Workbooks and Worksheets

• Navigational Techniques
• Zooming In and Out Quickly
• Copying and Moving Worksheets
• Custom Views
• Print Setups
• Inserting a Watermark

Organizing and Working with Data

• Data Entry Techniques
• Using AutoCorrect
• Entering and Linking Data across Multiple Worksheets
• Selection Methods
• Filling Blank Cells with Value
• Copying and Pasting Options
• Using the Quick Analysis Tool

Formatting

• Leading Zeros
• Adding Text to Numbers
• Managing Line Break within Cell
• Adding Comments Inside Formulas
• Creating Bulleted List
• Format Painter Tips
• Applying Formulas Based Conditional Formatting

Numbers, Dates and Formulas

• AutoSum Magic
• Managing Range Names
• Applying Formulas Based Data Validation
• Linking Text Boxes to Cell Contents

Tables and PivotTables

• Creating Table using Shortcuts
• Creating Formulas using Structured References
• Working with Recommended PivotTables
• Splitting PivotTable into Multiple Worksheets
• Extracting Records from PivotTable

Charts

• Working with Recommended Charts
• Setting Default Chart
• Creating Mini Charts using Sparklines
• Linking Titles and Labels with Cell Contents
• Dealing with Missing Data

Working with Hidden Tools

• Activate Hidden Commands to Quick Access Toolbar or Custom Tabs
• Using the Hidden Tools

Anyone from a novice to an expert Excel user, from managerial to operational personnel