Microsoft Excel:Beginner to Advanced in animation 2025 + AI
All LevelsOffice ProductivityExcel

Microsoft Excel:Beginner to Advanced in animation 2025 + AI

Most updated 2024 with A-Z in Excel to make you advanced excel pro with Pivot Tables, Excel Dashboards, Advanced Excel

Created by Kadhiravan Jayachandiran
14 hours
Video Content
268
Lectures
46,712
Students
4.6
Rating
4.6
(46,712 students enrolled)

What you'll learn

Become Confident at Microsoft Excel with over 100+ Business Situations
Vlookup, Xlookup, Excel Pivot Tables
Advanced Excel Formulas with ChatGPT
Learn Advanced Formulas like SUMIFS and WILD CARDS
Advanced Excel Formulas and their various business Situations
Start applying Advanced Excel in real world situations
Excel Dashboarding and how to effectively create data visualizations

Course Content

30 sections • 268 lectures • 13:50:53 total length

Introduction

3 lectures • 05:24

Course Structure03:10
Practice file Instructions01:10
Course Introduction01:04

Fundamentals of Excel

3 lectures • 08:44

Practice files and some Instructions00:29
Introduction to Excel Environment05:04
Microsoft Excel 101 - All about the Fundamentals of Excel03:11

Flash Fill - A data Cleaning and Processing Feature

13 lectures • 27:02

Practice File for Flash Fill00:02
Introduction to Flash Fill - Magical Feature of Excel00:53
FlashFill for Joining Data in Excel01:54
FlashFill to Split Data00:53
FlashFill for Dates Extraction and Manipulation00:57
+8 more lectures

Additional Data Management Tools

5 lectures • 15:22

Practice file for additional Data Management tools00:01
Remove Duplicates - Single Column and Multiple Columns02:29
Text To Columns - Fixed Width05:40
Text To Columns - Delimited04:22
Text To Columns - Where would it fail02:50

Data Validation - A Data Collection and Data Quality Management Tool - Basics

16 lectures • 36:19

Practice File for Data Validation00:01
Introduction to Data Validation02:21
How Data Validation works01:30
Validating an input with certain number of characters03:56
Replicating Data Validation to Other Rows00:58
+11 more lectures

Absolute Fundamentals of Excel

13 lectures • 36:24

Practice file for Fundamentals00:02
Sheets Management in Excel05:20
Managing Column Width and Row Height04:59
Basic Formatting options06:17
Copy and Paste01:58
+8 more lectures

Filtering and Sorting - A Data Interpretation Tool

15 lectures • 24:26

Practice File for this Section00:01
Introduction to Filtering02:54
Applying Filter for the First Time02:41
Filtering Data On Misaligned Dataset01:48
Filtering Data on a Text based Information00:59
+10 more lectures

Additional Filtering tools - Advanced Filter

4 lectures • 10:57

Practice file download for Advanced Filtering00:01
Advanced Filter feature03:34
Advanced Filter on Multiple criteria03:44
Advanced Filter for Copying Data to another range03:38

Excel Pivot Tables - A Data Analysis Tool

28 lectures • 01:02:25

Practice file for Pivot Tables00:02
The Business Story Continuation00:53
Pivot Tables Introduction03:09
Pivot Table Interface and our First Pivot Table02:46
How Pivot Table Works02:35
+23 more lectures

Visualizing Data with Conditional Formatting - Basics

17 lectures • 35:01

Practice File for Conditional Formatting00:05
Challenges of Understanding Summarized Data01:26
How Effective is Conditional Formatting01:24
Understanding Data Bars and How it works02:11
Using Data Bars on Same Filed and Adjacent Field02:16
+12 more lectures

Printing and Layouts

5 lectures • 17:42

Print a Sheet and Managing the Output Options03:16
Printing a specific area or specific region02:28
Using Print Area and Page Breaks together04:30
Fitting all columns for Printing and Printing Titles03:34
Printing a fully made Report for consumption03:54

Excel Formulas and Functions 101

4 lectures • 12:10

Why Use Functions or Formulas and its Fundamentals02:46
Excel Formula Vs Excel Function02:14
Environment and Inserting our First Excel Formula04:19
Inserting our First Function02:51

Excel Formulas: Basic functions but frequently used

13 lectures • 24:19

Basic Functions Practice File with Questions00:01
How SUM Function works02:46
Practicing SUM Function01:59
How AVERAGE works - Excel Formulas01:23
Practicing AVERAGE Excel Formulas01:24
+9 more lectures

Some more concepts of Excel Formulas and Functions

3 lectures • 09:41

How Referencing works in Excel Formulas03:21
How Fixed or Absolute Referencing works in Excel Formulas02:28
Named Ranges in Excel Formulas03:52

Excel Formulas : Solving Business Questions with Logical Formulas

5 lectures • 10:43

Question Practice File for Operators00:05
IF Formula - Excel Formulas07:08
AND Formula or Operator - Excel Formulas01:25
OR Formula or Operator - Excel Formulas02:01
Quiz for Logical Excel Formulas2 questions
+1 more lectures

Advanced Excel Formulas : Wild Cards and IF Family of Formulas

10 lectures • 01:06:36

Downloadable Practice File00:05
Using SumIF and Calculating a Metric - Excel Formulas07:09
SumIF with Wild Cards in Excel Formulas09:30
AverageIF and CountIF Formulas along with the Wildcard situations09:49
IFS Formula and SumIFS Formulas10:09
+6 more lectures

Excel Formulas: TEXT Formulas

4 lectures • 23:08

Practice File for Text Excel Formulas00:02
Trio of LEFT, RIGHT and MID - Excel Formulas09:57
UPPER, LOWER and PROPER - Excel Formulas05:03
Combining data with CONCAT and TEXTJOIN Excel Formulas08:06

Basic Excel Formulas : Data and Time Formulas

10 lectures • 11:31

Practice file for download with Questions00:01
Creating dynamic current date with TODAY - Excel Formulas01:06
Extracting only the DAY information from a date - Excel formulas01:08
Extracting only the MONTH information from a date - Excel formulas00:44
Extracting only the YEAR information from a date - Excel formulas00:37
+5 more lectures

Excel Formulas: Vookup, XLookup and other lookup formulas

20 lectures • 47:54

VLOOKUP Practice Files00:01
Introduction to VLOOKUP - Excel Formulas01:30
How VLookup Works04:09
Vlookup in Simple Business Situation 1 - Text Clue05:59
Vlookup in Simple Business Situation 2 - Text Clue02:10
+15 more lectures

Advanced Excel Formulas: Nested Formulas and ChatGPT

8 lectures • 19:57

Practice file for download - Questions00:02
Introduction to Nested formulas - Excel Formulas02:07
Creating our First Nested formula - Excel Formulas02:51
Reversing the Logic within a Nested formula - Excel Formulas01:37
Building Complex Nested Formulas in a Step by Step Approach03:39
+3 more lectures

Advanced Text Formulas

8 lectures • 14:46

Practice File Download00:01
Extracting Numbers using TEXT formula02:14
Extracting Month info using TEXT Formula01:51
Extracting AM or PM from timestamp using TEXT formula01:08
Some more situations of using TEXT Formula01:44
+3 more lectures

Rounding Excel Formulas

6 lectures • 10:17

Practice File Download00:01
Rounding the Decimal Values using ROUND formula02:10
Rounding up the decimal values using ROUNDUP formula02:00
Rounding down the decimal values using ROUNDDOWN formula01:04
Rounding the values with a Multiplier using MROUND formula02:51
+1 more lectures

Advanced Statistics Formulas

4 lectures • 03:55

Practice File for this section00:02
Large Formula to find the Second highest Value and Fourth highest value01:38
Small formula to find the third lowest value and Lowest value00:45
Rank Formula to Rank the sales data01:30

Charts and Visualization

15 lectures • 01:01:33

Why Charts are needed ?02:22
Comparison Charts - Clustered 2D column06:17
Comparison Charts - Stacked 2D column04:19
Comparison Charts - 100% Stacked 2D Column05:30
Comparison Charts - Clustered 2D Bar04:03
+10 more lectures

Dashboarding with Pivot Tables

9 lectures • 01:01:17

Dashboarding Project File for Download00:01
Importance of Dashboard06:05
Creating and Managing Business Questions for Dashboarding06:18
Setting up the Environment for Dashboarding06:03
Generating Business Answers and Questions for Dashboarding10:00
+4 more lectures

Interactive Dashboarding

3 lectures • 25:09

Slicers and Timelines for Interactive Dashboard08:40
Coloring and Theming your Dashboards07:52
Final Touches before Publishing your Dashboard08:37

Advanced Customizations and Data Summarization of Dashboards

8 lectures • 57:36

Managing Blanks and Views06:24
Grouping in Pivot Tables06:56
Contextual Charting06:06
Aligning Complex Chart and Customizing Slicers06:17
Customizing Everything and Hidden Chart Options11:45
+3 more lectures

Creative Dashboard

6 lectures • 43:46

Orders management Dashboard05:51
Creating Answers for the Business Questions05:23
Removing distractions and adding missing objects08:02
Customising the KPIs07:26
Custom complex charts05:56
+1 more lectures

Advanced use cases of AI using ChatGPT

9 lectures • 45:30

Practice files for AI00:01
Counting Words of sentences04:50
Creating a Project Deadline Alert04:36
Profit Margin Calculation03:11
Creating a flag for Employee Attendance and Tracking with ChatGPT07:47
+4 more lectures

Conclusion

1 lectures • 01:11

Course Conclusion01:11

Description

Welcome to our Updated Excel Mastery Course with ChatGPT, where we've enhanced our offerings to cater to beginners and advanced users alike. In addition to the comprehensive Excel content previously mentioned, we are excited to introduce new features to elevate your Excel skills even further, with a special emphasis on AI-driven learning for Excel Formulas.


This covers the below features and formulas for you to learn:

  1. 300+ business situations

  2. Excel Fundamentals

  3. FlashFill

  4. Data Validation

  5. Text-To-Columns

  6. Duplicates Remover

  7. Advanced and custom Fill

  8. Advanced Filtering and Sorting

  9. Grouping and ungrouping

  10. Printing and layouts Management

  11. Pivot Tables

  12. Advanced Pivot Tables

  13. Conditional Formatting

  14. Excel Basic Functions

  15. Text Function

  16. Logical Functions

  17. Wild Cards in Excel formulas and functions

  18. Logical Aggregation Functions

  19. Advanced IF and IFS functions

  20. Vlookup and Hlookup

  21. Xlookup

  22. Match and Index

  23. Rounding functions

  24. Advanced Statistics Functions

  25. Advanced Calculations

  26. Basic and Advanced Date and Time Functions

  27. Nested Formulas

  28. Charts and Visualisations

  29. Dashboard Creation and Analysis

  30. AI use cases for all the topics covered

  31. Data Source management



New Features:


  1. AI-Driven Learning for Excel Formulas:

    • Dive into the future of Excel learning with our cutting-edge AI-driven modules. Leverage artificial intelligence to enhance your understanding of complex formulas, receive personalised insights, and optimise your Excel workflow. Uncover the power of AI as a companion in your data analysis journey.

  2. How to Use ChatGPT for Excel Complex Situations:

    • Unlock the full potential of ChatGPT to navigate intricate Excel scenarios. Learn how to seamlessly integrate AI assistance for problem-solving, formula optimisation, and gaining insights into unique challenges you may encounter in your data analysis journey.

  3. Expanded Excel Formulas Module:

    • Delve deeper into Excel formulas with an additional 20 formulas covering a wide range of situations. From financial calculations to statistical analysis, these formulas will empower you to handle diverse data scenarios with confidence.

  4. Extended Excel Pivot Tables Section:

    • Elevate your data analysis game with an extended section on Excel Pivot Tables, covering 15 different situations. Master the art of summarizing and analyzing large datasets with ease.

  5. Enhanced Excel Dashboard:

    • Explore the integration of AI in dashboard creation. Learn how to use AI to identify patterns, trends, and outliers in your data, enabling you to design more insightful and dynamic dashboards.

  6. Advanced Charting Techniques:

    • Take your data visualisation skills to the next level with advanced charting techniques. Learn to create visually stunning and informative charts that effectively communicate your data insights.

  7. More Practice Sheets:

    • Sharpen your skills with over 30 additional practice sheets, providing hands-on experience and reinforcing the concepts learned throughout the course.

As we step into 2024, Excel proficiency coupled with AI-driven insights is the key to staying ahead in the world of data analysis. Join us in this advanced learning experience, and let's explore the future of Excel together.

- Kadhiravan

Who this course is for:

  • Beginners of Excel
  • Data Professionals
  • HR Professionals
  • Professionals using Excel everyday at work
  • Project Managers
  • Program Managers
  • Analyst
  • Business Analyst

This course includes:

  • 14 hours on-demand video
  • 33 articles
  • 39 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructor

Kadhiravan Jayachandiran

Students also download

Explore related courses to expand your learning journey.