Add powerful productivity tools to your Excel skill set. Learn shortcuts and hidden tools for supercharging your efficiency in Microsoft Excel.
Overview
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
Taught by
Chris Dutton
Related Courses
-
Excel PRO TIPS Part 1: Productivity
-
Excel Using Only Keyboard- Advance Shortcuts,Tips & Tricks
-
Beyond Excel I: Coda as Productivity Tool for Lean Startups, Entrepreneurs, and Freelancers
-
Work Smarter with Microsoft Excel
-
Excel Data Visualization Part 1: Charts & Graphs
-
Microsoft Office: Word, Excel and Access Productivity Bundle
