Skip to Content
Private Course
Please sign in to contact responsible
Responsible Pavan Singh
Last Update 18/01/2026
Completion Time 20 hours 20 minutes
Members 11
  • Excel Course 2026 with AI Tools Introduction
    1Lessons · 16 mins
  • Day 1: Introduction to Excel
    1Lessons · 54 mins
  • Day 2: Basic Data Entry and Formatting
    2Lessons · 1 hr 7 mins
    • Day 2 Class 1 Numbers, Conditional & Custom Foramtting.mp4
    • Day 2 Class 2 Numbers Conditional & Costom Format.mp4
  • Day 3: Introduction to Formulas and Functions
    2Lessons · 1 hr 30 mins
    • Day 3 Class 1 Important Formula & Functions.mp4
    • Day 3 Class 2 Cell References , Naming Range & If Function.mp4
  • Day 4: Working with Data
    4Lessons · 1 hr 5 mins
    • Day 4 Class 1 Sort and Filter.mp4
    • Day 4 Class 2 Filter.mp4
    • Day 4 Class 3 Data Validation.mp4
    • Day 4 Class 4 List Validation.mp4
  • Day 5: Formatting and Printing
    3Lessons · 1 hr 7 mins
    • Day 5 Class 1 Costom Format.mp4
    • Day 5 Class 2 Advance Use Of Table Format.mp4
    • Day 5 Class 3 Print Setup.mp4
  • Day 6: Charts and Visualization
    4Lessons · 1 hr 37 mins
    • Day 6 Class 1 Types Of Charts.mp4
    • Day 6 Class 2 Chart Elements.mp4
    • Day 6 Class 3 Advance Chart Format.mp4
    • Day 6 Class 4 Important Charts.mp4
  • Day 7: Logical and Text Functions
    5Lessons · 1 hr 21 mins
    • Day 7 Class 1 If , Ifand, Ifor.mp4
    • Day 7 Class 2 Count ,Counta ,Countif,Countifs.mp4
    • Day 7 Class 3 Sum ,Sumif , Sumifs , Ifs , Iferro.mp4
    • Day 7 Class 4 Lower , Upper , Proper,Len,Left ,Right.mp4
    • Day 7 Class 5 Concet , Textjoin,Trim , Rept , Large Round.mp4
  • Day 8: Advanced Data Analysis Tools
    7Lessons · 1 hr 46 mins
    • Day 8 Class 1 Design A Impressive Pivot Table.mp4
    • Day 8 Class 2 Pivot Formula Chars & Slicer.mp4
    • Day 8 Class 3 Advance Options In Pivot Table.mp4
    • Day 8 Class 4 Secenario 1.mp4
    • Day 8 Class 5 Secenario 2.mp4
    • Day 8 Class 6 Secenario 3.mp4
    • Day 8 Class 7 Power Pivot.mp4
  • Day 9: Lookup and Reference Functions
    3Lessons · 54 mins
    • Day 9 Class 1 Vlookup , Hlookup , Xlookup.mp4
    • Day 9 Class 2 Multisheet Vlookup.mp4
    • Day 9 Class 3 Index Match.mp4
  • Day 10: Working with Dates and Times
    2Lessons · 50 mins
    • Day 10 Class 1 Date Fuctions.mp4
    • Day 10 Class 2 Excel Time Saving Hacks.mp4
  • Day 11: Advanced Formula Techniques
    4Lessons · 1 hr
    • Day 11Class 1 Dynamic Arrays.mp4
    • Day 11 Class 2 (A) Class 2 Dget.mp4
    • Day 11 Class 2 (B) Class 2 Dget.mp4
    • Day 11 Class 3 Groupby Functions.mp4
  • Day 12: Data Cleaning and Transformation
    4Lessons · 1 hr 11 mins
    • Day 12 Class 1 Data Cleaning Simple Tricks.mp4
    • Day 12 Class 2 10 Super Hack of Data Cleaning.mp4
    • Day 12 Class 3 Data Cleanup By Power Query Editor.mp4
    • Day 12 Class 4 Advance Data Clean Up.mp4
  • Day 13: Automation with Macros
    8Lessons · 1 hr 31 mins
    • Day 13 Class 1 Start Macro With Format.mp4
    • Day 13 Class 2 (A) Multisheet Mecro Record.mp4
    • Day 13 Class 2 (B) Macro For Multisheet.mp4
    • Day 13 Class 3 (A) Custom Functions Create with VBA.mp4
    • Day 13 Class 3 (B) Clear Data by VBA.mp4
    • Day 13 Class 4 Auto Invoice with VBA.mp4
    • Day 13 Class 5 (A) Automate Data Entry Form.mp4
    • Day 13 Class 5 (B) Automate Data Entry Form.mp4
  • Day 14: Advanced Data Analysis
    3Lessons · 1 hr 3 mins
    • Day 14 Class 1 Goal Seek.mp4
    • Day 14 Class 2 What If Analysis.mp4
    • Day 14 Class 3 Scenario.mp4
  • Day 15: Building a Final Project
    6Lessons · 3 hrs 8 mins
    • Day 15 Class 1 Interactive Dynamic Sales Deshboard.mp4
    • Day 15 Class 2 Day 15 Class 1 Interactive Dynamic Finacial Dashboard.mp4
    • Day 15 Class 3 How To Use Chat GPT In Excel.mp4
    • Day 15 Class 4 AI Formula's.mp4
    • Day 15 Class 5 Important Excel Add Ins.mp4
    • Day 15 Class 6 Best AI Features.mp4