Excel: Productivity Tips

1h 23mIntermediate2020-08-04

Authors

Chris Dutton

Certified Microsoft Excel Expert, Analytics Consultant

Course details

Supercharge your productivity, work more efficiently, and become an Excel power user by mastering the same tools and techniques used by the pros. In this course, analytics expert and instructor Chris Dutton guides you through demos and case studies designed to help you add powerful productivity tools to your Excel skill set. Learn how to navigate worksheets with keyboard shortcuts, remove blank rows quickly, apply fill patterns, protect cells and formulas, apply advanced sorting and filtering tools, and more. Follow along from home with downloadable PDF cheat sheets, practice workbooks, and solution files.

Note: Chris uses Microsoft Office 365 ProPlus (Microsoft 365 Apps) throughout the course, so some tips may not apply to all versions of Excel.

Topics include:
Navigating Excel with keyboard shortcuts
Removing blank rows
Using named ranges and table references
Protecting cells and formulas
Mastering advanced sorting and filtering tools

Skills covered

SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftOne-Off

Concepts

Introduction

About the Excel Productivity Tip series
Introduction to Excel Productivity Tips

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

Conclusion - Productivity tips