advertisement

MS Excel - Charts/Graphs and Pivot Tables - Level 1 - IT0054

Who is it for?

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

Aims

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 Tables and 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 Tables/Charts
  • Update data sources

Course description

Virtual training and face-to-face.

Cost 

£75 per person.

Apply

Participants should be comfortable using a computer, to be able to navigate around the screen, work with folders and files, use the taskbar and manage the mouse. 

All Microsoft Excel courses are designed to use the mouse and not the trackball facility that is available on the laptop. Please ensure you have a mouse to use.

For virtual training, you will need to be familiar with using Microsoft Teams Meetings, work with the Windows Taskbar, be able to switch applications and access files and folders in File Explorer. 

Links to the course and data files will be sent four weeks prior to the course date.

If, when you have tried to book a course, you see no future dates displayed, please register your interest by emailing sldteamstrainingandsupport@lancashire.gov.uk

Book your place.