Bada Skills
Explore courses
Complete Advanced Excel Course course thumbnail
Excel & SheetsBeginner to AdvancedHindi + English

A Bada Skills course

Complete Advanced Excel Course

A complete, practical Excel course: from the basics to formulas, lookups, Pivot Tables, charts and dashboards. 38 video lessons in 7 sections.

₹799₹1,999Save 60%
Enroll nowSee curriculum

Secure payment on learn.badaskills.com, the official Bada Skills learning platform

What you'll learn

  • Work faster with tables, sorting, filters and conditional formatting
  • Use formulas with confidence: SUM, IF, COUNTIFS, SUMIFS and more
  • Find data with VLOOKUP, HLOOKUP and XLOOKUP
  • Clean text and dates: LEFT, MID, TRIM, TEXTJOIN, NETWORKDAYS
  • Summarise data with Pivot Tables
  • Build clear charts and a simple dashboard

Who this course is for

  • Students, freshers, MIS and data entry staff, and working professionals who use Excel every day.

Course content

7 sections38 videos

1Introduction6 videos
  1. Course overview
  2. Backstage view
  3. Interface tour
  4. Data entry & editing
  5. Rows, columns & cells
  6. Cell formatting
2Organizing & Managing Data6 videos
  1. Tables & lists
  2. Find, replace & remove duplicates
  3. Insert/delete/modify data
  4. Sorting & advanced filtering
  5. Intro to conditional formatting
  6. Rules & icon sets
3Mastering Excel Formulas10 videos
  1. Formula basics
  2. SUM/AVERAGE/MAX/MIN
  3. COUNT/COUNTA/COUNTBLANK
  4. LARGE & SMALL
  5. IF & nested IF
  6. IF with AND/OR
  7. COUNTIF
  8. COUNTIFS
  9. SUMIF
  10. SUMIFS
4Advanced Lookup & Text6 videos
  1. VLOOKUP
  2. HLOOKUP
  3. XLOOKUP
  4. LEFT/RIGHT/MID
  5. LEN/TRIM/UPPER/LOWER/PROPER
  6. CONCAT & TEXTJOIN
5Dates & Data Validation3 videos
  1. Date & time functions
  2. NETWORKDAYS & WORKDAY
  3. Data validation rules
6Pivot Tables1 video
  1. Create, analyze & summarize
7Charts & Dashboard6 videos
  1. Right chart
  2. Column
  3. Line
  4. Bar
  5. Pie
  6. Chart formatting & dashboard design

Tools

Microsoft Excel

Your trainer

Raj Singh

Raj Singh

Founder & CEO, Bada Skills · Microsoft Certified Trainer

19+ years of corporate training in AI, Excel, Microsoft Copilot, Power BI and Data Analytics. 500+ companies trained.

More about the trainer

FAQs

What language is the course in?

A mix of Hindi and English, just like a classroom session. All technical terms stay in English so you can use them at work.

Where do I get the course after payment?

Payment happens on learn.badaskills.com, the official Bada Skills learning platform. Once you pay, log in there with the same e-mail or mobile number and start the course right away, on mobile or laptop.

How long can I access it?

A course you buy has no expiry date on learn.badaskills.com.

Can I get a refund?

Our digital courses and books are non-refundable. If you face an access or technical problem, we fix it or offer another course or extra access instead. Please check the curriculum before you buy, and see the Refund & Cancellation Policy for details.

Related courses

Useful next steps after this course.

All courses
Complete Advanced Excel Course
₹799
Enroll now