By the end of the web workshop delegates will have a better understanding of Excel and be able to:
- Understand formulas and functions, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
- Convert, sort, filter, and manage lists
- Pivot tables
- Create graphs and charts, and how to modify them
- Use hyperlinks
Guidance notes and will be provided to support this web workshop and certificates of attendance are awarded after the workshop.