Entering, Editing and Deleting Text, Numbers, Dates

Using Auto Lists

Moving and Copying data

Inserting, Deleting and Hiding Rows & Columns

Inserting, Deleting, Moving and Copying Sheets

Using navigation techniques

Customizing the Ribbon

Customizing the Quick Access Toolbar

Using and Customizing AutoCorrect

Changing Excel’s Default Options

Creating a Custom AutoFill List

Creating a Custom Number Format

Customizing Excel Review

Using Workbook Views

Selecting and Switching Between Worksheets

Splitting and Freezing a Window

Creating Headers and Footers

Hiding Rows, Columns, Worksheets, and Windows

Working with Multiple Workbook Windows

Creating a Template

Managing Workbooks Review

Concept of Formulae

Creating Formulae, Editing Formulae

Bodmas : Mathematical Order

Copying Formulae

Using Functions - Sum, Average, Max,Min, Count, Counta

Applying Absolute (Fixed) Referencing

Relative Reference

Absolute Reference

Mixed Reference

Moving Range Reference

Formatting Cells with Number formats, Font formats, Alignment, Borders, etc

Basic conditional formatting

Copying and Clearing Formats

Working with Styles

Spell Check, Find & Replace and AutoCorrect

Concept and Purpose

Naming individual or range cells

Deleting and amending named ranges

Using named cells/ranges in formulae

Benefits and purpose

If Statements , Nested If

And, Or, Not

Combining If, And, Or, Not

Sumif , Countif

Conditional Formatting

Entering Dates and Times

Different date/time formats

How dates are stored

Calculating working days

Using the DAY(),MONTH(),YEAR() functions

Formula Auditing Tools

Revealing Formulae

Tracing Precedents/Dependents

Goto Special

Linking sheets in the same file

Linking different Excel files

Using Edit, Links

Viewing different files at once

Saving a workspace

Viewing different sheets at once

Window Split

Data consolidation

Sorting Data

Adding Subtotals

Autofilter

Freeze Panes

Group and Outline

Data Form

Using the Chart Wizard

Editing and Formatting charts

Saving custom chart types

Setting a default chart type

Vertical Lookup (Vlookup)

Horizontal Lookup (Hlookup)

Match and Index

IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa

Advanced Filters

Using List Features

Dynamic Lists

Using the Pivot Table Wizard

Changing the pivot table layout

Formatting

Grouping items

Inserting calculated fields

Pivot Table Options

Display and hide data in fields

Layout reports directly on worksheet

Pivot Chart

Scenarios

Goal Seek

Solver

Sharing a file

Tracking changes

Accepting or rejecting changes

Applying Data validation rules

Inserting comments