Step 4 - MS Excel - Data Manipulation - No Functions and Formulas - Level 1&2 - IT0055

Who is this course for?

This course is for participants who would like to manipulate and analyse data using some of the functionalities available within MS Excel. This is a level 1&2 course.

Aim(s)

This course provides the skills and knowledge to be able to manipulate and manage data within a worksheet using techniques other than functions and formulas.

Objectives

• Filter data
• Review Status Bar
• Duplicates and Data Integrity
• Use Subtotals to summarise different groups of data
• Tables Formatting (banding)
• Working with Pivot Tables
• Working with Slicers (Introduction to Dashboards)
• Update data sources
• Link Excel to Word

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.