🏡 Back Home

⬆:: Excel
⬅:: Planning
📅:: 2023-02-05
Источник:: https://youtu.be/x0Cd4TTOgwI
Автор:: Chandoo
📄 Roadmap PDF

Excel Roadmap - Chandoo

4 things (areas for focus - GCAP)

1. Get Data
2. Clean it
3. Analyze it
4. Present it

3 lanes

1. Technical
2. Project
3. Domain

3 months

Month 1 - Clean your data for better results

• intro, get data from
  • import from text
  • Power query
  • connection to DB
• clean data
  • ranges
  • refs
  • tabular formatting
• basic analysis (EDA) (descriptive analysis?)
  • bl_nks
  • duplicates
  • missing values
  • explain it smb
• Simple project: card spending for the last 2-3 years analysis

Month 2 Analysis

• excel formulas (switch?)
• cell references (relative, absolute,structured, spill ranges)
• Pivot table, Flash fill (ctrl+E), Power Pivot
• Statistical analysis with Excel (average, medians, frequencies, distributions)
• Domain knowledge (connect it with excel)
• Presenting result with excel (formatting, looks good)
• Project: expense tracker, retirement planner, wedding planner (a lot of lists)

Month 3

• Charts - which for what situations
• Chart customization, dynamic, interactive
• How to be productive
• Domain - kpis, reports techniques? same KPI - different calculation
• Project - from real life