Overview
-
Add powerful productivity tools to your Excel skill set. Learn shortcuts and hidden tools for supercharging your efficiency in Microsoft Excel.
Syllabus
-
Introduction
- About the Excel Productivity Tip series
- Introduction to Excel Productivity Tips
- Customizing the Excel footer
- Navigating workbooks with CTRL shortcuts
- Accessing ribbon tools with Alt key tips
- Accessing the Go To Special options
- Removing blank rows
- Creating drop-down menus with Data Validation
- Filling patterns with AutoFill and Flash Fill
- Customizing the Excel ribbon tools
- Splitting text to columns
- Synchronous scrolling across multiple workbooks
- Extracting unique values from a list
- Using named range and table references
- Protecting cells and formulas
- Conclusion: Productivity tips
