MS Excel - Data Manipulation - No Functions and Formulas - Level 1&2 - Step 4 - 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

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.

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