Scribd
Upload
40 views2 pages

6 Months Study Plan

The document outlines a 24-week training program focusing on Excel, Python, and SQL skills. Each week covers specific topics ranging from basic formulas and functions in Excel to advanced data visualization and report automation in Python. The program includes mini and real projects to apply the learned skills in practical scenarios.

Uploaded by

Rasel777
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
40 views2 pages

6 Months Study Plan

The document outlines a 24-week training program focusing on Excel, Python, and SQL skills. Each week covers specific topics ranging from basic formulas and functions in Excel to advanced data visualization and report automation in Python. The program includes mini and real projects to apply the learned skills in practical scenarios.

Uploaded by

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

Week Topic/Focus

Week 1 Excel: Basic Formulas, Functions, Cleaning Data


Week 2 Excel: Sorting, Filtering, Conditional Formatting
Week 3 Excel: Pivot Tables, Basic Charts
Week 4 Python: Syntax, Variables, If-Else, Loops
Week 5 Excel: Power Query & Data Transformation
Week 6 Excel: Power Pivot & DAX
Week 7 Python: Functions, Lists, Dictionaries
Week 8 Python: Pandas Library Basics
Week 9 Excel: Dashboard Design, Slicers, KPI Cards
Week 10 Python: Data Cleaning with Pandas
Week 11 Python: Data Visualization with Matplotlib/Seaborn
Week 12 Mini Project: Excel & Python Data Report
Week 13 Real Project 1: Sales/Shipment Analysis (Excel)
Week 14 Python: Merging/Joining Datasets, Groupby
Week 15 Python: Exporting Results to Excel
Week 16 SQL: SELECT, WHERE, JOIN (Basic SQL)
Week 17 Real Project 2: Courier Efficiency Dashboard (Excel+Python)
Week 18 Python: Automating Reports with openpyxl
Week 19 Python: Advanced Visualizations
Week 20 SQL: GROUP BY, HAVING, Nested Queries
Week 21 Real Project 3: End-to-End Report Automation
Week 22 Excel: Dynamic Dashboards Review
Week 23 Python: Portfolio Building on GitHub
Week 24 Final Assessment & Skill Review
Week Topic/FocusCompleted
Week 1 Excel: Basic Formulas, Functions, Cleaning Data
Week 2 Excel: Sorting, Filtering, Conditional Formatting
Week 3 Excel: Pivot Tables, Basic Charts
Week 4 Python: Syntax, Variables, If-Else, Loops
Week 5 Excel: Power Query & Data Transformation
Week 6 Excel: Power Pivot & DAX
Week 7 Python: Functions, Lists, Dictionaries
Week 8 Python: Pandas Library Basics
Week 9 Excel: Dashboard Design, Slicers, KPI Cards
Week 10 Python: Data Cleaning with Pandas
Week 11 Python: Data Visualization with Matplotlib/Seaborn
Week 12 Mini Project: Excel & Python Data Report
Week 13 Real Project 1: Sales/Shipment Analysis (Excel)
Week 14 Python: Merging/Joining Datasets, Groupby
Week 15 Python: Exporting Results to Excel
Week 16 SQL: SELECT, WHERE, JOIN (Basic SQL)
Week 17 Real Project 2: Courier Efficiency Dashboard (Excel+Python)
Week 18 Python: Automating Reports with openpyxl
Week 19 Python: Advanced Visualizations
Week 20 SQL: GROUP BY, HAVING, Nested Queries
Week 21 Real Project 3: End-to-End Report Automation
Week 22 Excel: Dynamic Dashboards Review
Week 23 Python: Portfolio Building on GitHub
Week 24 Final Assessment & Skill Review

You might also like