Overview of course
This course is designed for users who wish to understand list manipulation and more advanced functions of Excel 2016.
It will provide delegates with more advanced skills that will streamline repetitive tasks, manipulate lists and display spreadsheet data in more visually effective ways. Exposure to conditional logic, lookup formulas and large dataset manipulation is covered.
The course will be run at West Suffolk College on Tuesday 2 July 2024 from 9.00am to 4.00pm.
Entry requirements
Prior knowledge and / or experience of Microsoft Excel 2016 is desirable.
Qualifications
West Suffolk College certificate of attendance.
Further course detail
The Microsoft Excel 2016 Intermediate course will cover the following topics:
- Absolute Formula Referencing
- Multiple Workbooks/Sheets
- Grouping Sheets/3D Formulas
- Copy - Paste
- Naming
- Conditional Logic
- Lookup Functions
- Conditional Formatting
- Text Functions
- Data Validation
- Sort
I'm interested. What should I do now?
For further details please contact us on 01284 716246 or email This email address is being protected from spambots. You need JavaScript enabled to view it.
To book, please complete the enrolment form by clicking on the link below. Please open this link by using either Microsoft Edge or Chrome, not Internet Explorer as this browser does not support the form.
Days & times
Starting 02/07/2024
Tuesday 09:00 - 16:00