MS Excel - Data Manipulation - No Functions And Formula - 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 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 |
· Sort and filter data · Work with Advanced Filters · Use Subtotals to summarise different groups of data · Working with Pivot Tables · 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, to be able to switch applications and to access files and folders in File Explorer. Links to the course and data files will be sent 4 weeks prior to the course date. If, when you have tried to book on a course, you see no future dates are displayed, please register your interest by emailing sldteamstrainingandsupport@lancashire.gov.uk |
Delivery Dates & Venue
- Virtual participation
Monday 20 March 2023 (13:00 to 16:00) - Virtual online participation
Tuesday 4 April 2023 (09:30 to 12:30) - Virtual online participation
Monday 12 June 2023 (13:00 to 16:00) - Virtual online participation
Tuesday 25 July 2023 (13:00 to 16:00) - Virtual online participation
Wednesday 6 September 2023 (09:30 to 16:00) - Virtual online participation
Monday 23 October 2023 (13:00 to 16:00) - Virtual online participation
Wednesday 29 November 2023 (09:30 to 12:30) - Virtual online participation
Wednesday 13 December 2023 (09:30 to 12:30) - Virtual online participation
Tuesday 16 January 2024 (13:00 to 16:00) - Virtual online participation
Tuesday 27 February 2024 (13:00 to 16:00)
Click here to obtain our course Booking Form