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 |