Serving schools, colleges & students across India Sign inRegister freeFAQsHelpcontact@ghosla.io
GHOSLAGrowth Hub for Opportunities, Skills, Learning & AchievementGrow•Learn•Achieve Login Get Started

Solutions (For Institutions)

School ERPComplete school management College ERPComplete college management University ERPUniversity-wide management Coaching Classes ERPCoaching institute management

For Students

Ghosla AIAI-powered education & career assistant AI Career TestFind the careers that fit you Education LoansPlan, apply & track your loan Skills & CertificationsFree courses, Skill Score, certificates All 103 CoursesJob-ready courses, free right now Find Better SchoolsDiscover the right school for you Find Better CollegesDiscover the right college for you

Discover

Browse by City66 cities across India

Excel from Zero to Advanced

Go from your first cell to pivots, XLOOKUP, dynamic arrays and macros with Indian office examples

Ghosla Academy · Office Skills Team

Excel is the most requested office skill in Indian job listings, from data entry and accounts to MIS and sales support. This course starts from the very first cell and builds step by step to formulas, lookups, pivots, charts and simple automation. Every lesson uses relatable examples like marksheets, shop sales, GST invoices and monthly expenses, so you learn skills you can use on day one at work or in your own business.

What you will be able to do

  • Navigate Excel confidently and use time-saving shortcuts
  • Write formulas with relative, absolute and mixed references
  • Use IF, XLOOKUP, INDEX-MATCH, text and date functions
  • Clean, sort, filter and validate data in Excel Tables
  • Summarise data with pivot tables and clear charts
  • Use dynamic arrays, Goal Seek and simple macros

What you build

  • Student marksheet with grades and lookups
  • GST invoice and monthly expense tracker

What you need to start

  • A computer with Microsoft Excel (2016 or later) or free Excel for the web
  • No prior spreadsheet experience needed

Curriculum · 6 sections, 24 lectures

Getting started with Excel4 lectures
  1. Excel interface and workbook basicsFree preview8 min
  2. Entering data, AutoFill and shortcutsFree preview10 min
  3. Formatting cells and printing10 min
  4. Quiz: Excel basics5 min
Formulas and functions4 lectures
  1. Cell references: relative, absolute, mixed12 min
  2. Everyday functions: SUM, AVERAGE, ROUND, COUNT11 min
  3. IF, AND, OR and IFERROR12 min
  4. Quiz: formulas5 min
Lookup, text and dates4 lectures
  1. VLOOKUP, XLOOKUP and INDEX-MATCH14 min
  2. Text and date functions12 min
  3. Project: student marksheet with grades18 min
  4. Quiz: lookup, text and dates5 min
Working with data4 lectures
  1. Sorting, filtering and Excel Tables11 min
  2. Data validation and conditional formatting12 min
  3. Pivot tables for quick summaries14 min
  4. Quiz: data tools5 min
Charts and advanced formulas4 lectures
  1. Charts that tell a story12 min
  2. Dynamic arrays: FILTER, SORT, UNIQUE13 min
  3. What-if analysis: Goal Seek and PMT10 min
  4. Quiz: charts and advanced formulas5 min
Automation and office readiness4 lectures
  1. Recording a simple macro12 min
  2. Protecting and sharing workbooks8 min
  3. Project: GST invoice and monthly expense tracker20 min
  4. Quiz: final review6 min

Who this is for

  • Students and freshers preparing for office and data-entry jobs
  • Commerce and BBA students who need Excel for coursework
  • Small business owners and staff who manage bills and records