Loading Events

« All Events

  • This event has passed.

Advanced MS Excel (2010 Version)

December 11 @ 8:00 am - 5:00 pm

MS Excel Training

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

Details

Date:
December 11
Time:
8:00 am - 5:00 pm
Event Category:

Venue

KITS
Kirkdale House
Armytage Road, Brighouse, West Yorkshire HD6 1QF United Kingdom
+ Google Map
Phone:
01484 711462
Website:
www.kits-training.co.uk

Details

Date:
December 11
Time:
8:00 am - 5:00 pm
Event Category:

Venue

KITS
Kirkdale House
Armytage Road, Brighouse, West Yorkshire HD6 1QF United Kingdom
+ Google Map
Phone:
01484 711462
Website:
www.kits-training.co.uk