Advanced Aspects of Microsoft Excel

Requirements:

Attendance of Introduction to Microsoft Excel (2 half day sessions).

Duration:

1 Half Day Session

Cost:

£70.00 plus VAT one-to-one with reductions for group training. (£80.00 plus VAT one-to-one if Sessions 1 and 2 were not previously attended).

Course Materials:

Handbooks provided for each trainee.

Further Training:

Follow on one-to-one sessions at £30.00 plus VAT per hour on an Address your Requirements basis.

• Printing Techniques
• Saving the print settings and creating reports
• Multi-Spreadsheet Activities
• Manipulating and viewing worksheets
• Copying, moving and linking between worksheets
• Linking between workbooks
• Functions
• Using more advanced functions including Lookup and If functions
• Working with Macros
• Different ways to run a macro
• Recording and assigning macros
• Database Facilities
• Sorting and filtering techniques
• Subtotals and pivot tables
• What-If Features
• Goal Seek, Solver and Scenarios
• Controls for Custom Forms
• A look at controls including Check boxes, Option Buttons and List Boxes