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
