MS-Excel

 Course Contents:

Basic MS-Excel:
1.       Spreadsheet basics, Creating, Editing, Saving and Printing spreadsheets, working with functions & formulae
2.       Graphically representing data: Charts & Graphs.
3.       Analyzing data: Data Menu, Subtotal, and Filtering Data.
4.       Formatting worksheet, Securing & Protecting spreadsheets.

Advanced Excel Contents:

      1.       Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT)
2.       Nested functions, Name cells/range/constants
3.       Relative, Absolute, Mixed cell reference :>,<, = operators
4.       Logical functions using IF, AND, OR, NOT
5.       The LOOKUP functions, Date and time functions.

Data Analysis:
1.       Sub Total Reports, Auto Filter, Password Protecting Worksheets
2.       Linking Multiple Sheets, Sheet Referencing, Linking Multiple Sheets, Sheet Referencing, Linking Between Word/Excel/Ppt
3.       Functions: - LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
4.       What-if—analysis, GOAL SEEK
5.       PIVOT Tables, NESTED IF
6.       Reporting, Character, Consolidation of Data, Data Validation

Basic Macros:
1.       Definition and use, Record a macro
2.       Assign a macro, Run a macro

Special Operations:
1.       Use multiple windows: copy/paste between worksheets
2.       Link worksheets, Consolidate worksheets
3.       Import and link from other Applications
4.       Use AutoFormat: Create, Use and modify styles and templates
5.       Print Features :Create/edit  an outline