Data Analyst's Top 10 Excel Tips UNDER 5 MIN

Опубликовано: 28 Январь 2023
на канале: Mo Chen

13,835

741

https://mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle

  / mo-chen1   ⬅ Daily tips & advice on how to enhance your data analysis skills

  / mo_chen   ⬅ Support me on Patreon

   • Data Analysis Portfolio Projects   ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python

┋Professional Certificates┋

DataCamp Certifications ➡ https://datacamp.pxf.io/c/4216860/205...

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

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

Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...

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

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

┋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