Excel Essentials and Beyond 

What is Microsoft Excel

Why Excel is important for any career

Understanding the Ribbon

What is Worksheet and Workbook

Data Types in Excel

Format Cells in Excel

Number Tab in Excel

How to change the font, Font size, Font Colour in Excel

How to do Text Alignment and apply border in Excel

How to apply format painter in Excel

Formatting Text and Numbers

References in Excel

Relative Reference in Excel

Absolute Reference in Excel

Mixed Reference in Excel

Navigations using Excel

Flash fill

Sorting Data in Excel

Filtering Data in Excel

Text to Columns in Excel

Syllabus

Further reads on Introduction to Excel

Learn more about Mastering Cell Formatting and Styling in Excel

Learn more about Excel Formatting and Cell Reference Techniques

Learn more about Excel Data Management and Navigation Strategies

Practice Quiz - Introduction to Excel

Practice Quiz - Mastering Cell Formatting and Styling in Excel

Practice Quiz - Excel Formatting and Cell Reference Techniques

Practice Quiz - Excel Data Management and Navigation Strategies

Graded Quiz - Excel Proficiency Essentials

Meet & Greet

Remove Duplicates in Excel

Data Validation in Excel

Conditional Formating in Excel

Advanced Conditional Formatting with Formulae in Excel

Clear Rules

Functions and Formulae in Excel

Sum Function

Min Function

Max Function

Count Function

Count A Function

Average Function

Conditionals in Excel

If Conditions in Excel

If with Or Conditions in Excel

If with And Conditions in Excel

A simple Nested if Conditions in Excel

IfError Condition in Excel

SumIF Condition in Excel

SumIFs Condition in Excel

Further reads on Excel Data Enhancement and Visualization Techniques

Learn more about Excel Functions for Data Analysis and Calculation

Learn more about Excel Advanced Data Analysis and Conditional Logic

Learn more about Excel Conditional Logic and Specialized Functions

Practice Quiz - Data Enhancement and Visualization Techniques

Practice Quiz - Excel Functions for Data Analysis and Calculation

Practice Quiz - Excel Advanced Data Analysis and Conditional Logic

Practice Quiz - Excel Conditional Logic and Specialized Functions

Graded Quiz - Excel Data Analysis and Visualization

CountIF Condition in Excel

CountIFs Condition in Excel

Average IF Condition in Excel

Average IFS Condition in Excel

Date and Time Functions in Excel

Date Function

Today Function

Now Function

Date Value Function

Day Function

Month Function

Year Function

EOMonth Function

Weekday Function in Excel

DatedIF Function

EDATE Function

Workday Function

Workday.INTL Function

NetworkDays Function

NetworkDays.INTL Functions

Further Reads on Advanced Excel Functions and Conditional Calculations

Learn More About Excel Date and Time Manipulation Techniques

Learn More About Excel Date and Time Analysis Toolbox

Learn more about Advanced Date and Workday Functions in Excel

Practice Quiz - Advanced Excel Functions and Conditional Calculations

Practice Quiz - Excel Date and Time Manipulation Techniques

Practice Quiz - Excel Date and Time Analysis Toolbox

Practice Quiz - Advanced Date and Workday Functions in Excel

Graded Quiz - Excel Advanced Functions and Temporal Functions

Lookup Functions in Excel

Vlookup in Excel

Hlookup in Excel

Index and Match Function in Excel

Index Functions

Match Functions

Index and Match Function

Two way Lookup

Case Sensitive Lookup

Left Lookup

Two Column Lookup

Closest Match

Text Functions in Excel

Concatenate Function

Left Function

Right Function

MID Function

TRIM Function

Replace Function

LEN Function

Further reads on Excel Lookup Techniques and Advanced Data Retrieval

Learn more about Excel Advanced Lookup Techniques and Dynamic Retrieval

Learn More About Excel Data Manipulation and Text Techniques

Learn More About Excel Text Manipulation and Cleaning Techniques

Practice Quiz - Excel Lookup Techniques and Advanced Data Retrieval

Practice Quiz - Excel Advanced Lookup Techniques and Dynamic Retrieval

Practice Quiz - Excel Data Manipulation and Text Techniques

Practice Quiz - Excel Text Manipulation and Cleaning Techniques

Graded Quiz - Excel Data Manipulation and Advanced Lookups

Find Function

Round Function

Subtotal Function

Pivot Tables in Excel

Creating a Pivot Table and Dragging a field

Sorting & Filtering in Pivot Table

Changing Summary Calculation in Pivot Table

Two Dimensionals Pivot Table

Slicer in Pivot Table

Charts in Excel

Creating a Chart in Excel

Switch Row/Column for charts in Excel

Legend Position for Charts in Excel

Data Labels for Charts

Pivot Charts in Excel and its types

Creating a Pivot Chart

Filter Pivot Chart

Lines Charts

Scatterplots

Heat maps

Further reads on Mastering Excel Data Analysis and Presentation

Learn More About Excel Pivot Tables and Visual Data Exploration

Learn More About Excel Charting and Visualization Techniques

Learn More About Excel Pivot Charts and Advanced Visualizations

Practice Quiz - Mastering Excel Data Analysis and Presentation

Practice Quiz - Excel Pivot Tables and Visual Data Exploration

Practice Quiz - Excel Charting and Visualization Techniques

Practice Quiz - Excel Pivot Charts and Advanced Visualizations

Graded Quiz - Excel Proficiency Essentials

Histograms

Maps in Excel

Dual Axis Charts

Pie Charts

Bump Charts

Control charts

Funnel charts

Pareto charts

Waterfall charts

Usage and filtration of data with charts

Dashboarding in Excel

Case by creating dashboard

Further Reads On Excel Advanced Visualization Techniques

Learn More About Excel Specialized Charts and Data Analysis

Learn More About Excel Dashboard Design and Practical Implementation

Practice Quiz - Excel Advanced Visualization Techniques

Practice Quiz - Excel Specialized Charts and Data Analysis

Practice Quiz - Excel Dashboard Design and Practical Implementation

Dashboard Creation Project: Enhancing Data-Driven Decision-Making