| Duration: 24 Hours |
Module: ADV MS EXCEL
|
||
| Sl no | Topic to be Covered | Theory | Practice sessions |
| 1 | Introduction to excel, Describe Text Formatting options | Theory | Practice sessions |
| 2 | Using formulas,Cell Styles,About Rows & Columns | Theory | Practice sessions |
| 3 | Conditional formating, If statements,Date Function | Theory | Practice sessions |
| 4 | Creating Chart, Types of Chart,Text Fuctions | Theory | Practice sessions |
| 5 | Advance Filter, sub-totals,Concatenate,Header and Footer | Theory | Practice sessions |
| 6 | Consolidate,Text to columns,Count Function,Scenario manager | Theory | Practice sessions |
| 7 | Count functions,sumifs, Data Validation | Theory | Practice sessions |
| 8 | Goal seek, Pivot tables, Transferring of data b/w sheets,Data Table,Solver | Theory | Practice sessions |
| 9 | Importing data from External Sources,Templates and styles,Vlookup,Hlookup | Theory | Practice sessions |
| 10 | Macros and Custom Controls,Comment,Security and Proofing | Theory | Practice sessions |
| 11 | Sheet links, freezing panes, split windows, arrange windows, arrange windows, Advanced features in excel. | Theory | Practice sessions |
| 12 | Assignment on M.S Excel. | Theory | Practice sessions |
