Skip to content
SawariyaComputer Classes
Office & Productivity

Advanced Excel

This is the Excel course for people who want to use it seriously at work. Most of the time goes into building the sheets offices actually run on: invoices, GST bills, payment registers, marksheets and attendance, all calculating automatically.

Enquire About AdmissionAsk on WhatsApp
A laptop on a desk displaying charts and tables of business data
Duration
3 months
Level
Intermediate
Format
Classroom, 1 hour a day, any time 9 am – 9 pm
Fee
₹4,500Payable in 3 instalments

What you'll learn

  • Use VLOOKUP, HLOOKUP and XLOOKUP confidently
  • Combine IF, AND, OR and nested formulas
  • Build invoices and GST bills that calculate themselves
  • Make salary, payment and attendance sheets
  • Analyse data with pivot tables and what-if tools
  • Automate repeated work with macros

Course curriculum

  1. Module 01

    Formula depth

    • Nested IF, AND, OR
    • Absolute and relative references
    • Named ranges

  2. Module 02

    Lookups

    • VLOOKUP and HLOOKUP
    • XLOOKUP
    • INDEX and MATCH

  3. Module 03

    Data tools

    • Data validation and drop-downs
    • Conditional formatting
    • Removing duplicates

  4. Module 04

    Analysis

    • Pivot tables and pivot charts
    • What-if analysis
    • Goal seek

  5. Module 05

    Real sheets

    • Invoice and GST bill
    • Payment sheet
    • Marksheet
    • Attendance register
    • Automatic calculations

  6. Module 06

    Macros

    • Recording and editing macros
    • Buttons to run macros

Practical work

Every class includes time at the computer. Alongside daily exercises, you'll complete:

  • A GST invoice template with automatic tax and totals
  • A monthly attendance and salary sheet for a small team
  • A marksheet that calculates grades and ranks

Is this course for you?

Good fit for

  • Accounts and admin staff
  • Shop and business owners
  • Students heading into commerce or office jobs

Before you join

  • Comfort with basic Excel, or the Basic Excel course.

Where this course fits

Starting from scratch

  1. Basic Computer
  2. Basic Excel
  3. Advanced Excel

Office and accounts work

  1. Advanced Computer
  2. Advanced Excel
  3. Tally Prime + GST

Questions about this course

I know a little Excel. Can I join directly?

Yes, if you can already enter data and write simple formulas like SUM. We'll check where you are during your first class.

What is the fee, and can I pay in parts?

The full course fee is ₹4,500, which can be paid in 3 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 courses

Beginner

Basic Excel

Excel from the ground up: formulas, lookups, pivot tables and tidy, usable sheets.

Duration
2 months
Fee
₹3,500

View course

Beginner

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.

Enquire About AdmissionWhatsAppCall
CallWhatsAppEnquire