Certificate Course
Microsoft Excel
Data & Spreadsheet Mastery
From formatting to lookups, dashboards, and analysis — the spreadsheet skills employers actually expect.
Level: Beginner to AdvancedMode: Instructor-ledOutcome: NIPSAR Certificate
Programme Fee
On Request
Guaranteed100%Placement
Support
Support
Why learn with NIPSAR
A credential built to get you hired
- 100%Placement Support
- 3-MonthPlacement Track
- CertifiedIndustry-Recognised
- Hands-OnLive Projects
Curriculum
What you will learn
A hands-on Excel programme that takes you from the fundamentals to lookups, conditional logic, and analysis-ready dashboards — with a real-world project and a recognised certificate.
01Unit 1: Formatting and Basic Operations+
- Selecting cells, rows, and columns
- Font formatting (size, color, bold, italic)
- Number formatting (date, currency, percentage)
- Alignment and borders
- Adjusting row height & column width
- Copy, Cut, Paste
- AutoFill
- Page setup & printing options
02Unit 2: Basic Formulas and Functions+
- Introduction to formulas
- Arithmetic operators (+ − × ÷)
- Cell references (Relative & Absolute)
- SUM
- AVERAGE
- COUNT
- MAX
- MIN
- AutoSum feature
03Unit 3: Logical & Lookup Functions+
- IF function
- Nested IF
- AND, OR functions
- VLOOKUP
- HLOOKUP
- Introduction to XLOOKUP
- IFERROR function
04Unit 4: Conditional Formatting & Data Validation+
- Highlight Cell Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- Custom rules using formulas
- Managing rules
- Data Validation
- Creating drop-down lists
- Removing duplicates
- Basic worksheet protection
05Unit 5: Pivot Table & Data Analysis+
- Introduction to Pivot Table
- Creating Pivot Table
- Adding Row, Column, Value fields
- Filtering Pivot Table
- Grouping data
- Refreshing Pivot Table
- Formatting Pivot Table
- Pivot Charts
- Real time scenario workbook creation
Ready to begin Microsoft Excel?
Enquire now and our academic team will share the curriculum, schedule, fees, and placement support.