Developed for business users and individuals who wish to advance their knowledge of spreadsheets.

• Splitting a worksheet into panes
• Freezing Panes
• Cell Protection
• Using defined cell names
• Relative and absolute addressing
• Linking worksheets and workbooks
• Consolidate worksheets
• Custom formatting
• Conditional formatting
• Creating an Autofill list
• Filtering and Validating
• Filtering Records
• Vlookup and validating enteries
• If function
• SUMIF and COUNTIF functions
• Statistical and Financial functions
• Generating frequency distributions
• PMT functions
• CUMIPMT function
• Date and timefunctions
• Macros
• What if - Utilities
• Goal seek
• Using Goal Seek and charting
• Charts
• PIVOTTABLE terminology
• Creating a pivot table report
• The onscreen layout

Requirements: Clients are expected to have a good working knowledge of Windows and the basics of Excel.

Outcome: Increased understanding of how to use the advance facilities of MS Excel.

Materials: Full course notes booklet.

Trainer: Martin McLauchlan

This Course Costs £65.00 plus VAT per person.