3 hour Excel & Word Sessions | Beginner to Advanced
£100pp (excl GST)

Open Courses

Book nowBook now

We can create content for Inductions,
Micro Learning modules and Training Videos

eLearning

Find out moreFind out more

3 fully equipped rooms
£45 per hour | Daily rates available

Room Hire

Find out moreFind out more

Inductions | In-house systems
Support | Project Work

Consultancy

Find out moreFind out more

Inductions | Migrations
New Processes | Best Practice

Systems Training

Find out moreFind out more
ALX Training / Excel / Excel: Formulas and Functions I

Excel: Formulas and Functions I

The Need:

To make logical comparisons between values & what you expect
To know how to use If & Nested IF Formulas
To summarise data using SUMIF & COUNTIF formulas
To be able to write, troubleshoot & fix logical & mathematical functions

You will learn how to:

Read, write & edit IF formulas
Nest multiple IF functions together
Nest IF formulas using AND, OR & TODAY functions
Use Sum, SUMIF, SUMIFS, MAX, MIN, MODE, AVERAGEIF, COUNT, COUNTA, COUNTIF & COUNTIFS functions

Logistics:

The course can be delivered online or face to face in our training centre or at your place of work. If you would like to have this class online, you will need access to two screens, a webcam, speakers & a microphone

Prerequisites:

You need to be familiar with content covered in The Essentials

Includes:

All training spreadsheets for future practice
Full colour booklet to accompany the lesson

Cost:

£479 for up to 6 delegates
£79.83 for each additional place

[contact-form-7 404 "Not Found"]
SUBMIT

Contact

Fill out the form below to discover how ALX Training can help you:

    Or talk to us directly...

    +44  1534 873785
    [email protected]

    Hilary House
    19 Hilary St
    St Helier, Jersey
    JE2 4SX