Step 3 - MS Excel Charts/Graphs & Pivot Tables Level 1 - IT0054

Who is this course for?

This course is for any level MS Excel users who would like to visually display data using Charts and Graphs and to summarise data in Pivot Charts. This course is a Level 1.

Aim(s)

This course provides the skills and knowledge to create charts and graphs from data to see trends and comparisons and to summarise data using Pivot Charts.

Objectives

• Create single series charts pie, column and line charts
• Create comparison column, line and combination charts
• Format chart elements - titles, data labels and legends
• Create Pivot Charts
• Update data sources

Trainer

Business Systems Trainer

Course Description

Virtual Training and Face to Face

Course Cost

£75.00

Apply

This course is available either as a Virtual or Face to Face course – which is better for you?

Face-to-Face – this is perfect if you'd rather take your time and ask more questions of the Trainer.

Virtual Training – This is ideal if you're comfortable working with computers, able to navigate between a variety of files and working with multiple windows. The course tends to be faster paced and with a little less interaction than the face-to-face option. For this type of training, it is a must that you have use of two monitors and use of a mouse (not the trackpad on a laptop).

If there are no dates available, please Register your interest.

How to Register your interest - to register your interest in this course please email psteamstrainingandsupport@lancashire.gov.uk - stating whether you'd prefer virtual or face-to-face training, and your name will be added to our waiting list. When we have a few names on the waiting list, we will schedule a course and contact you to advise of the next steps.