Week 1: Introduction to Excel

Tutorial: Basic Excel Functions and Navigation

  1. Introduction to Excel interface: Ribbon, Tabs, Cells, and Formulas Bar.
  2. Entering data and basic calculations (e.g., addition, subtraction, multiplication, division).
  3. Autofill and AutoSum functions.
  4. Navigation shortcuts (e.g., Ctrl + arrow keys, Ctrl + Home).

Week 2: Formatting and Editing Data

Tutorial: Formatting Cells and Data

  1. Formatting text, numbers, and dates.
  2. Applying cell styles and conditional formatting.
  3. Inserting, deleting, and hiding rows and columns.
  4. Using find and replace.

Week 3: Working with Formulas and Functions

Tutorial: Basic Excel Formulas and Functions

  1. Understanding formulas and functions.
  2. Using common functions: SUM, AVERAGE, MAX, MIN.
  3. Writing basic formulas for calculations.
  4. Introduction to absolute and relative cell references.

Week 4: Data Management and Analysis

Tutorial: Sorting, Filtering, and Data Validation

  1. Sorting data alphabetically and numerically.
  2. Filtering data using AutoFilter and custom filters.
  3. Validating data input with Data Validation.
  4. Removing duplicates and managing data quality.

Week 5: PivotTables and Data Visualization

Tutorial: Creating PivotTables and Charts

  1. Introduction to PivotTables: creating, formatting, and filtering.
  2. Creating different types of charts: column, line, pie, and bar charts.
  3. Formatting and customizing charts.
  4. Using PivotCharts for dynamic visual analysis.

Week 6: Advanced Functions and Formulas

Tutorial: Advanced Excel Functions

  1. Logical functions: IF, AND, OR.
  2. Lookup and reference functions: VLOOKUP, HLOOKUP, INDEX, MATCH.
  3. Text functions: CONCATENATE, LEFT, RIGHT, MID.
  4. Date and time functions: TODAY, NOW, DATE, TIME.

Week 7: Data Analysis with Tables and Scenario Manager

Tutorial: Excel Tables and Scenario Manager

  1. Creating and managing Excel tables.
  2. Structured referencing and table formulas.
  3. Using Scenario Manager for what-if analysis.
  4. Creating scenarios and generating summary reports.

Week 8: Advanced Data Analysis Techniques

Tutorial: Goal Seek, Solver, and Data Analysis ToolPak

  1. Using Goal Seek to find desired outcomes.
  2. Solver tool for optimization problems.
  3. Introduction to Data Analysis ToolPak: Histograms, Descriptive Statistics, Regression.

Week 9: Macros and Automation

Tutorial: Introduction to Macros and VBA

  1. Understanding macros and Visual Basic for Applications (VBA).
  2. Recording and running simple macros.
  3. Editing and debugging macros in VBA Editor.
  4. Creating custom functions and procedures.

Week 10: Advanced Data Visualization with Power Query and Power Pivot

Tutorial: Power Query and Power Pivot

  1. Importing and transforming data using Power Query.
  2. Creating relationships and data models with Power Pivot.
  3. Building interactive dashboards and reports.
  4. Data analysis expressions (DAX) for advanced calculations.

Week 11: Collaboration and Sharing Workbooks

Tutorial: Collaborating in Excel

  1. Sharing workbooks and tracking changes.
  2. Co-authoring in Excel Online and SharePoint.
  3. Protecting workbooks and worksheets with passwords.
  4. Reviewing and commenting on shared workbooks.

Week 12: Final Project and Certification

Tutorial: Final Project and Review

  1. Applying Excel skills to a real-world project or case study.
  2. Presenting the project findings and analysis.
  3. Reviewing key concepts and skills covered in the course.
  4. Course evaluation and certification.

Assessment:

  • Weekly quizzes and assignments.
  • Participation in class activities and discussions.
  • Completion of a final project demonstrating proficiency in Excel skills.

FREE NOTES TO DOWNLOADS 

FREE ONLINE YOUTUBE VIDEO PLAYLIST WITH ALL VIDEO