Get started with DataCamp's Excel Fundamentals Learning Track here: https://datacamp.pxf.io/ExcelFundamentalsDataCampMoChen
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 enquiries@mochen.info
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/dataAnalystCertDataCamp
PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAnalyst
Data Scientist Certification Program: https://datacamp.pxf.io/DataScientistCert
SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert
TOP DATA ANALYST COURSES
Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWithPython
Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPowerBIMoChen
Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateDataAnalystSQL
TOP DATA SCIENTIST COURSES
Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateDataScientistPython
Associate Data Scientist in R: https://datacamp.pxf.io/AssociateDataScientistR
TOP DATA ENGINEER COURSES
Data Engineer in Python: https://datacamp.pxf.io/DataEngineerInPython
TOP BUSINESS INTELLIGENCE COURSES
PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundamentals
Tableau Fundamentals: https://datacamp.pxf.io/TableauFundamentals
TOP PROGRAMMING LANGUAGE COURSES
Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundamentalsDataScience
Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundamentalsProgramming
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/AIEngineerDevelopers
AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDataScientists
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