10 Essential Excel Shortcuts You Need to Master (NOW)

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

DATA PORTFOLIO & RESUME: https://mochen.info/
SPONSORSHIPS: https://mo-chen.notion.site/partnerships OR email me at [email protected]

ABOUT ME
I'm Mo and I work as a data analytics manager / content creator. I make videos about how you can stay competitive / ahead of the competition in the data industry.

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

INDUSTRY RECOGNIZED CERTIFICATIONS
Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCe...
PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAn...
Data Scientist Certification Program: https://datacamp.pxf.io/DataScientist...
SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert

TOP DATA ANALYST COURSES
Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWi...
Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPo...
Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateData...

TOP DATA SCIENTIST COURSES
Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateData...
Associate Data Scientist in R: https://datacamp.pxf.io/AssociateData...

TOP DATA ENGINEER COURSES
Data Engineer in Python: https://datacamp.pxf.io/DataEngineerI...

TOP BUSINESS INTELLIGENCE COURSES
PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundam...
Tableau Fundamentals: https://datacamp.pxf.io/TableauFundam...

TOP PROGRAMMING LANGUAGE COURSES
Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundame...
Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundame...
SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals
R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals

TOP AI COURSES
AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDev...
AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDat...
Developing AI Applications Course: https://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 - Insert Pivot Table in 1 Second