£0 – £15

Multiple Dates

Excel - data analysis

Event Information

Share this event

Date and Time

Location

Location

ALX Training

19 Hilary Street

Saint Helier

JE2 4SX

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Introduction:

This course is part of a wider programme of investment to support skills development for staff in local businesses. The investment aims to address skills shortages and courses have been identified through consultation with businesses and industry bodies. Delegates must be Entitled or Entitled for work*

Target audience:

For individuals who need to analyse or manipulate data for reporting purposes. The 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:

  • Design a spreadsheet
  • Use the subtotal function
  • Insert and manipulate a pivot table
  • Use pivot tables to summarise and analyse data
  • Create a pivot chart
  • Apply advanced filters to extract data
  • Use the what-if tools

Course details:

  • Please arrive at the venue 5 minutes before the start time
  • Tea, coffee and water will be provided
  • Please bring note pad and pen
  • There is no parking available on site, so delegates who are travelling by car should allow themselves sufficient time to locate adequate public parking

Other information:

Please ensure that you have the consent of your delegates before booking them on to a course and entering their information in the booking

* If you have any queries regarding the residential status of your staff members, please contact the business licensing team at businesslicensing@gov.je

Share with friends

Location

ALX Training

19 Hilary Street

Saint Helier

JE2 4SX

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved