🛣️ Data Analyst Roadmap ➡︎ https://datawithmo.com/
📚 1:1 Mentorship and more ➡︎ https://topmate.io/datawithmo
I’ll show you 10 Excel tips and tricks in less than 5 minutes. I’ll cover each tip in under 45 seconds. Watch closely and enjoy!
*Professional Certificates*
📖 Google Data Analytics Professional Certificate ➡︎ https://imp.i384100.net/googleDACert
📊 Google Advanced Data Analytics Professional Certificate ➡︎ https://imp.i384100.net/googleAdvDataCert
📚 Google Business Intelligence Professional Certificate ➡︎ https://imp.i384100.net/googleBIcert
📈 Microsoft Power BI Data Analyst Professional Certificate ➡︎ https://imp.i384100.net/MicrosoftPowerBIdaProfCert
📉 IBM Data Analyst Professional Certificate ➡︎ https://edx.sjv.io/IBMdataAnalyst
📚 Harvard University Data Science Professional Certificate ➡︎ https://edx.sjv.io/HarvardDataScience
📗 IBM Data Science Professional Certificate ➡︎ https://edx.sjv.io/IBMdataScience
📕 UC San Diego Data Science MicroMasters Program ➡︎ https://edx.sjv.io/UCSDdataScience
📑 MIT Statistics & Data Science MicroMasters Program ➡︎ https://edx.sjv.io/MITstatisticsDataScience
*Courses*
📄 Excel ➡︎ https://imp.i384100.net/IBMexcel
👨💻 SQL ➡︎ https://imp.i384100.net/UCDavisSQLDataScience
📊 Tableau ➡︎ https://imp.i384100.net/tableauDataVisualization
📈 Power BI ➡︎ https://imp.i384100.net/MicrosoftPowerBIdaProfCert
💻 Python ➡︎ https://imp.i384100.net/IBMpython
*Join the Community*
Become a DWM Supporter ➡︎ https://www.youtube.com/@datawithmo/join
Instagram ➡︎ https://www.instagram.com/mo_chen1/
Discord ➡︎ https://discord.gg/Ay7gQTXE
Please note I may earn a small commission for any purchase through these links. Thanks a lot for supporting the channel!
All opinions or statements in this video are my own and do not reflect the opinion of the organisation I work for or have ever worked for.
*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
