Course Content
Question-01: May I watch a demo class?
0/1
AI Driven Advanced Excel [Demo Class]
09:28
Chapter-1: Necessary Basic & Intermediate Topics
0/12
Data Entry
00:00
Mathematical Problem Solving
00:00
Some Important Function: Max, MIn, Count, Counta, Large, Small
00:00
Central Tendency
00:00
Data Filtering
00:00
Advanced Data Filtering
00:00
Data Sorting
00:00
Advanced Data Sorting
00:00
Table Creation
00:00
Magical Subtotal
00:00
Uses of Reference
00:00
Project: Table, Subtotal & Slicer (Copy 2)
Chapter-2: Advanced Formula & Function
0/13
IF Condition
00:00
If with and/or function
00:00
Nested if, Ifs
00:00
IF Error
00:00
Sumif
00:00
Countif
00:00
Averageif
00:00
Sumifs
00:00
Countifs
00:00
Averageifs
00:00
Maxifs
00:00
Minifs
00:00
Project: Using If related functions we shall complete a project. (Copy 2)
Chapter-3: Database Management Tricks & Functions
0/13
VLOOKUP
00:00
Difference Between Exact Match & Approximate Match
00:00
HLOOKUP
00:00
VLOOKUP with match function
00:00
XLOOKUP
00:00
INDEX
00:00
INDEX with Match Function
00:00
Lookup
00:00
Dget
00:00
Choose
00:00
Data Validation
00:00
Dependent Dropdown List
00:00
Using Lookup related functions we shall complete a project. (Copy 2)
Chapter-4: Advanced Data Analysis & Visualization
0/5
Data Presentation and Charts
00:00
Pivot Table: Big Data Analysis & Data Presentation
00:00
Advanced Dashboard Creation
00:00
Dynamic Report Generation
00:00
Using Pivot Table & other related functions, we shall complete a project. (Copy 2)
Chapter-5: MS Excel & ChatGPT
Chapter-6: Career Guideline & Hacks
Ai Driven Advanced Excel (Batch No-75)
    About Lesson

    This video offers a valuable insight into the mentor’s unique teaching style and expertise, enabling you to make the best choice for elevating your Microsoft Excel skills.

    Previous
    Next
    0% Complete