A overview of the screen, navigation and basic spreadsheet concepts

Understanding workbooks, worksheets, rows, columns, cells

Various selection techniques

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

SumIf, SumIfs

CountIf, CountIfs

AverageIf, AverageIfs

SumProduct, Subtotal

Vlookup / HLookup

Match

Dynamic Two Way Lookup

Creating Smooth User Interface Using Lookup

Offset

Index

Dynamic Worksheet linking using Indirect

Nested If ( And Conditions , Or Conditions )

Alternative Solutions for Complex IF Conditions to make work simple

And, Or, Not

Upper, Lower, Proper

Left, Mid, Right

Trim, Len

Concatenate

Find, Substitute

Today, Now

Day, Month, Year

Date, DateDif, DateAdd

EOMonth, Weekday

Round

RoundUp

RoundDown

MRound

isNa

isErr

isError

Paste Formulas

Paste Formats

Paste Validations

Paste Conditional Formats

Add / Subtract / Multiply / Divide

Merging Data using Skip Blanks

Transpose Tables

Sorting on Multiple Fields

Dynamic Sorting of Fields

Bring Back to Ground Zero after Multiple Sorts

Filtering on Text, Numbers & Date

Filtering on Colors

Copy Paste while filter is on

Advanced Filters

Custom AutoFilter

Working with Themes

Setting Up Print Area

Printing Selection

Branding with Backgrounds

Adding Print Titles

Fitting the print on to a specific defined size

Customizing Headers & Footers

From Web Page

Exporting to XML

Creating Dynamic Dashboards and Reports Using Data on Other Applications

Using Text To Columns

Goal Seek

Scenario Analysis

Data Tables

Number, Date & Time Validation

Text Validation

List Validation

Handling Invalid Inputs

Dynamic Dropdown List Creation using Data Validation

File Level Protection

Workbook Level Protection

Sheet & Cell Level Protection

Setting Permissions for Specific Tasks

Track changes

Consolidating data with identical layouts

Consolidating data with different layouts

Consolidating data with different Sheets

Creating Basic Conditional Formats

Managing Conditions Created

Dynamic Formatting using Formulas in Conditional Formatting

Creating Simple Pivot Tables

Basic and Advanced Value Field Setting

Sorting based on Labels and Values

Filtering based on Labels and Values

Grouping based on numbers and Dates

Drill-Down of Data

GetPivotData Function

Calculated Field & Calculated Items

Bar Charts / Pie Charts / Line Charts

Dual Axis Charts

Dynamic Charting

Other Advanced Charting Techniques

Bar Charts / Pie Charts / Line Charts

Planning a Dashboard

Adding Tables to Dashboard

Adding Charts to Dashboard

Adding Dynamic Contents to Dashboard