Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Productivity Tips

via LinkedIn Learning

Overview

Add powerful productivity tools to your Excel skill set. Learn shortcuts and hidden tools for supercharging your efficiency in Microsoft Excel.

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.

This course was created by Chris Dutton. We are pleased to offer this training in our library.

Syllabus

Introduction
  • About the Excel Productivity Tip series
  • Introduction to Excel Productivity Tips
1. 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

Taught by

Chris Dutton

Related Courses

Reviews

Start your review of Excel: Productivity Tips

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free