Sum, Product, SumProduct, Factorial and Square Root

Round, Roundup, Rounddown

Subtotal and Aggregate function

Rand and RandBetween

Concatenate to Combine Text of Different columns

Find, Replace, Substitute text or number

LEN, Right, Left, MID, Proper, Text, Trim

Formatting and Conditional Formatting

Filters and Advance Filters

Transpose Function

DATE, DAY, MONTH, YEAR, EDATE, NOW, EOMONTH, WORKDAY, TODAY, WEEKDAY, HOUR, MINUTE, SECOND

IF-Else condition, Nested IF (IF inside IF), Complex IF-ELSE-IF

Use of AND, OR Error and Validation ISBLANK, ISTEXT, ISERROR, ISNUMBER function

Sumif and Sumifs function

Countif and Countifs function

Averageif and Averageifs

Vlookup, Nested Vlookup (Vlookup inside Vlookup) , Hlookup

Choose, Index, Match function, Match-Index functions

Text to Column, Absolute & Relative Reference, Mixed Reference

Scenario Manager, Goal Seek

Reverse Lookup with Choose Function

Circular Reference

Solver tool

Address, Column, Hyperlink, Indirect, RTD, OFFSET, Areas Function

Pivot Tables and Charts

Dynamic Graph and Pivot Table Reporting

Timelines and Slicers using Pivot Tables

DB (Declining Balance), DDB (Double Declining Balance), SYD ( Sum of Year Digit), SLN (Straight Line Method) to calculate depreciation

DSUM, DAVERAGE, DMAX and DMIN function

PMT function to calculate EMI for loan based payments

PPMT and IPMT to find out the Principal amount & Interest amount separately

Effect, XNPV, Rate, Disc, FV ,Received, ABS, Even, INT, PV Function

IRR Function in Excel

Dynamic Array Formulas

Formula Auditing in Excel

Forecasting and Flash Fill

Sparklines and Mapping Data

Freeze Panes

Calculate Rank

Create a Pivot Table

Find out EMI through PMT Function

Calculate Loan Amount

Compare Sales Report through Consolidate function

Intro to Macro Window

Recording Macros and Viewing

Protect / Unprotect a Worksheet

Protect / Unprotect Formulas

Page Setup & Printing