Microsoft Excel is the bestselling and most widely used spreadsheeting program in the world. Microsoft Excel is standard in most businesses, and is almost essential to operate efficiently in today’s office environment. TP human capital’s Microsoft Excel training will give you the skills to confidently and efficiently produce professional spreadsheets and database
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills in the more advanced areas of Excel such as goal seeking, linking, macros, web publishing and PivotTables.

Course Topics

• Nesting Functions
• Advanced Filters
• Validations
• Goal Seeking
• Data Tables
• Scenarios
• Pivot Tables
• Linking Workbooks
• Consolidation
• Excel On The Web
• Summarising Data
• Macro Virus Control
• Recorded Macros
• Recorder Workshop

Prerequisites Intermediate Excel

Duration 1.5 Days – 9.00a.m. to 4.00p.m. and 9.00a.m. to 12.00p.m.