NEICIT – 30 Days Online MS Excel Course Syllabus

Course Title: Master MS Excel – Get Job-Ready in 30 Days

Course Mode: 100% Online Course

Duration: 30 Days

Institute: NEICIT – National Education Institute & Computer Information Technology

Course Objectives

By the end of this course, students will be able to:

• Work confidently with Microsoft Excel.
• Create professional spreadsheets and reports.
• Use formulas and advanced functions.
• Manage office, business and financial data.
• Prepare MIS reports and dashboards.
• Perform data analysis using Excel tools.

30-Day Complete Course Curriculum

Week 1 – Excel Fundamentals

Day 1–7

01

Introduction to MS Excel, Interface & Workbook

02

Rows, Columns, Cells, Worksheets & Data Entry

03

Formatting Cells, Fonts, Borders & Alignment

04

Number Formatting, Date, Time & Currency

05

Copy, Paste, Cut, AutoFill & Flash Fill

06

Sorting, Filtering & Find/Replace

07

Basic Formulas, Operators & Weekly Practice

Week 2 – Formulas & Functions

Day 8–14

08

SUM, AVERAGE, MIN, MAX & COUNT

09

COUNTA, COUNTBLANK & COUNTIF

10

IF, AND, OR & Nested IF

11

SUMIF, SUMIFS & COUNTIFS

12

LEFT, RIGHT, MID, LEN & TRIM

13

CONCAT, TEXT, UPPER, LOWER & PROPER

14

VLOOKUP, HLOOKUP & Weekly Practice

Week 3 – Advanced Excel Tools

Day 15–21

15

XLOOKUP & INDEX-MATCH

16

Conditional Formatting

17

Data Validation & Drop-down Lists

18

Remove Duplicates, Text to Columns

19

Excel Tables & Structured References

20

Charts, Graphs & Data Visualization

21

Pivot Tables & Pivot Charts

Week 4 – Practical & Job-Oriented Excel

Day 22–30

22

Dashboard Creation

23

MIS Report Preparation

24

Salary Sheet & Payroll Management

25

Invoice, Billing & GST Calculation

26

Attendance & Employee Management

27

Inventory & Stock Management

28

Data Analysis & What-If Analysis

29

Final Practical Project & Revision

30

Final Examination & Course Assessment