CERTIFICATE IN ADVANCE EXCEL ( M-A/E )

Introduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)

All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)

Formatting Data

Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)

Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis

Charts (Working With Charts)

Logical Functions (IF, AND,)

Financial Functions (PMT, PV, RATE)

Data Validation

Conditional Formatting

Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, XLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)

Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)

Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)

MIS Report (PIVOT TABLE, PIVOT CHART, VLOOKUP, HLOOKUP, XLOOKUP, ADV. FILTER, CONSOLIDATE, CONVERT, ABS, SUMPRODUCT, FIND , TEXT