LEARN DATA SKILLS
🌐 My website: https://mochen.info/
LET'S COLLABORATE
🤝 Sponsorships & long-term partnerships: https://mo-chen.notion.site/partnerships
ABOUT ME
I'm Mo and I work as a data & analytics manager / content creator. I make content about how best to learn new data skills and/or improve your existing data skills.
PROFESSIONAL CERTIFICATES
🧑💻 Microsoft Power BI Data Analyst Professional Certificate: https://imp.i384100.net/MicrosoftPowerBIdaProfCert
📊 Tableau Business Intelligence Analyst Professional Certificate: https://imp.i384100.net/TableauBIAnalyst
💻 Google Data Analytics Professional Certificate: https://imp.i384100.net/googleDACert
🖥️ Google Advanced Data Analytics Professional Certificate: https://imp.i384100.net/googleAdvDataCert
📚 IBM Data Analytics with Excel and R Professional Certificate: https://imp.i384100.net/IBMdataAnalytics
📖 IBM Data Science Professional Certificate: https://imp.i384100.net/IBMdataScience
🏢 Google Project Management Professional Certificate: https://imp.i384100.net/GoogleProjectManagement
⌨️ Google Prompting Essentials: https://imp.i384100.net/GooglePromptingEssentialsMoChen
☁️ AWS Cloud Practitioner Essentials: https://imp.i384100.net/aws-cloud-practitioner
⛅ Microsoft Azure Data Fundamentals DP-900 Exam Prep Specialization: https://imp.i384100.net/azureDP900dataFundamentalsMoChen
🤖 Microsoft Azure AI Fundamentals AI-900 Exam Prep Specialization: https://imp.i384100.net/azureAIMoChen
👩💻 Microsoft Azure Fundamentals AZ-900 Exam Prep Specialization: https://imp.i384100.net/az-900-mo-chen
🌥️ Google Cloud Data Analytics Professional Certificate: https://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 Outro