Complete Microsoft Excel in English

Get Access for ₹199

Join over 4,000+ students

English

Get a certificate

138 Lessons

12 Hours

GET CERTIFIED

Ready to learn Complete Microsoft Excel in English ?

Get Started

What you’ll learn

Course Home Expand All
Excel Introduction
2 Topics
Microsoft Excel Introduction
Notice for Certificate
Workbook
4 Topics
Create and Close Workbook
Save Workbook
Change number of Worksheets
Set password for Excel File
Worksheets
8 Topics
Insert and Rename worksheets in Excel
Hide and Unhide worksheets in Excel
Move or Copy entire worksheets within Workbook
Insert Rows and Columns in Excel
Hide and Unhide Rows and Columns
Delete rows and Columns
Insert and Delete Cells
Freeze pane at Rows and Columns in Excel Worksheet
Enter Data
8 Topics
How to Enter data in Excel
How to edit data in Excel
Move data in Excel
Duplicate data in Excel
Enter data with Fill Handle
Custom Patterns with fill handle
Drag and Drop in Excel
How to delete data in Excel
Find and Replace
5 Topics
How to find a value in Excel
How to find a formatted value in Excel
How to find all matches at once in Excel
How to find and replace a value
How to find and replace formatted values in Excel
Introduction to Formulas and Functions
3 Topics
What is formula and functions in Excel
Arithmetic operations in Formula
Order of operations in Excel
Cell References
6 Topics
What is Cell Reference in Excel
Relative Reference
Relative Reference Examples
Absolute Reference
Absolute Reference Examples
Mixed Reference
Date and Time Functions
6 Topics
Year, Month, Day, Date
Now and Today Function
Hour, Minute, Second and Time Fuctions
EDate and EOMonth Functions
Weekday and Weeknum
Date and Time Functions File
Logical Functions
4 Topics
Download Practice Files
AND Function
NOT Function
OR Function
Statistical Functions
7 Topics
Count Function
CountIF Function
SUM Function
SUMIF Function
Calculate Average Value
Find Maximum and Minimum Values using MAX and MIN
Statistical Function File
Information Functions
8 Topics
ISERROR Function
ISERROR Function File
ISNUMBER Function
ISNUMBER Function File
ISNA Function
ISNA Function File
ISBLANK Function
ISBLANK Function File
Maths Function
5 Topics
ABS Function
Even Function
INT Function
Rand Function
Rand Between Function
Conditional Formatting
14 Topics
What is Conditional Formatting
How to create conditional formatting rule
How to revise a conditional formatting rule
How to add additional conditional formatting rules
How to delete conditional formatting rules
How to highlight top and bottom values
How to highlight above and below average values
How to use data bars
How to use colour scales
How to use icon sets
How to highlight text values with conditional formatting
How to show duplicate values with conditional formatting
How to highlight rows with conditional formatting
How to highlight rows using multiple criteria
Excel Tables
12 Topics
What is an excel table
How to create a table in excel
How to remove table in excel
Excel Table Options
How excel table range works in excel
How to add a totals row to a table
How to remove duplicates from a table
How to sort an excel table
How to use Table filters
Working with table rows and columns
How to add a slicer to a table
How to use table slicer options
Lookups
5 Topics
VLookup in Excel
VLookup with a Match
HLookup
VLookup with Index and Match
XLookup
Pivot Tables
9 Topics
Pivot Table Introduction
Why you should use a table for your pivot table
How to add fields to a pivot table
How to rearrange fields in a pivot table
How to access field settings in a pivot table
Format numbers in a pivot table
How to change the math used for pivot table values
How to control grand totals in a pivot table
How to control subtotals in a pivot table
Excel Shortcuts
7 Topics
Shortcut for file command
Shortcut for cell editing
Shortcut for cut, copy, paste
Shortcuts for undo, redo
Shortcuts for entering data
Shortcuts for find and replace
Shortcuts for navigating workbook
Charts
5 Topics
Bar Chart
Column Chart
Line Chart
Pie Chart
Scatter Chart
VBA
12 Topics
VBA Visual Basic Editor Interface
Excel VBA-Enable Developer tab
Excel VBA-Record Macro
Excel VBA-Save Macro
Excel VBA-Write a simple macro
Excel VBA-Entering data using VBA
Excel VBA-Insert Rows and Columns in Excel
Excel VBA-Hide and Unhide Rows
Excel VBA-Hide Columns in Excel
Excel VBA-Change Column width in Excel
Excel VBA-Change Row Height
Excel VBA-Delete Rows and Columns in Excel

What my students say

Create custom landing pages with Shades that convert more
visitors than any website—no coding required.

What you will get?

138 Lessons

Lifetime Access

Certificate

Practice Files

Get Access

Newsletter

Stay Updated

An education platform that connects students to experts.

Pixelgate Technologies

Facebook Instagram Envelope

Company

About us

Become a Trainer

Contact Us

Learn

In Hindi

In English

Terms & Conditions

Privacy Policy

Refunds & Cancellation

Terms & Conditions

Affiliattes

Affiliate Area