PS Training Ltd

Printer-friendly document

Course Booking and enquiries: 01352 810443
enquiries@pstraining.co.uk

Prerequisites:
Attendees should have attended, or have knowledge equivalent to the Introductory, Intermediate & Advanced Level courses.

Duration:
This course can be delivered as a full day course or as individual half day modules

Module 7 - Automating the Workbook

• Recording Macros and attaching to Buttons
• Virus Checking Workbooks containing Macros
• Creating Custom Views to allow specific areas to be printed quickly
• Use the consolidation feature to bring information together
• Entering Database Statistics - Calculations to summarise information with DSum, Daverage etc where is returns data dependent upon the criteria specified

Module 8 - Use of Analysis Tools

• Using Goal Seek to automatically arrive at a required result by changing the variables used within a formula
• Use of Solver (similar to Goal Seek with the additional option of setting specific criteria)
• Creating Solver reports
• Using the What If feature to build cross-reference tables
• Overview of the Scenario Manager
• Creating Multiple Scenarios within a worksheet
• Displaying various Scenarios
• Editing and Deleting Scenarios