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

LinkedIn Learning

Excel Productivity Tips: Work Faster with Shortcuts, Formulas, and AI

via LinkedIn Learning

Write review
Simplilearn Ad

Lead AI Strategy with UCSB's Agentic AI Program — Microsoft Certified

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Elevate your usage of Excel by learning tricks and techniques to work faster, avoid errors, and handle data like a pro. Learn keyboard shortcuts, formulas, and about AI-powered tools.

Syllabus

Introduction
  • Turn hours into minutes with Excel shortcuts
1. Excel Workspace Setup and Navigation
  • Customize your ribbon and create your own keyboard shortcuts
  • The navigation shortcuts every Excel user needs to know
  • Workbook window productivity hacks
2. Smart Data Entry and Formatting
  • AutoFill any type of list
  • How to format every worksheet at once
  • Create all your Excel worksheets in one click
  • Automatically format your data
3. Data Cleanup in Excel
  • Flash fill any data
  • How to fill blank cells in seconds
  • Challenge: Delete blank rows
  • Solution: Delete blank rows
4. Data Analysis with Excel
  • Excel tables
  • How to automatically calculate data with AutoSum
  • Upgrade your Excel filters with slicer buttons
5. AI-Powered Excel with Copilot
  • Debug and write formulas with Copilot
  • Build a pivot table and a chart in seconds with Copilot
  • Create a full Excel dashboard with Copilot
Conclusion
  • Next steps

Taught by

Chris Dutton

Reviews

4.8 rating at LinkedIn Learning based on 226 ratings

Start your review of Excel Productivity Tips: Work Faster with Shortcuts, Formulas, and AI

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.