MS Excel

Course Duration: 8-12 Weeks

Target Audience: Students, Professionals, Business Analysts, Data Analysts

Prerequisites: Basic Computer Knowledge

Module 1: Introduction to MS Excel

• Overview of MS Excel and its Uses
• Excel Interface: Ribbon, Toolbar, Worksheet, and Cells
• Creating, Opening, and Saving Excel Files
• Understanding Rows, Columns, and Cells
• Customizing the Excel Workspace

Module 2: Data Entry and Formatting

• Entering and Editing Data in Cells
• Formatting Cells (Number, Text, Date, Currency)
• Merging & Centering Cells
• Using the Format Painter
• Conditional Formatting
• Data Validation

Module 3: Basic Formulas and Functions

• Introduction to Formulas and Cell Referencing (Relative, Absolute)
• Basic Mathematical Operations (SUM, SUBTRACT, MULTIPLY, DIVIDE)
• Using AutoSum and Quick Functions
• Common Functions:
  • SUM, AVERAGE, COUNT, MAX, MIN
  • ROUND, CEILING, FLOOR, MOD

Module 4: Working with Text Functions

• Text Manipulation Functions:
  • CONCATENATE / TEXTJOIN
  • LEFT, RIGHT, MID
  • UPPER, LOWER, PROPER
  • LEN, TRIM, SUBSTITUTE, REPLACE

Module 5: Logical & Lookup Functions

• Logical Functions:
  • IF, IFERROR, IFS, AND, OR, NOT
• Lookup Functions:
  • VLOOKUP, HLOOKUP, XLOOKUP
  • INDEX and MATCH

Module 6: Data Sorting, Filtering, and Validation

• Sorting Data (Ascending, Descending, Custom Sorting)
• Applying Filters and Advanced Filters
• Creating Drop-Down Lists
• Removing Duplicates

Module 7: Pivot Tables and Charts

• Introduction to Pivot Tables
• Creating and Customizing Pivot Tables
• Applying Pivot Charts
• Creating and Customizing Charts (Bar, Pie, Line, Column, etc.)

Module 8: Advanced Excel Features

• Data Analysis using Goal Seek & Scenario Manager
• Conditional Formatting for Data Analysis
• Macros & Basic VBA Introduction
• Protecting Worksheets and Workbooks