Month 12: Utilizing Excel for Business Analytics
Week 1: Excel Basics for Business Analytics
- Day 1: Introduction to Excel
- Day 2: Basic Data Manipulation in Excel
- Day 3: Working with Excel Formulas and Functions
- Day 4: Data Cleaning in Excel
- Day 5: Excel Shortcuts for Efficiency
Week 2: Advanced Excel for Business Analytics
- Day 1: Pivot Tables in Excel
- Day 2: Data Validation in Excel
- Day 3: Conditional Formatting in Excel
- Day 4: Lookup Functions in Excel: VLOOKUP and HLOOKUP
- Day 5: What-If Analysis in Excel
Week 3: Excel for Data Analysis
- Day 1: Statistical Analysis in Excel
- Day 2: Regression Analysis in Excel
- Day 3: Time Series Analysis in Excel
- Day 4: Scenario Analysis and Goal Seek in Excel
- Day 5: Solver for Optimization Problems in Excel
Week 4: Excel for Data Visualization
- Day 1: Introduction to Data Visualization in Excel
- Day 2: Creating Charts and Graphs in Excel
- Day 3: Advanced Chart Types in Excel
- Day 4: Dashboard Creation in Excel
- Day 5: Best Practices for Data Visualization in Excel
dowhatkennydoes.com 