Microsoft Excel - Expert
In this course we will cover:
- Overview of the Excel environment and browser view options
- Reminder of data validation and lists
- Use the XLOOKUP function with a range of arguments
- Apply advanced data validation with named ranges
- Perform conditional operations with combinations of IF, AND, OR and NOT
- Perform conditional calculations using COUNTIF(S), SUMIF(S) and AVERAGEIF(S)
- Create and edit Pivot tables and charts
- Record and run a basic macro
You can gain Employability Points by attending this event.
Attendance data will be shared with the Employability Points Scheme.
For further information, please see Privacy Statement