Launching Excel

Microsoft Excel Start-up Screen

Introduction to the Excel Interface

Customizing the Excel Quick Access Toolbar

More on the Excel Interface

Understanding the Structure of an Excel Worksheet

Saving an Excel Document

Opening an Existing Excel Document

Common Excel Shortcut Keys

Font formats, Alignment, Borders, etc

Basic conditional formatting

Entering Text to Create Spreadsheet Titles

Working with Numeric Data in Excel

Entering Date Values in Excel

Working with Cell References

Creating Basic Formulas in Excel

Relative Versus Absolute Cell References in Formulas

Understanding the Order of Operation

The structure of an Excel Function

Working with the SUM() Function

Working with the MIN() and MAX() Functions

Working with the AVERAGE() Function

Working with the COUNT() Function

Adjacent Cells Error in Excel Calculations

Using the AutoSum Command

Excel's AutoSum Shortcut Key

Using the AutoFill Command to Copy Formulas

Moving and Copying Data in an Excel Worksheet

Inserting and Deleting Rows and Columns

Changing the Width and Height of Cells

Hiding and Unhiding Excel Rows and Columns

Renaming an Excel Worksheet

Deleting an Excel Worksheet

Moving and Copying an Excel Worksheet

Working with Font Formatting Commands

Changing the Background Colour of a Cell

Adding Borders to Cells

Formatting Data as Currency Values

Formatting Percentages

Using Excel's Format Painter

Creating Styles to Format Data

Merging and Centring Cells

Using Conditional Formatting

File Level Protection

Workbook, Worksheet Protection

Add New Range fro protection

Upper, Lower, Proper

Left, Right, Mid

Trim, Len, Exact

Find, Search, Text, Number, Code, Substitute

Concatenate, Replace, REPT

Sum, Sumif, Sumifs

Average, Averageif, Averageifs

Count, Countif, Countifs,

Average, Averageif, Averageifs

Max, Min

If, ifs

and, or, not and with if, or with if, not with if

Today, Now

Day, Month, Year, YearFrac

Date, Date if

EOMonth, EDate, Weekday, WeekNUM, Workday

Hour, Minute, Second

Future Value (FV)

FVSCHEDULE

Present Value (PV)

Net Present Value (NPV)

XNPV

PMT

PPMT

Internal Rate of Return (IRR)

Modified Internal Rate of Return (MIRR)

XIRR

NPER

RATE

EFFECT

NOMINAL

SLN

Paste Formulas, Paste Formats

Paste Validations

Transpose Table

Plan Paste

Working with Charts

Using SLICERS, Filter data with Slicers 

Creating Simple Pivot Tables 

Basic and Advanced Value Field Setting 

Classic Pivot table 

Choosing Field 

Filtering PivotTables 

Modifying PivotTable Data 

Grouping based on numbers and Dates 

Calculated Field & Calculated Items 

using of Page Break Preview

Setting of Margin, Orientation & Page Size

Print Area, Page Break and Print Titles

Scale to Fit, Gridlines , Heading

Import & Export Data

Sorting and Filtering

Text to Column, FlashFill, Remove Duplicate

Data Validation

Consolidate the Data

What-if-Analysis

Scenario Manager

Goel Seek

Data Table

Forecast Sheet

Outline

Group

UnGroup

Sub Total

Solver Add-in​

Vlookup / HLookup 

Index and Match 

Creating Smooth User Interface Using Lookup 

Nested Vlookup 

Reverse Lookup using Choose Function 

Worksheet linking using Indirect 

Vlookup with Helper Column

What Is VBA?

What Can You Do with VBA?

Recording a Macro

Procedure and functions in VBA