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.