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 NEW Microsoft Excel Half Day Modules 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	£ 150

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.

	Facing The Public Sector Squeeze
	Mass Media Summer 2010

How important is staff training to your organisation?

Mass in the
UAE