Formatting and Functions with Excel (Intermediate) - Bespoke
Please note: This programme is specifically designed for people working in the Health and Social Care sector. For more information on similar programmes for yourself or your organisation, please enquire.
Build on your basic Excel knowledge. This session will introduce you to more advanced formatting tools and key functions to make your data work harder for you. You will leave with practical skills that will help you manage, analyse, and present your data more effectively.
-
Description
This practical and hands-on programme covers advanced Excel formatting techniques and commonly used functions that save time and ensure accuracy in your work. During the session, you will:
- Customise your spreadsheets using conditional formatting to highlight key data trends and exceptions.
- Create visually engaging charts and graphs to present your data clearly and effectively.
- Explore more advanced functions.
- Manage larger datasets with tools such as freezing panes, splitting windows, and working with multiple sheets.
- Learn efficient techniques for cleaning up and organising your data to ensure accuracy and consistency.
-
Entry Requirements
This programme is designed for people working in the Health and Social Care sector who already have basic Excel skills, including knowledge of creating spreadsheets and using simple formulas. For more information on similar programmes for yourself or your organisation, please enquire.
You will need a foundational understanding of Excel, such as creating and saving spreadsheets, formatting cells, and using basic arithmetic formulas.
-
Qualification
Non-accredited Tailored Learning
-
Progression
Upon completing this course, you will be well-placed to explore more advanced Excel functions. You will gain skills that can significantly enhance your everyday work, improving efficiency and accuracy while boosting your confidence in using Excel. Consider other courses focused on advanced Excel skills or additional applications.
-
Assessment
There is no formal assessment for this programme. Instead, you will receive plenty of hands-on practice with live guidance from the instructor, ensuring you feel confident in applying what you learn straight away.
-
Home Study
As this is a short programme, no homework will be assigned. However, you will be encouraged to continue practising your new skills after the session to cement your learning.
-
Work Placement
Work experience is not included in this programme.
-
Fees and Additional Costs
This programme is fully funded, subject to eligibility, with no additional costs to the learner.
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242501 | 09/01/2025 | 09/01/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242502 | 15/01/2025 | 15/01/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242503 | 22/01/2025 | 22/01/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242504 | 05/02/2025 | 05/02/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242505 | 12/02/2025 | 12/02/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242506 | 26/02/2025 | 26/02/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242507 | 12/03/2025 | 12/03/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242508 | 19/03/2025 | 19/03/2025 | 15:00 - 17:00 | TBC |
| Code | Day | Start | End | Times | Fees* |
|---|---|---|---|---|---|
| NHS/MEFF1 242509 | 26/03/2025 | 26/03/2025 | 15:00 - 17:00 | TBC |
* Terms and conditions apply. The fees stated on this website are for guidance purposes only and should be checked before enrolment. Unless otherwise stated, fees shown are for tuition only, over one academic year. Where a course is longer than one academic year, the fees stated are for the first year, and the cost of the second or subsequent years will be discussed at interview. For details of fee remission for students over 19 click here. If you think you may be entitled to a concession or fee remission, or you would like more information on the additional costs associated with your chosen course, please contact us on 01635 845000 or email This email address is being protected from spambots. You need JavaScript enabled to view it..