?unique=460d67a)
Excel Course 2025 Basic to Advance (with Chat GPT & AI Tools)
"Master Excel, Boost Productivity, and Advance Your Career!"
₹ 2,500.00
2500.0
INR
₹ 2,500.00
| Responsible | Pavan Singh |
|---|---|
| Last Update | 05/06/2025 |
| Completion Time | 54 minutes |
| Members | 2 |
-
Introduction Of Course1Lessons ·
-
Free Preview
-
-
Day 1 Excel Intro, Tabs And Formatting1Lessons · 54 mins
-
Class 1 - Excel: Intro, Tabs, and Formatting
-
-
Day 2 Numbers, Conditional & Custom Formatting2Lessons ·
-
Class 1 Numbers, Conditional & Custom Foramtting
-
Class 2 Numbers Conditional & Costom Format
-
-
Day 3 Introduction to Formulas and Functions2Lessons ·
-
Class 1 Important Formula & Functions
-
Class 2 Cell References , Naming Range & If Function
-
-
Day 4 Sort Filter and Data Validation4Lessons ·
-
Class 1 Sort
-
Class 2 Filter
-
Class 3 Data Validation.
-
Class 4 List Validation
-
-
Day 5 Custom Format, Advance Use Of Table Format & Print Setup3Lessons ·
-
Class 1 Custom Format
-
Class 2 Advance Use Of Table Format
-
Class 3 Print Setup
-
-
Day 6 Types Of Charts , Chart Elements Advance Chart Format & Important Charts4Lessons ·
-
Class 1 Types Of Charts
-
Class 2 Chart Elements
-
Class 3 Advance Chart Format
-
Class 4 Important Charts
-
-
Day 7 Logical and Text Functions5Lessons ·
-
Class 1 IF , IFAND, IFOR
-
Class 2 Count , Counta , Countif, Countifs
-
Class 3 Sum ,Sumif , Sumifs , Ifs , Iferro
-
Class 4 Lower , Upper , Proper , Len, Left , Right
-
Class 5 Concet , Textjoin ,Trim , Rept , Large , Round
-
-
Day 8 Advanced Data Analysis Tools8Lessons ·
-
Class 1 Design A Impressive Pivot Table
-
Class 2 Pivot Formula Chars & Slicer
-
Class 3 Advance Options In Pivot Table
-
Class 4 Secenario1
-
Class 5 Secenario2
-
Class 6 Secenario3
-
Class 7 Power Pivot
-
Class 8 Pivot Dashboard
-
-
Day 9 Lookup and Reference Functions3Lessons ·
-
Class 1 Vlookup , Hlookup , Xlookup
-
Class 2 Multisheet Vlookup
-
Class 3 Index Match
-
-
Day 10 Working with Dates and Times2Lessons ·
-
Day 10 Class 1 Date Functions
-
Day 10 Class 2 Excel Time Saving Hacks
-
-
Day 11 Advanced Formula Techniques3Lessons ·
-
Day 11 Class 1 Dynamic Arrays
-
Day 11 Class 2 (A) Class 2 DGET
-
Day 11 Class 3 GroupBy Functions
-
-
Day 12 Data Cleaning and Transformation4Lessons ·
-
Day 12 Class 1 Data Cleaning Simple Tricks
-
Day 12 Class 2 10 Super Hack of Data Cleaning
-
Day 12 Class 3 Data Cleanup By Power Query Editor
-
Day 12 Class 4 Advance Data Clean Up
-
-
Day 13 Automation with Macros8Lessons ·
-
Day 13 Class 1 Start Macro With Format
-
Day 13 Class 2 (A) MultiSheet Macro Record
-
Day 13 Class 2 (B) Macro For MultiSheet
-
Day 13 Class 3 (A) Custom Functions Create with VBA
-
Day 13 Class 3 (B) Clear Data by VBA
-
Day 13 Class 4 Auto Invoice with VBA
-
Day 13 Class 5 (A) Create Data Entry Form
-
Day 13 Class 5 (B) Automate Data Entry Form
-
-
Day 14 Advanced Data Analysis Tools3Lessons ·
-
Day 14 Class 1 Goal Seek
-
Day 14 Class 2 What If Analysis
-
Day 14 Class 3 Scenario
-
-
Day 15 Building a Final Project , Chat GPT , AI Formula and Features6Lessons ·
-
Day 15 Class 1 Interactive Dynamic Sales Dashboard
-
Day 15 Class 2 Day 15 Class 1 Interactive Dynamic Financial Dashboard
-
Day 15 Class 3 How To Use Chat GPT In Excel
-
Day 15 Class 4 AI Formula's
-
Day 15 Class 5 Important Excel Add Ins
-
Day 15 Class 6 Best AI Features
-