Live Online · Bangalore-based trainer

Advanced Excel Training in Bangalore | Dashboards, PivotTables & MIS Reporting

20 hours of live, practical Excel training with a Bangalore-based instructor. Master PivotTables, VLOOKUP/XLOOKUP, dashboard design, Power Query, and MIS reporting — using real business datasets from day one.

PK

Pankaj Kumar Founder & Excel Trainer, Technovids

Live Training
20 hrsLive Training
Modules
11Modules
Student Rating
4.9/5Student Rating
Professionals Trained
500+Professionals Trained

Why Advanced Excel Skills Are Non-Negotiable in 2026

Despite the rise of BI tools like Power BI and Tableau, Excel remains the most-used business tool in India — relied on daily by finance, HR, operations, and sales teams. The gap between basic Excel users and professionals who can build dynamic dashboards and automate reports is directly visible in salary and career growth.

Faster reporting

Professionals with Advanced Excel skills complete the same reports 3× faster using PivotTables, formulas, and Power Query.

₹2–4L
Salary increment

Average salary improvement reported by professionals who upgraded from basic to advanced Excel after training.

90%
Jobs require it

Of analyst, MIS, finance, and operations job postings in India list Advanced Excel as a required or preferred skill.

At Technovids, every session is hands-on from minute one. You work on real business files — sales trackers, HR reports, financial models — guided by a trainer who has used Excel professionally for 10+ years. No slides-only lectures. No theory without practice.

Upcoming Batch Schedule

Small batches of max 15 students — enroll early to secure your seat

Weekend BatchFilling fast

Saturdays & Sundays · 10:00 AM – 12:30 PM

Starting June 7, 2026

Weekday Evening Batch

Tuesday & Thursday · 7:30 PM – 9:30 PM

Starting June 10, 2026

Weekend Batch

Saturdays & Sundays · 10:00 AM – 12:30 PM

Starting June 28, 2026

Enrolling nowReserve My Seat →
Corporate batch? We run private batches for teams of 5+, customised to your industry and schedule. Contact us for group pricing.

What You'll Be Able to Do

Practical, job-ready skills you'll apply from your very first day back at work.

Build Excel Dashboards

Design interactive, management-ready dashboards with slicers, dynamic charts, and KPI cards.

Master Lookup Functions

Use VLOOKUP, XLOOKUP, INDEX-MATCH confidently for complex multi-sheet reporting.

Create PivotTable Reports

Summarise and analyse large datasets with PivotTables, calculated fields, and slicers in minutes.

Automate with Power Query

Build refreshable data pipelines that clean and transform data automatically — no manual work.

Write Advanced Formulas

Combine SUMIFS, IFs, text, and date functions to create sophisticated business calculations.

Produce MIS Reports

Deliver professional monthly MIS reports that management can rely on — on time, every time.

The 20-Hour Curriculum

Eleven progressive modules, each ending with a hands-on project using real business data. Every session builds directly on the last.

Module 1 · 2 hrs

Excel Foundations for Professional Work

Topics Covered

  • Productivity shortcuts & interface mastery
  • Cell formatting and number formats
  • Absolute, relative & mixed references
  • Named ranges and Excel tables
  • Clean worksheet design principles
Practice project: Create a clean reporting sheet from raw business data
Module 2 · 2 hrs

Essential Formulas for Business Reporting

Topics Covered

  • IF, nested IF, AND, OR, NOT logic
  • SUMIF, SUMIFS, COUNTIF, COUNTIFS
  • AVERAGEIF and AVERAGEIFS
  • IFERROR and error handling
  • Basic KPI calculations
Practice project: Build monthly sales performance summary with conditional formulas
Module 3 · 2 hrs

Lookup Functions and Data Matching

Topics Covered

  • VLOOKUP, HLOOKUP, XLOOKUP mastery
  • INDEX and MATCH combinations
  • Multi-condition lookups
  • Common lookup errors and fixes
  • Best practices for lookup-heavy reports
Practice project: Create employee/product lookup report using multiple datasets
Module 4 · 2 hrs

Text, Date & Data Cleaning Functions

Topics Covered

  • LEFT, RIGHT, MID, LEN, TRIM, CLEAN
  • CONCAT and TEXTJOIN functions
  • DATE, MONTH, YEAR, EOMONTH calculations
  • Text to Columns and Flash Fill
  • Remove Duplicates and Data Validation
Practice project: Clean a raw customer database and prepare it for analysis
Module 5 · 1.5 hrs

Conditional Formatting & Data Validation

Topics Covered

  • Highlight rules and custom formats
  • Color scales, data bars, icon sets
  • Custom formula-based formatting
  • Dropdown lists and input restrictions
  • Error alerts and data quality control
Practice project: Create a tracker highlighting pending tasks and high-risk items
Module 6 · 3 hrs

PivotTables and PivotCharts

Topics Covered

  • Creating and structuring PivotTables
  • Grouping, filtering and value settings
  • Calculated fields in Pivots
  • PivotCharts, slicers and timelines
  • Refreshing and maintaining Pivot reports
Practice project: Build sales / HR / finance MIS report using PivotTables
Module 7 · 2 hrs

Charts and Visual Reporting

Topics Covered

  • Column, bar, line, pie, combo charts
  • Choosing the right chart type
  • Professional chart formatting
  • Trend analysis and KPI cards
  • Visual storytelling basics
Practice project: Create management-ready visual report from business dataset
Module 8 · 3 hrs

Dashboard Design and MIS Reporting

Topics Covered

  • Dashboard planning and KPI selection
  • Interactive filters and slicers
  • Dynamic charts and layouts
  • Monthly MIS dashboard structure
  • Dashboard quality checklist
Practice project: Build interactive Excel dashboard for business reporting
Module 9 · 1.5 hrs

What-If Analysis and Business Scenarios

Topics Covered

  • Goal Seek for target planning
  • Scenario Manager for comparisons
  • Data Tables for sensitivity analysis
  • Budget and pricing examples
  • Forecast-style calculations
Practice project: Create business planning model using scenarios
Module 10 · 2 hrs

Power Query Basics

Topics Covered

  • Importing and connecting data sources
  • Removing columns, splitting and merging
  • Changing data types and transforming data
  • Combining multiple files
  • Creating refreshable workflows
Practice project: Build refreshable data cleaning workflow using Power Query
Module 11 · 2 hrs

Final Project and Reporting Workflow

Topics Covered

  • Excel productivity shortcuts
  • Template planning and automation concepts
  • Common errors and how to avoid them
  • Report review checklist
  • Complete end-to-end project
Practice project: Build complete Excel report with formulas, Pivots, charts and dashboard

Who Should Join This Course

Designed for working professionals and job seekers who use — or need to use — Excel regularly.

MIS & Reporting Executives

Stop spending hours on manual reports. Build dashboards that update in seconds.

Finance & Accounts Professionals

Master the formulas and Pivot reports that finance teams rely on daily.

HR & Operations Analysts

Create HR trackers, headcount reports, and operational dashboards with confidence.

Business & Sales Analysts

Analyse sales data, track targets, and present insights to leadership professionally.

Fresh Graduates & Job Seekers

Add Advanced Excel and dashboard skills that employers specifically look for on CVs.

Managers & Team Leads

Read and create data-driven reports that improve decision-making at every level.

What Our Students Say

Real feedback from professionals who completed the course

The training was very practical. PivotTables and dashboard sessions helped me understand how to prepare reports faster. I can now create monthly MIS reports in half the time.

PS
Priya Sharma
MIS Executive, Tech Solutions Ltd
March 2026

The trainer explained formulas with real examples. I was able to use SUMIFS, lookup functions and charts in my office work immediately after the training.

AP
Amit Patel
Finance Analyst, Manufacturing Co
February 2026

Good course for MIS reporting. The practice files and assignments were useful for revision after class. Power Query saved me hours of manual work every week.

SR
Sneha Reddy
HR Operations, Corporate Services
January 2026

Everything Included in the Course

20 Hours of Live Training
11 modules with a live instructor — fully interactive, not pre-recorded.
Real Business Practice Files
Sales, HR, finance, and operations datasets for every module.
Session Recordings
All sessions recorded and available for revision throughout the course.
Assignments & Feedback
Module assignments reviewed by the trainer with individual feedback.
Max 15 Students per Batch
Small groups mean direct trainer attention and a better learning pace.
Industry-Recognised Certificate
Technovids Advanced Excel Certificate — shareable on LinkedIn.

Frequently Asked Questions

Is this course beginner-friendly?

You should be comfortable with basic Excel — creating sheets, entering data, using simple formulas like SUM and AVERAGE. If you know that, you are ready. We start from there and take you to an advanced level.

How is the training delivered?

Live instructor-led sessions over Zoom/Meet with screen sharing. Every session is interactive — you follow along on your own Excel, ask questions in real time, and complete exercises during class.

Will I get recordings?

Yes. All live sessions are recorded and shared with enrolled participants. You can revisit any topic at any time throughout the course duration.

What version of Excel is needed?

Excel 2016, 2019, 2021, or Microsoft 365. Most topics work across all versions. We highlight where features differ (e.g., XLOOKUP is Excel 365/2019+). A free trial of Microsoft 365 works fine.

How many students per batch?

Maximum 15 students per batch. Small batches ensure you get direct trainer attention, your questions are answered during class, and the pace suits the group.

Do I receive a certificate?

Yes. You receive a Technovids Advanced Excel Certificate after completing the course and the final project. The certificate is shareable on LinkedIn and is recognised by employers.

Are there practice files and assignments?

Yes. Every module comes with practice files based on real business scenarios — sales reports, HR trackers, financial models. Assignments are reviewed by the trainer.

Can my company sponsor a group batch?

Yes. We offer group enrolments and corporate batch pricing. Contact us to discuss a private batch for your team with content customised to your industry.

Enroll in the Next Batch

Seats fill fast. Share your details and we'll confirm your seat and send the full batch schedule within a few hours.

Weekend & weekday evening batches available
Live online — join from anywhere in India
Max 15 students — guaranteed trainer attention
Certificate included, shareable on LinkedIn
4.9/5
Student Rating
500+
Trained
20 hrs
Live Training

Reserve Your Seat

We'll confirm availability and send details within a few hours.

No spam. We'll contact you within one business day.

Chat with us