Excel Course 2025 Basic to Advance (with Chat GPT & AI Tools)

0 %

Course content

Introduction Of Course
- EXCEL COURSE 2025 INTRO
Day 1 Excel Intro, Tabs And Formatting
- Class 1 - Excel: Intro, Tabs, and Formatting
Day 2 Numbers, Conditional & Custom Formatting
- Class 1 Numbers, Conditional & Custom Foramtting
- Class 2 Numbers Conditional & Costom Format
Day 3 Introduction to Formulas and Functions
- Class 1 Important Formula & Functions
- Class 2 Cell References , Naming Range & If Function
Day 4 Sort Filter and Data Validation
- Class 1 Sort
- Class 2 Filter
- Class 3 Data Validation.
- Class 4 List Validation
Day 5 Custom Format, Advance Use Of Table Format & Print Setup
- 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 Charts
- Class 1 Types Of Charts
- Class 2 Chart Elements
- Class 3 Advance Chart Format
- Class 4 Important Charts
Day 7 Logical and Text Functions
- 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 Tools
- 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 Functions
- Class 1 Vlookup , Hlookup , Xlookup
- Class 2 Multisheet Vlookup
- Class 3 Index Match
Day 10 Working with Dates and Times
- Day 10 Class 1 Date Functions
- Day 10 Class 2 Excel Time Saving Hacks
Day 11 Advanced Formula Techniques
- 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 Transformation
- 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 Macros
- 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 Tools
- 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 Features
- 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

Excel Course 2025 Basic to Advance (with Chat GPT & AI Tools)

Completed

EXCEL COURSE 2025 INTRO