Course Details

MS Office Excel - Advanced Course is done here. This course is designed for those who are familiar with the normal office Excel. The course gives a detailed and systematic way to cope with the advanced techniques in M.S Excel.

Contents :

• Introduction - Excel Specifications and Limits.
• Excel Formulas.
• Logical Functions.
• Conditional Formatting.
• Data Validation.
• Pivot Table and Charts.
• Advanced Sorting Options.
• Advanced Filter.
• Worksheet, Workbook and Workspace.
• Hyperlink Worksheets.
• Linking Sheets Workbooks.
• Data tables.
• Scenarios.
• Paste Special Options.
• Formula auditing 
• Formatting Workbook.
• Advance Chart Options.
• Working with Date and Time.
• Freeze Pane and Split Pane Options.
• Use of Watch Window.
• LOOKUP, VLOOKUP & HLOOKUP Functions.
• Protecting Workbooks.
• Protecting worksheet with Permission to edit a Range.
• Microsoft Excel Tips
• Introduction to Macros.
• Workbook sharing.
• Tracking changes.
• Merging workbooks.