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 The Stem Innovation Campus, West Suffolk College on Tuesday 20 October 2020 from 9.30am to 4.30pm.
Prior knowledge and / or experience of Microsoft Excel 2016 is desirable.
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
- Conditional Logic
- Lookup Functions
- Conditional Formatting
- Text Functions
- Data Validation
**Funding may be available to support the cost of this training. Eligibility criteria exists, contact us to find out if your business can benefit.**
I'm interested. What should I do now?
To book, please complete the appropriate booking form below:
Days & times
Tuesday 09:00 - 16:30