KITS Training and Conference Centre Based in Brighouse West Yorkshire - Courses in IT - MS Excel Advanced Course
 
 

 

 
MS Excel Advanced - Ref: 506

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

 
Interested?
telephone
01484 711462
or
Enquire Online
 
 
 
© KITS 2014 • Charity Reg. No. 507573 • Company Reg. No. 1219838
KITS • Kirkdale Industrial Training Services • Kirkdale House • Armytage Road • Brighouse • West Yorkshire HD6 1QF • Tel: 01484 711462
KITS Site Map
KITS Home Page KITS Home Page