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 – Data Analysis I

Excel – Data Analysis I

Audience

For individuals who need to analyse or manipulate data for reporting purposes. This course is ideal for anyone wanting to expand their knowledge of Excel

Outcomes

To become faster and more confident analysing data with Pivot Tables and other useful analytical tools.

Course Content

Understand the best way to arrange data in a spreadsheet?
Finding and fixing inputting errors
Understand Pivot Fields and lists
Use Pivot tables to summarise & analyse data
Format, Layout and Design Options
Summarise field settings – Average, Count, Sum
Inserting Calculated Fields, Using grouped dates
Copy and Paste Visible Cells
Insert and edit Pivot Chart
Inserting Slicers & Timelines
Use the subtotal function to calculate subtotals

Duration

3 hours with lots of hands-on practical exercises

Includes

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

Price

£435 Maximum 8 delegates
£54 per additional delegate

[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