Data Analyst's Top 10 Excel Tips UNDER 5 MIN

GET YOUR DATA JOB ➡ https://mochen.info/

ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ https://mochen.info/ultimate-data-portfolio-lp/

AI JOB QUEST: Change the way you apply to jobs ➡ https://mochen.info/ai-job-quest-lp/

PATREON ➡ https://www.patreon.com/mo_chen

1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ https://mochen.info/1-1-mentorship-lp/

CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?course=data-analytics

Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ https://www.youtube.com/playlist?list=PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU


┋Community & Socials┋

https://discord.gg/EBh7j9uRJ2 ⬅ Join our Discord Data Community

https://www.instagram.com/mo_chen1/ ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well

https://www.linkedin.com/in/mo-chen1/ ⬅ Daily tips & advice on how to enhance your data analysis skills

https://twitter.com/mo_chen_1 ⬅ Figuring out what I want to do in this space...


┋Professional Certificates┋

CourseCareers ➡ https://coursecareers.com/a/mochen

DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/1112311/13294

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certificates/data-analytics-certificate?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6t39nRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certificates/advanced-data-analytics-certificate?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6tWpnRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c

Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst

Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional-certificates/microsoft-power-bi-data-analyst?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6tVZnRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c

IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience

Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProjectManagement


┋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

Скачать видео