Rajesh Computer Institute

Admission Now

ntroduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)
All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
Entering and Editing Data.
Inserting and Deleting Row or Column.
Formatting Data
Auto fill Lists ( Default lists & Creating new lists)
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