Excel Advanced (1.5 day duration)
Event Information
About this Event
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.30p.m.
Important Note:
Click here to download skills assessment just to make sure you are registering at right level.
Email to training@tphumancapital.com.au for review, prior to registering for event.
Or click here for more information about this workshop.
Click here to access Terms and Conditions prior to registering