10 Essential Excel Shortcuts You Need to Master (NOW)

Get started with DataCamp's Excel Fundamentals Learning Track here: datacamp.pxf.io/ExcelFundamentalsDataCampMoChen
Or check out the Data Analyst Certification by DataCamp here: datacamp.pxf.io/dataAnalystCert

I'M HERE TO HELP YOU LAND YOUR NEXT TECH & DATA JOB
🌐 My website: mochen.info/

LET'S COLLABORATE
🤝 Sponsorships & long-term partnerships: mo-chen.notion.site/partnerships

ABOUT ME
I'm Mo and I work as a data analytics manager / content creator. I make videos about how best to get your next job in the tech & data space; whether you're a beginner, career switcher, or someone looking to take their tech & data career to the next level.

COURSES & CERTIFICATES
🖥️ Get 25% OFF DataCamp's Courses & Certificates: datacamp.pxf.io/DataCampMoChen

INDUSTRY RECOGNIZED CERTIFICATIONS
🧑‍💻 Data Analyst Certification Program: datacamp.pxf.io/dataAnalystCertDataCamp
📊 PowerBI Data Analyst Certification Program: datacamp.pxf.io/PowerBIDataAnalyst
👩‍💻 Data Scientist Certification Program: datacamp.pxf.io/DataScientistCert
💻 SQL Associate Certification Program: datacamp.pxf.io/SQLAssociateCert

TOP DATA ANALYST COURSES
📈 Data Analyst with Python: datacamp.pxf.io/dataAnalystWithPython
👨‍💻 Data Analyst with PowerBI: datacamp.pxf.io/dataAnalystPowerBIMoChen
⌨️ Associate Data Analyst in SQL: datacamp.pxf.io/AssociateDataAnalystSQL

TOP DATA SCIENTIST COURSES
🧪 Associate Data Scientist in Python: datacamp.pxf.io/AssociateDataScientistPython
🧑‍💻 Associate Data Scientist in R: datacamp.pxf.io/AssociateDataScientistR

TOP DATA ENGINEER COURSES
👩‍💻 Data Engineer in Python: datacamp.pxf.io/DataEngineerInPython

TOP BUSINESS INTELLIGENCE COURSES
💹 PowerBI Fundamentals: datacamp.pxf.io/PowerBIFundamentals
📊 Tableau Fundamentals: datacamp.pxf.io/TableauFundamentals

TOP PROGRAMMING LANGUAGE COURSES
💻 Python Fundamentals for Data Science: datacamp.pxf.io/PythonFundamentalsDataScience
🧑‍💻 Python Fundamentals for Programming: datacamp.pxf.io/PythonFundamentalsProgramming
⌨️ SQL Fundamentals: datacamp.pxf.io/SQLFundamentals
🎒 R Programming Fundamentals: datacamp.pxf.io/RFundamentals

TOP AI COURSES
🤖 AI Engineer for Developers Course: datacamp.pxf.io/AIEngineerDevelopers
🦾 AI Engineer for Data Scientists Course: datacamp.pxf.io/AIEngineerDataScientists
🦿 Developing AI Applications Course: datacamp.pxf.io/AIApplications

VIDEO SUMMARY
10 of my most used Microsoft Excel shortcuts that I use daily at work. I’ll cover worksheet navigation shortcuts, how to quickly insert a pivot table, how to format numbers with ease and speed, and much, much more.

TIMESTAMPS
00:00 Quick Summary (Dataset, Tooling)
01:47 Shortcut 1 - Auto Adjust All Column Widths and Row Heights
04:10 Shortcut 2 - Switch Tabs Quickly
05:09 Shortcut 3 - Move Around the Worksheet and Select Cells With Keyboard Only
07:00 Shortcut 4 - Move to First Cell / Last Cell
08:58 Shortcut 5 - Copy Worksheet
09:49 Shortcut 6 - All / No Borders
11:00 Shortcut 7 - Format Cells
12:50 Shortcut 8 - Paste as Values Only
15:05 Shortcut 9 - F2
16:21 Shortcut 10 - Inse