Rita V.

Cover the total Excel in 18 Hours as per the convenience of the student. 18 hours of lecture includes:
1) Understanding Spreadsheet & Cell, Typing Data into Cell, Typing data into Multiple cell , Merging cell, wrap text, Numbering , Bullets.
2)Formatting Numbers & Formatting Cells
3)Editing Data in cell, Add & delete rows & Column, Adding sheet, Renaming Sheet, Rearranging Sheets, Deleting Sheets, Move & Copy Sheet to another Excel file, Filter, Sort.
4)Clearing Data
5)Printing Workbook
6) Paste Special with Values, Formats, Formulas, Transpose
7)Filling Blank with PSF, INT, Even , Odd
8)GCD, LCM, Rand, Count, Counta, Count blank, Count if, Count ifs
9)Sum, Avg, Count, Max, Min, Product, ABS , SQRT,
10)Round, Round-up, Round Down, Sum with Sub total
11) V- Lookup, H- Lookup
12)Sum if, Sum ifs , Concatenate, Text To Column
13)Pivot Table with all field
14)Conditional formatting
15)And Formula , Or Formula & Data Validation
16)Smart Art , Diagram & Chart
17)Hyper Link
18)Pivot Diagram
19)Record Macro program
20)Letter format with V-Lookup