Excel for Data Science

Beginner to Advanced | 45-Day Schedule

45-Day Schedule

1
Week 1: Excel Basics and Data Handling

Learn how to navigate Excel, organize data, and clean data for analysis.

2
Week 2: Advanced Functions and Formulas

Master advanced Excel functions like IF, VLOOKUP, financial, and statistical functions.

3
Week 3: Data Analysis Tools in Excel

Learn how to use Pivot Tables, Power Query, Power Pivot, and Solver for analysis.

4
Week 4: Data Visualization Techniques

Understand how to create impactful charts, dashboards, and visualizations in Excel.

5
Week 5: Advanced Analysis Techniques

Learn advanced techniques like regression analysis, time series, and Monte Carlo simulation.

6
Week 6: Excel for Data Science Applications

Apply Excel in data science applications, including predictive analytics and integrating with Python.

Course Information

Prerequisites: Basic understanding of Excel. No prior experience required.

Skills Covered: Data analysis, advanced formulas, Pivot Tables, charts, dashboards, regression analysis, and Excel automation.

Course Outcomes: Master Excel for data analysis and decision-making, and apply Excel in data science projects.

Modules

Excel Basics and Data Handling

Learn Excel navigation, data handling, and cleaning techniques.

  • Introduction to Excel
  • Data Cleaning and Organization
  • Sorting, Filtering, and Data Validation
Advanced Functions and Formulas

Master advanced Excel functions such as IF, VLOOKUP, financial, and statistical functions.

  • Logical and Lookup Functions
  • Date and Time Functions
  • Financial and Statistical Functions
Data Analysis Tools in Excel

Learn how to use Pivot Tables, Power Query, and Power Pivot for data analysis.

  • Pivot Tables and Pivot Charts
  • Power Query and Power Pivot
  • Optimization with Solver
Data Visualization Techniques

Master Excel charting, dashboards, and best practices for data visualization.

  • Creating Excel Charts
  • Building Dashboards
  • Data Visualization Best Practices

Final Project

Project Description: Build an interactive dashboard and perform data analysis using Excel:

  • Use of Pivot Tables, charts, and dynamic dashboards
  • Apply advanced Excel functions to solve real-world problems
  • Automate tasks using macros and VBA