Description: Microsoft Excel Advanced Training Course

The objectives of this training course is to become familiar with the more advanced features of M/S Excel.

• Advanced Functions
• Advanced Charts
• 3 dimensional spreadsheets
• Using Workgroups
• Cell Linking
• Goal Seek
• Scenarios
• Auditing Tools
• PivotTable selection / Options
• Automatic Sorting
• Formulas and calculations
• Design and use of Templates
• Macros - Use and Design
• Personal.xls
• Customising toolbars
• Using Excel as a database
• Using Ranges
• Sorting and Querying Data
• Autofilter / Advanced Filter
• Subtotals

Note:  Where possible, courses can be tailored and designed to meet the needs of the participant/group in order to maximise the knowledge gained from the programme.