Certificate in MS Excel – Syllabus

Module 1: Introduction to Microsoft Excel

• Overview of MS Excel
• Excel interface and ribbon
• Creating, saving, and opening workbooks
• Understanding rows, columns, and cells

Module 2: Data Entry and Formatting

• Entering and editing data
• Cell formatting (font, color, alignment)
• Number, date, and currency formats
• Row and column adjustments
• Conditional formatting

Module 3: Formulas and Functions

• Basic formulas
• Mathematical functions (SUM, AVERAGE, MIN, MAX)
• Logical functions (IF, AND, OR)
• Text functions (LEFT, RIGHT, CONCATENATE, TRIM)
• Date and time functions

Module 4: Data Management

• Sorting and filtering data
• Data validation
• Removing duplicates
• Find and Replace
• Working with tables

Module 5: Charts and Graphs

• Creating charts
• Column, bar, line, and pie charts
• Chart formatting and customization
• Data visualization techniques

Module 6: Advanced Excel Features

• Absolute and relative cell references
• Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Pivot Tables and Pivot Charts
• Named ranges
• Worksheet protection

Module 7: Data Analysis and Reporting

• Subtotals and grouping
• What-If Analysis
• Basic statistical analysis
• Dashboard fundamentals
• Report generation

Module 8: Printing and Workbook Management

• Page setup and print options
• Headers and footers
• Managing multiple worksheets
• Sharing and collaboration features

Practical Assignments

• Sales and inventory reports
• Employee attendance sheet
• Budget planning worksheet
• Data analysis project using Pivot Tables and Charts

Course Outcome

Upon successful completion, learners will be able to:

• Create and manage spreadsheets efficiently.
• Use formulas and functions for calculations.
• Analyze and visualize data using charts and Pivot Tables.
• Generate professional reports and dashboards.
• Apply Excel skills in office, business, and academic environments.