These programmes have been designed to support the development of digital skills for people working in the Health and Social Care sector, specifically to target the use of Excel in the workplace. The programmes will be delivered online.
Subjects
Introduction to the basics of Excel, including creating spreadsheets, navigating the interface, entering and formatting data, performing basic calculations and formulas, and interpreting data filters. Perfect for beginners or those needing a refresher.
Covering essential Excel formatting and functions, including the Fill Handle, using Paste Special features, and understanding cell referencing. Explore Filter tools to drill down into data and use Data Validation to ensure consistent data entry. The course also teaches SUMIF and SUMIFS functions and how to visualise data with charts, making it ideal for enhancing your Excel proficiency.
Enhance your Excel skills, introduce preset rules for numbers and text, and highlight duplicate values. The course also covers basic mathematical functions and teaches the IF, SUMIF, and nested IF functions, providing a solid foundation for intermediate data analysis.
About these courses
These short two-hour courses are part of a Digital Skills programme specifically designed for people working in the Health and Social Care sector who wish to improve their confidence in using Microsoft Office applications.
The programme has been designed to provide short, consumable sessions that can fit around a busy schedule, delivered onsite at Newbury College throughout the year.
For more information on similar programmes for yourself or your organisation, please email This email address is being protected from spambots. You need JavaScript enabled to view it..