KEMBAR78
Excel Learning Path For Data Analyst | PDF
Scribd
Upload
28 views1 page

Excel Learning Path For Data Analyst

The document outlines a free learning path for Excel aimed at data analysts, structured over two weeks. Week 1 focuses on Excel fundamentals, core functions, and practical tasks, while Week 2 covers advanced features like Pivot Tables, charts, and Power Query. Additionally, it includes a practice project to create a Sales Performance Dashboard using a provided dataset.

Uploaded by

sanjufaujdar88
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
28 views1 page

Excel Learning Path For Data Analyst

The document outlines a free learning path for Excel aimed at data analysts, structured over two weeks. Week 1 focuses on Excel fundamentals, core functions, and practical tasks, while Week 2 covers advanced features like Pivot Tables, charts, and Power Query. Additionally, it includes a practice project to create a Sales Performance Dashboard using a provided dataset.

Uploaded by

sanjufaujdar88
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Excel for Data Analyst: Free Learning Path

WEEK 1 - Excel Fundamentals & Core Functions


- Day 1: Excel Interface, Navigation, Formatting Basics
- Day 2: Data Entry, Cleaning Tools (TRIM, CLEAN, Remove Duplicates)
- Day 3: Basic Math & Statistical Functions (SUM, AVERAGE, COUNT, etc.)
- Day 4: Logical Functions (IF, AND, OR, NOT, Nested IFs)
- Day 5: Text Functions (LEFT, RIGHT, MID, LEN, FIND, etc.)
- Day 6: Lookup Functions (VLOOKUP, HLOOKUP, INDEX+MATCH)
- Day 7: Practice Task - Clean and Analyze a Simple Sales Dataset

WEEK 2 - Pivot Tables, Charts & Power Tools


- Day 8: Pivot Tables - Creation, Filters, Slicers
- Day 9: Pivot Charts, Grouping, Summarizing
- Day 10: Excel Tables, Named Ranges, Structured References
- Day 11: Charts & Data Visualization (Bar, Line, Pie, Combo)
- Day 12: Power Query Basics - Import, Clean, Combine Data
- Day 13: Error Handling (IFERROR, ISBLANK, Formula Auditing)
- Day 14: Mini Dashboard Project - Create a Sales Dashboard

Practice Project You Can Start Today


- Project: Sales Performance Dashboard
- - Dataset: Monthly sales of 5 products across 4 regions
- - Tasks:
- * Clean the data (remove blanks, fix formats)
- * Create Pivot Table for product vs revenue
- * Use charts to visualize trends
- * Build a dashboard with slicers & charts

You might also like