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 6 hour course will be run online via Zoom / Microsoft Teams over the following dates and times:
Wednesday 12 August 2020 - 10am - 12pm and 2pm - 4pm (4 hours in total)
Thursday 13 August 2020 - 10am - 12pm (2 hours)
Prior knowledge and / or experience of Microsoft Excel 2016 is desirable.
Access to a PC or Laptop is essential due to the delivery method of this course
West Suffolk College certificate of attendance.
Further course detail
The Microsoft Excel 2016 Intermediate course will cover the following topics:
Wednesday 12 August 2020 - 10am - 12pm
- Multiple File Arrangement
- 3D Cell Formulas
- Multiple Book Formulas
- Named Ranges
- Paste Special
Wednesday 12 August 2020 - 2pm - 4pm
- Conditional Logic (which includes)
- If / And
- If / Or
- Nested If
- Sum Conditions (which includes)
- Conditional Formatting (which includes)
- Data Bars
- Icon Sets
Thursday 13 August 2020 - 10am - 12pm
- Data Validation
- Lookup Functions (which includes)
- VLookup / HLookup
- Index & Match
- Cell Comments
- Date / Time Functions (which includes)
- Left / Right / Mid
Will I have to provide anything?
PC or Laptop to access online training
I'm interested. What should I do now?
To book, please complete the appropriate booking form below:
Days & times