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

Audience

This course is designed for people who want to use, edit or create mathematical and logical formulas in their spreadsheets.

Outcomes

To be able to automate Excel processes by writing and troubleshooting mathematical & logical formulas.

Course Content

Will be able to read, write and edit the following formulas:
IF Formulas
Nesting IF functions
Nesting IF with AND, OR and TODAY functions
SUM, SUMIF, SUMIFS, MAX, MIN, MODE, AVERAGEIF
COUNT, COUNTA, COUNTIF and COUNTIFS functions
Advanced Filter to extract unique values

Duration

3 hours with lots of hands-on practical exercises

Prerequisites

Must be familiar with the very basics of writing a formula.

Price

£435 including the hire of 8 laptops

Includes

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

[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
    +44  7797 774676
    [email protected]

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