VENUE - KITS TRAINING CENTRE

DURATION - 1 DAY

PREREQUISITES - Excel 2007: Intermediate or Equivalent Experience

COURSE CONTENT

Advanced Functions

• Logical Functions
• Math and statistical functions
• Financial functions
• Displaying and printing formulas

Lookups and data tables

• Using lookup functions
• Using MATCH and INDEX
• Creating data tables

Advanced List Management

• Validating cell entries
• Exploring database functions

PivotTables and PivotCharts

• Working with PivotTables
• Rearranging PivotTables
• Formatting PivotTables
• PivotTables

Exporting and Importing

• Exporting and importing text files
• Exporting and importing XML data
• Querying external databases

Analytical Options

• Goal Seek and Solver
• The Analysis ToolPak
• Scenarios
• Views

Macros and Custom Functions

• Running and recording a macro
• Working with VBA code
• Creating functions

Conditional Formatting and SmartArt

• Conditional formatting with graphics
• SmartArt graphics

For further information or to make a booking, please contact KITS on 01484 711462 or email info@kits-training.co.uk