Single-Topic Live Practitioner Sessions & On-Demand Classes
Hyper-focused, practical live workshops (e.g. Learn VLOOKUP today at 4:00 PM for ₹88) and purchasable recorded masterclasses delivered on Microsoft Teams and our high-definition replay workstation.
Live Today & In-Progress
Date Formulas for Office Work
Learn useful date formulas to calculate date differences, track deadlines and manage attendance or payment due dates.
Upcoming Live Sessions
Drop-Down Lists and Data Validation
Create drop-down menus and input rules to reduce data-entry mistakes in office forms, expense trackers and registers.
PivotTables for Office Reports
Learn to summarise business data using PivotTables. Analyse sales, expenses or orders by month, category and department, with a practical report.
Power Query Data Cleaning
Learn to import, clean and combine data using Power Query. Remove duplicates, transform columns and refresh your results when data changes.
Create a Simple Excel Dashboard
Build a simple Excel dashboard with summary figures, charts and filters to present business performance clearly. Includes a practical exercise.
Past Live Classes — Recorded On-Demand
Sort and Filter Office Data
Learn to sort records, apply filters and find specific information quickly. Practise organising customer lists, sales data and office registers.
Compare Two Excel Lists
Compare two Excel lists to identify missing items, duplicate entries and differences. Practise with supplier lists, product codes and office records.
VLOOKUP for Finding Records
Learn to find matching information in Excel tables using VLOOKUP. Practise finding product prices, employee details and invoice records.
COUNTIF and SUMIF for Reports
Learn to count records and calculate totals based on specific conditions. Practise preparing department summaries, sales totals and payment reports.
Conditional Formatting for Office Work
Highlight overdue tasks, pending payments, duplicate values and low stock automatically using Excel conditional formatting rules.