Intermediate
Advanced Excel
XLOOKUP, macros and real working sheets: invoices, GST bills, salary and attendance.
- Duration
- 3 months
- Fee
- ₹4,500
View course
Office & Productivity
Basic Excel
Excel is used in almost every office, shop and school. This course takes you from typing data into cells to building sheets that calculate things for you, with the formulas people actually use at work.
- Duration
- 2 months
- Level
- Beginner
- Format
- Classroom, 1 hour a day, any time 9 am – 9 pm
- Fee
- ₹3,500Payable in 2 instalments
What you'll learn
- Enter, format and organise data cleanly
- Use SUM, MIN, MAX, AVERAGE, COUNT and IF
- Look up values with VLOOKUP and HLOOKUP
- Summarise data with pivot tables
- Record simple macros to repeat tasks
Course curriculum
Module 01
Getting around
- Menus and ribbon
- Cells, ranges and sheets
- Formatting and printing
Module 02
Core formulas
- SUM, MIN, MAX, AVERAGE
- COUNT and COUNTIF
- IF conditions
Module 03
Lookups and text
- VLOOKUP and HLOOKUP
- Text functions
- Date functions
Module 04
Analysis
- Sorting and filtering
- Pivot tables
- What-if analysis
- Charts
Module 05
Automation
- Recording a macro
- Running and editing macros
Practical work
Every class includes time at the computer. Alongside daily exercises, you'll complete:
- A monthly sales summary with a pivot table
- A student result sheet with automatic grades
Is this course for you?
Good fit for
- Students
- Office staff
- Shop owners who keep records on paper today
Before you join
- Basic computer use (keyboard, mouse, saving files).
Where this course fits
Starting from scratch
- Basic Computer
- Basic Excel
- Advanced Excel
Questions about this course
What is the fee, and can I pay in parts?
The full course fee is ₹3,500, which can be paid in 2 instalments. We'll confirm the schedule with you at admission.
What are the batch timings?
Classes run from 9 am to 9 pm, every day of the week. Tell us whether morning, afternoon or evening suits you and we'll fit you into a batch at that time.
Will I get a certificate?
Yes. You'll receive a course completion certificate from Sawariya Computer Classes when you finish the course.
Other office & productivity courses
All coursesBeginner
AI Tools for Everyday Work
A hands-on introduction to using AI tools for writing, study, office work and design.
- Duration
- 3 months
- Fee
- ₹6,500
View course
Want to talk it over first?
Tell us what you already know and what you want to be able to do. We'll suggest where to start, explain the fees and timings, and show you the lab. No pressure to sign up.