Complete course on Microsoft Excel

Why should you enroll in this course?

Course overview

20 sections • 190 topics • 11 hrs 43 mins

1. Introduction

9 mins

Introduction to Excel environment

Start Learning

Introduction to the course

Start Learning

Spreadsheets: features and functions

Start Learning

2. AI use Cases

9 mins

Counting of words in Excel using AI

Start Learning

How to get project alert deadline using AI

Start Learning

3. Fundamentals of Excel

21 mins

Autofitting rows and height - word wrap

Start Learning

Freeze and unfreeze

Start Learning

Fundamental formatting in Excel

Start Learning

Managing Excel sheet

Start Learning

4. Flash Fill

28 mins

Introduction to Flash Fill

Start Learning

Flash Fill for joining data in Excel

Start Learning

Flash Fill to split data

Start Learning

Flash Fill for dates extraction

Start Learning

Flash Fill for formatting of values

Start Learning

Flash Fill for complex data

Start Learning

Flash Fill for creation and extraction

Start Learning

Where would Flash Fill fail

Start Learning

Flash Fill assignment - questions

Start Learning

Flash Fill assignment - solution

Start Learning

What have we learnt so far

Start Learning

5. Additional Data Management Feature

2 mins

How to remove duplicates

Start Learning

6. Data Validation

39 mins

Introduction to Data Validation

Start Learning

How Data Validation works

Start Learning

Validating an input with certain number of characters

Start Learning

Replicating Data Validation to Other Rows

Start Learning

Validating an Input of Date values using Data Validation

Start Learning

Enabling Input Message and Error Alert for Data Validation Cells

Start Learning

Data Validation for Time Information

Start Learning

Custom List of Items in Data Validation

Start Learning

Data Validation Assignment Question

Start Learning

Data Validation Assignment Solution

Start Learning

Learning so Far

Start Learning

AI Lesson 1 - Allowing a complex student ID using data validation and chatGPT

Start Learning

AI Lesson 2 - Allowing only current date using Data Validation and ChatGPT

Start Learning

AI Lesson 3 - Validating an Email address using ChatGPT

Start Learning

7. Filtering and Sorting

27 mins

Introduction to Filtering

Start Learning

Applying Filter for the First Time

Start Learning

Filtering Data On Misaligned Dataset

Start Learning

Filtering Data on a Text based Information

Start Learning

Filtering Date information with 1 criteria

Start Learning

Filtering Date information with 2 criteria

Start Learning

Filtering Time information with Multiple Criteria

Start Learning

Filtering Data on Multiple Fields

Start Learning

Introduction to Sorting

Start Learning

Sorting Date Information

Start Learning

Filtering and Sorting Dates

Start Learning

Advanced Sorting Along with Filtering

Start Learning

Learning So Far in this Course

Start Learning

8. Pivot Table

1 hr

Story of the Business – Continuation

Start Learning

Pivot Tables Introduction

Start Learning

Pivot Table Interface and our First Pivot Table

Start Learning

How Pivot Table Works

Start Learning

First Pivot Table with a Calculation

Start Learning

Different Calculations from the Same Field

Start Learning

Using Rows and Columns in Pivot Tables for the Same Field

Start Learning

Using Rows and Columns for 2 different fields

Start Learning

Managing Lables of a Complex Pivot Table

Start Learning

Sorting Values in Pivot Table

Start Learning

Label Filtering in Pivot Tables

Start Learning

Values Filtering in Pivot Tables

Start Learning

Report Level Filters in Pivot Tabels

Start Learning

Formatting Values in Pivot Table

Start Learning

Managing Date Information in Pivot Tables

Start Learning

Multi Field Calculations in Pivot Tables

Start Learning

Top 3 and Bottom 3 in Pivot Tables

Start Learning

Changes in the Data Source

Start Learning

Adding New Rows of Data to the Pivot Table - Manual Method

Start Learning

Column Referencing and the Challenges of Blanks

Start Learning

Range Vs Table Source for Pivot Tables

Start Learning

Grouping Data in Pivots

Start Learning

Using Slicers to Filter Reports

Start Learning

Using Timelines to Filter Reports

Start Learning

Our Learning So Far

Start Learning

Pivot Tables Assignment Question

Start Learning

Pivot Tables Assignment Answer

Start Learning

9. Interpreting Data with Conditional Formatting

30 mins

Challenges of Understanding Summarized Data

Start Learning

How Effective is Conditional Formatting

Start Learning

Understanding Data Bars and How it works

Start Learning

Using Data Bars on Same Filed and Adjacent Field

Start Learning

Customizing Data Bars

Start Learning

Introduction to Color Scales

Start Learning

Applying Color Scales on Pivot Table Report

Start Learning

Customizing Color Scales

Start Learning

Introduction to Icon Sets

Start Learning

Applying Icon Sets on a Report and Customizing Criteria

Start Learning

Customizing the Icon Sets

Start Learning

Duplicates Highlight and Where Conditional Formatting Fails

Start Learning

Conditional Formatting Assignment Walk

Start Learning

Learnt so far

Start Learning

10. Functions and Formulas

12 mins

Inserting our First Function

Start Learning

Environment and Inserting our First Formula

Start Learning

Why Use Functions or Formulas and its Fundamentals

Start Learning

Formula Vs Function

Start Learning

11. Excel Basic Functions

26 mins

How SUM Function works

Start Learning

Practicing SUM Function

Start Learning

How AVERAGE function works

Start Learning

Practicing AVERAGE function

Start Learning

How COUNT and COUNTA function works

Start Learning

Count Function and Counting Capabilities

Start Learning

COUNTA and its Counting Capabilities and Limitations

Start Learning

How MAX and MIN function works

Start Learning

MAX and MIN Practice

Start Learning

Excel Basic Functions Assignment Questions

Start Learning

Excel Basic Functions Assignment Solution

Start Learning

12. Referencing in Formulas

10 mins

Named Ranges

Start Learning

Formula Referencing - Fixed Referencing

Start Learning

Formula Referencing - Relative Referencing

Start Learning

13. Excel Formulas: Basic functions but frequently used

57 mins

MinIFS

Start Learning

SumIFS with Wildcards

Start Learning

AverageIFS and Average IFS with Wild Cards

Start Learning

MaxIFS

Start Learning

Average IF and CountIF Formulas

Start Learning

IFS and SUMIFS

Start Learning

Sum IF

Start Learning

14. Date Formulae

13 mins

Today

Start Learning

Day

Start Learning

Month

Start Learning

Year

Start Learning

Time Functions

Start Learning

Days

Start Learning

Networkdays

Start Learning

Networkdays International

Start Learning

15. VLookup and XLookup

55 mins

Vlookup - 2 - Formula Explainer

Start Learning

Vlookup - 3 - Business Situation 1

Start Learning

Vlookup - 4 - Business Situation 2

Start Learning

Vlookup - 5 - Business Situation 3

Start Learning

Vlookup - 6 - Business Situation 4

Start Learning

Vlookup - 7 - Business Situation 5

Start Learning

Vlookup - 8 - Business Situation 6

Start Learning

VLookup business situation 7

Start Learning

XLOOKUP() on Simple Data

Start Learning

XLOOKUP() on Multiple Files of reference

Start Learning

XLOOKUP() on Date and Horizontal Data

Start Learning

XLOOKUP() with Match mode of Higher Value

Start Learning

XLOOKUP() with Match mode of Lower Value

Start Learning

XLOOKUP() with Match mode of Wildcard Characters

Start Learning

Introduction to Match Formula

Start Learning

Introduction to Index Formula

Start Learning

Index and Match Formulas Together

Start Learning

16. Nested Formulas and Using ChatGPT to build formulas

21 mins

Building a complex Nested IF formula with ChatGPT

Start Learning

Building a Super Complex Nested IF function with ChatGPT

Start Learning

Reversing the Logic within a Nested Formula

Start Learning

Building Complex Nested Formulas in a Step by Step Approach

Start Learning

Creating our First Nested Formula

Start Learning

Introduction to Nested Formulas

Start Learning

17. Advanced TEXT Formulas

16 mins

Switch Formula - Advanced Text Function

Start Learning

Advanced Text Function – Replace

Start Learning

Advanced Text Function - Substitute Function

Start Learning

Advanced Text Function – Numbers

Start Learning

Advanced Text Function - Extracting AM or PM from timestamp

Start Learning

Advanced Text Formula - Text Formula basic use cases

Start Learning

Advanced Function - Extract month info using Text formula

Start Learning

18. Rounding Functions

11 mins

Round Up formula in Excel

Start Learning

Round Down Formula in Excel

Start Learning

Round Formula in Excel

Start Learning

MRound Formula in Excel

Start Learning

Ceiling and Floor - Excel

Start Learning

19. Dashboarding

3 hrs

Dashboarding - Importance of Dashboard

Start Learning

Dashboarding - Creating and Managing Business Questions

Start Learning

Dashboarding - Setting up the Environment

Start Learning

Dashboarding Generating Business Answers and Questions

Start Learning

Dashboarding - Choosing Charts – Version

Start Learning

Dashboarding - Removing Distractions

Start Learning

Aligning the Charts to the Dashboard Sheet

Start Learning

Dashboarding - Bringing the Insights Out

Start Learning

Dashboarding - Slicers and Timelines

Start Learning

Dashboarding - Coloring and Theming

Start Learning

Dashboarding Final Touches before Publishing

Start Learning

Dashboarding - Managing Blanks and Views

Start Learning

Dashboarding - Aligning Complex Chart and Customizing Slicers

Start Learning

Dashboarding – Grouping

Start Learning

Dashboarding Contextual Charting

Start Learning

Dashboarding - Customizing Everything and Hidden Chart Options

Start Learning

Advanced Coloring and Theming Complex Dashboards

Start Learning

Dashboarding - Customizing the Slicer Colors

Start Learning

Dashboarding - Data Summarization

Start Learning

Creating Answers for the Business Questions

Start Learning

Custom Complex Charts

Start Learning

Customising the column bars and using shapes

Start Learning

Customising the KPIs

Start Learning

Orders management Dashbard – English

Start Learning

Removing Distractions and Adding Missing Objects

Start Learning

20. Advanced AI Use cases with Excel

47 mins

Project Alert Deadline with AI

Start Learning

Inventory Management with ChatGPT

Start Learning

Profit Margin Percentage

Start Learning

Expense Report Validation with ChatGPT

Start Learning

Employee Attendance Tracker

Start Learning

Dynamic Pricing Model

Start Learning

Customer Segmentation with ChatGPT

Start Learning

Counting of Words in Excel - AI

Start Learning

About the course

Meet your instructor

Kadhiravan Jayachandiran

Raj Nakshatra

kundan Prajapati

Mehr Malde

Linus

989

Learners

Beginner

Level

English

Language

1 Year

Access

Certificate

11 hrs 43 mins

Duration

₹---

Certificate of completion

Complete course on Microsoft Excel

Why should you enroll in this course?

Course overview

About the course

Meet your instructor

Reviews