Skip to content
Data & Analytics

ExcelBasic to Advanced

Go from spreadsheets to smart analysis — formulas, lookups, pivot tables, dashboards and automation.

View Curriculum

Course overview

Excel remains the most widely used business tool in the world. Strong Excel skills make you faster and more valuable in almost any role.

This course covers essential and advanced formulas, lookups, pivot tables, charts, data cleaning with Power Query and building interactive dashboards.

Who is this course for?

  • Students entering business, finance or analytics roles
  • Working professionals who use spreadsheets daily
  • Anyone preparing for a data analytics path

Prerequisites

  • Basic computer usage

What you will learn

  • Apply logical, text and date functions
  • Look up data with XLOOKUP and INDEX-MATCH
  • Analyse data with pivot tables
  • Build charts and interactive dashboards
  • Clean and combine data with Power Query
  • Run what-if analysis

Module structure

  1. 01Excel Essentials
    • Navigation and formatting
    • Basic formulas
    • Sorting and filtering
  2. 02Functions
    • Logical and text functions
    • Date functions
    • XLOOKUP / VLOOKUP / INDEX-MATCH
  3. 03Data Analysis
    • Pivot tables
    • Conditional formatting
    • Data validation
  4. 04Visualisation
    • Charts
    • Slicers
    • Interactive dashboards
  5. 05Data Preparation
    • Power Query basics
    • Cleaning messy data
    • Combining data sources
  6. 06Productivity
    • What-if analysis
    • Intro to macros
    • Case-study dashboard

Module sequence and depth may be tailored to the batch level. Detailed syllabus available on enquiry.

Hands-on learning

  • Business case-study workbooks
  • Data-cleaning exercises
  • Interactive dashboard build

Tools & technologies

  • Microsoft Excel
  • Power Query

Learning outcomes

  • 01

    Use advanced formulas and lookups

  • 02

    Summarise data with pivot tables

  • 03

    Build clear, interactive dashboards

  • 04

    Clean and prepare data efficiently

Duration, mode, batches & certificate

Duration

Shared on enquiry

Current batch schedule shared on enquiry.

Training mode

Online / Offline / Hybrid

Availability varies by batch.

Batches

Weekday & Weekend

Choose weekday or weekend (Sat & Sun) classes.

Certificate

Completion certificate

Issued on completing programme requirements.

FAQ

Excel — FAQs

What is the batch size for Excel?

Batches are kept small, so each learner gets focused guidance and time for questions.

Will I receive a certificate?

Yes. Learners who complete the programme requirements receive a verifiable course completion certificate from Sarng Infotech.

What is the duration and fee?

Batch schedules and fees are shared on enquiry, as they depend on the mode and batch you choose. Send us an enquiry and our team will share the current details.

Explore more courses

Ready to start Excel?

Small batches. Better learning. Talk to us about the next batch.

Explore Courses