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

Go to class Write review
Corporate Finance Institute Ad

Get 35% Off CFI Certifications - Code CFI35

Learn More → Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.