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.

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

Reviews

4.7 rating at LinkedIn Learning based on 1730 ratings

Start your review of Excel: Productivity Tips

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.