Data Analyst's Top 10 Excel Tips UNDER 5 MIN

DATA PORTFOLIO & RESUME: mochen.info/
SPONSORSHIPS: 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.

PROFESSIONAL CERTIFICATES
🧑💻 Microsoft Power BI Data Analyst Professional Certificate: imp.i384100.net/MicrosoftPowerBIdaProfCert
📊 Tableau Business Intelligence Analyst Professional Certificate: imp.i384100.net/TableauBIAnalyst
💻 Google Data Analytics Professional Certificate: imp.i384100.net/googleDACert
🖥️ Google Advanced Data Analytics Professional Certificate: imp.i384100.net/googleAdvDataCert
📚 IBM Data Analytics with Excel and R Professional Certificate: imp.i384100.net/IBMdataAnalytics
📖 IBM Data Science Professional Certificate: imp.i384100.net/IBMdataScience
🏢 Google Project Management Professional Certificate: imp.i384100.net/GoogleProjectManagement
⌨️ Google Prompting Essentials: imp.i384100.net/GooglePromptingEssentialsMoChen
☁️ AWS Cloud Practitioner Essentials: imp.i384100.net/aws-cloud-practitioner
⛅ Microsoft Azure Data Fundamentals DP-900 Exam Prep Specialization: imp.i384100.net/azureDP900dataFundamentalsMoChen
🤖 Microsoft Azure AI Fundamentals AI-900 Exam Prep Specialization: imp.i384100.net/azureAIMoChen
👩💻 Microsoft Azure Fundamentals AZ-900 Exam Prep Specialization: imp.i384100.net/az-900-mo-chen
🌥️ Google Cloud Data Analytics Professional Certificate: imp.i384100.net/GoogleCloudDataAnalyticsMoChen

TIMESTAMPS
00:00 Intro
00:18 Show All Formulas
00:34 Flash Fill with Ctrl + E
00:55 Import PDF Tables
01:41 Auto Adjust All Row Heights and Column Widths
02:07 Alt Sum
02:26 Import Data From Websites
03:16 Convert Days to Year
03:39 Highlight All Cells With Formulas
04:00 Insert Notes with Shift + F2
04:25 Insert Timelines
04:49