mass facilities management

Mass Software Training, real training with real qualified results

About Mass Training

Upcoming Events

Training PDF Centre

Search

ARCHIBUS Training AutoCAD Training Microsoft Training Access Training Excel Training Powerpoint Training Project Training Word Training Additional Microsoft Training Personal Development Adobe Training Project Management Training IT Governance Training View the Trainers Testimonials

Training Venue Hire Prometric and Practicum Testing Facilities

Microsoft Excel 2007 Advanced

This one-day training course builds on the skills and concepts taught in Excel 2007 Intermediate

Duration	Price
1 Day	£ 250

Course Overview

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

Pivot Tables and Pivot Charts

Working with Pivot Tables
Rearranging Pivot Tables
Formatting Pivot Tables
Pivot Charts

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

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.

mass page bottom navigation

HOME | CONTACT | PRIVACY STATEMENT | EMAILED NEWSLETTER | LINKS | SITE MAP

© 2009 Mass p.l.c.

	Mass Media Issue 10 - Autumn 2011
	A Happy Birthday!

Which is the greatest business spend in the UK?

Mass in the
UAE