Top 5 Excel skills you should focus on to become a better analyst
Excel has 100s of features, so which ones should you focus on? In this video, let me show you the 5 features that you should focus on this year. Learn these 5 first and then you can expand your knowledge to other areas.
💥DOWNLOAD MY FREE GUIDE ON THESE 5 SKILLS
===========================================
Go to https://chandoo.org/wp/5xls and download my 5 page eBook on the topics presented in the video. Learn these 5 skills using the roadmap in the book.
⏱IN THIS VIDEO 👇
================
0:00 - Introduction to the 5 skills
0:34 - Skill 5 - Data Types in Excel
2:39 - Skill 4 - Multi-Table Pivot or Power Pivot
5:30 - Skill 3 - Story-telling with better charts in Excel
8:02 - Skill 2 - Dynamic Arrays in Excel
10:08 - Honourable mention - LAMBDA Functions
10:35 - Skill 1 - Power Query
13:07 - How to get the 5 skills
🤩 WATCH NEXT
==============
~PLAYLIST - Important Skills for Data Analysts - https://youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
~VIDEO - Power Query Masterclass (90 mins) - https://youtu.be/PiFAa_jjaEI
~COURSE - Learn Excel step by step - https://chandoo.org/wp/excel-school-program/
📗SAMPLE FILES
==============
5 Page eBook with the details on these skills - https://chandoo.org/wp/5xls
Excel file used in the video - https://chandoo.org/wp/wp-content/uploads/2022/01/Top-Excel-Skills-you-need-to-learn-this-year.xlsx
#ExcelSkills
Видео Top 5 Excel skills you should focus on to become a better analyst канала Chandoo
💥DOWNLOAD MY FREE GUIDE ON THESE 5 SKILLS
===========================================
Go to https://chandoo.org/wp/5xls and download my 5 page eBook on the topics presented in the video. Learn these 5 skills using the roadmap in the book.
⏱IN THIS VIDEO 👇
================
0:00 - Introduction to the 5 skills
0:34 - Skill 5 - Data Types in Excel
2:39 - Skill 4 - Multi-Table Pivot or Power Pivot
5:30 - Skill 3 - Story-telling with better charts in Excel
8:02 - Skill 2 - Dynamic Arrays in Excel
10:08 - Honourable mention - LAMBDA Functions
10:35 - Skill 1 - Power Query
13:07 - How to get the 5 skills
🤩 WATCH NEXT
==============
~PLAYLIST - Important Skills for Data Analysts - https://youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
~VIDEO - Power Query Masterclass (90 mins) - https://youtu.be/PiFAa_jjaEI
~COURSE - Learn Excel step by step - https://chandoo.org/wp/excel-school-program/
📗SAMPLE FILES
==============
5 Page eBook with the details on these skills - https://chandoo.org/wp/5xls
Excel file used in the video - https://chandoo.org/wp/wp-content/uploads/2022/01/Top-Excel-Skills-you-need-to-learn-this-year.xlsx
#ExcelSkills
Видео Top 5 Excel skills you should focus on to become a better analyst канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explainedAwesome Power Query example - Calendar data to table format 📅➡📄Employee Shift Tracker Excel Template - How it worksConvert number to words with this Excel formula + LET Function DemoMay the Power BI with you - Demo of Star Wars Infographic🧇 Yummy WAFFLE Chart in Power BI - How to make one?How to do weighted sorting in Excel?Celebrate Halloween with Creepy Spider Web Chart in ExcelKNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌How to create a fully *INTERACTIVE* and AWESOME Dashboard in Excel (PART 2)How to split text values in Excel with formulas - Quick Solution ⏳Combine Excel Sheets with *this* simple formulaDAX Concepts: How to Create Best in Category Calculations with EaseWhere to get FREE Datasets to practice Data AnalyticsAverage calculation in Excel, but with a twist 🥨Try this yummy Lollipop Chart 🍭 (Excel trick)Easiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire)Can you split The Hangover expenses using Excel?How to connect to Amazon AWS S3 Buckets from Power BI - Step by Step Tutorial (with code samples)6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) ⏰Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...