Users with a sound understanding of Excel who wish to refine their techniques & expand their knowledge of some of the more sophisticated features of the package.

Attendance of the Intermediate Excel course or commensurate knowledge through experience.

• More on Formulae & Functions:
  • Date & Time Functions
  • Maths & Trig Functions
  • Logical Functions
  • Statistical Functions
  • Lookup & Reference Functions
  • Text Functions
  • Financial Functions
  • Information Functions
• Working with Scenarios
• Formula Auditing
• Using the Error Checking Tools
• Using Data Validation
• Goal Seeker & Solver
• Linking Multiple Workbooks
• Entering Formula Across Workbooks
• More on Data Lists
• Advanced Filters
• Database Functions
• Grouping & Outlining
• Working With Pivot Tables
• Modifying & Enhancing Pivot Tables
• Extracting Pivot Data
• Pivot Calculations
• Creating Pivot Charts
• Setting Defaults
• Cell Comments
• Go To & Paste Special
• OLE Linking
• Designing & Working With Templates
• Creating & Using Custom Views
• Creating Custom Charts & Displaying Trend Lines
• Combination Charts
• Using the Drawing Tools
• An Introduction to Macros
• Attaching Macros to Shortcut Keys & Toolbar Buttons
• Editing Macros
• Macro Virus Protection

By the end of the course the user will have an excellent understanding of the more sophisticated features of Excel 2003 and will be capable of designing & automating impressive spreadsheet models.