Microsoft Excel Training - Intermediate Course

Course Content

Multiple Sheets

(Using more than Sheet 1 in your workbook)

• Moving Around
• Selection Techniques
• Inserting
• Deleting
• Copying
• Fill by Example
• Group Mode
  (Allowing typed information to automatically appear on multiple sheets and format that information as a group)
• Consolidation
  (Use Values from multiple sheets and group together by various functions on 1 summary sheet)

Templates

(Allows delegates to create a formatted standard template which can be used as a base for all comapny documents)

• Create
• Modify
• Save
• Auto templates
• Using templates
• Inserting templates

Protection

(Protecting cells, shets, files, and workbooks from modification by other)

• Cell Protection
• Sheet Protection
• Workbook Protection
• File Protection

File Linking

(Linking one file to another for calculation/automatic update purposes)

• External Reference
• Dependant Workbook
• Source Workbook
• Update Links

Printing

(Printing multiple sheets in different fromats together)

• View Manager
• Print Manager

Lists

(Using information as a database)

• Forms
• Custom Filtering
• Advanced Filtering
• Subtotals

Charts

(Printing any chart in a format devised automatically)

• Autotemplate

Who Should Attend

This Microsoft Excel training course is aimed at those who have a very good understanding of Excel at a Foundation Level. Knowledge of the following topics will be assumed:

Basic, Formulas, Relative, Reference, Absolute Reference, Page Setup & Presentation.

Venue & Duration

This is a one day course held on-site.