1 hour bitesize learning sessions are back
on a range of Microsoft applications

Open Courses

Book nowBook now

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

eLearning

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 moreFind out more

ALX is now based at
Windward House

We have moved...

Find us on what3words
ALX Training / Excel: Data Analysis II

Excel: Data Analysis II

The Need:

To summarise data across multiple sheets with a Pivot Table
To consolidate data from across multiple sheets
To restrict how people input data into a spreadsheet
To carry out more advanced ways of filtering data

You will learn how to:

Use Pivot tables across multiple consolidation ranges
Use the consolidate tool & group sheets
Use further Slicer & Timeline options
Use Goal Seek & Scenario Manager
Use the Watch Window
Use Data Validation
Use the OR criteria to run advanced filters
Use New Data Types

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

Error: Contact form 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
    admin@alxtraining.com


    Windward House
    La Route de la Libération
    St Helier, JE1 1BG
    Jersey

    https://what3words.com/stamp.happy.fanfare