Functions and Formulae

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 Personal Development Adobe Training Project Management Training IT Governance Training View the Trainers Testimonials

Training Venue Hire Prometric and Practicum Testing Facilities

Functions and Formulae - This module is set at an Intermediate Level

Review of Simple Calculations

When to use brackets in a calculation
Using Absolute and Relative References in a calculation
Creating percentage calculations

Statistical and Math Functions

Average, Max, Min, Count, Counta, Countif and Sumif

Formula Auditing Toolbar

Switch the toolbar on and off
Solve Circular References
Understand the relationship between values and their formulae
Add comments
Monitor changes to cells with the Watch Window

Range Names

What are range names and why would you use them?
Create, edit, delete and use range names

If you are interested in our New Half Day modules then please contact us on 01189 778560 or email us at:

info@mass-trainingcentre.com

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