Basic to Advance Excel Course with AI Tools
5000/ 1499/-
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 Introduction1Lessons · 16 mins
-
Preview
-
-
Day 1: Introduction to Excel1Lessons · 54 mins
-
Preview
-
-
Day 2: Basic Data Entry and Formatting2Lessons · 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 Functions2Lessons · 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 Data4Lessons · 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 Printing3Lessons · 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 Visualization4Lessons · 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 Functions5Lessons · 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 Tools7Lessons · 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 Functions3Lessons · 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 Times2Lessons · 50 mins
-
Day 10 Class 1 Date Fuctions.mp4
-
Day 10 Class 2 Excel Time Saving Hacks.mp4
-
-
Day 11: Advanced Formula Techniques4Lessons · 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 Transformation4Lessons · 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 Macros8Lessons · 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 Analysis3Lessons · 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 Project6Lessons · 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
-