Microsoft Excel Introduction Notice for Certificate

Create and Close Workbook Save Workbook
Change Number of Worksheets
Set password for Excel File

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

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

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

What is Formula and Functions in Excel
Arithmetic operations in Formula
Order of Operations in Excel

What is Cell Reference in Excel
Relative Reference
Relative Reference Examples
Absolute Reference
Absolute Reference Examples
Mixed Reference

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

Download Practice Files
AND Function
NOT Function
OR Function

Count Function
CountIF Function
SUM Function
SUMIF Function
Calculate Average Value
Find Maximum and Minimum Values using MAX and MIN
Statistical Function File

ISERROR Function
ISERROR Function File
ISNUMBER Function
ISNUMBER Function File
ISNA Function
ISNA Function File
ISBLANK Function
ISBLANK Function File

ABS Function
Even Function
INT Function
Rand Function
Rand Between Function

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

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

VLookup in Excel
VLookup with a Match
HLookup
VLookup with Index and Match
XLookup

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

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 Vavigating Workbook

Bar Chart
Column Chart
Line Chart
Pie Chart
Scatter Chart

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