Essential Skill Tracker for Excel
by Animesh Singh
follow me on ......LinkedInBasic things first... How I started my journey as a Data Analyst and how you can start your journey as an Analyst.
Things to know to Organize your skill and Work
🔥 The skills below will prepare you for almost any entry-level Data Analyst role!
Each points has a skills list, video tutorials, and guided projects
- Skills List
- Aggregations (SUM, COUNT, AVERGAE)
- Charting
- Bar Chart
- Column Chart
- Combo Chart
- Line Chart
- Pie Chart
- CONCAT
- Creating Tables
- Familiar with Ribbon Groups
- IF
- COUNTIF
- IFERROR
- SUMIF
- IFELSE
- TODAY()
- Pivot Tables
- Lookup Functions (XLOOKUP, VLOOKUP)
- Slicers
- Timelines
- Sparklines
- Video Tutorials
- Excel Formulas and Functions by Kevin Stewart
- Charts in Excel by Alex the Analyst
- Excel Pivot Tables Explained by Leila Gharani
- XLOOKUP in Excel by Alex the Analyst
- Excel Shortcut Keys by Kevin Stewart
- Sparklines by Microsoft
- Full Project in Excel by Alex the Analyst