Please access the new Skills for Learning website at Please note this site is no longer being updated and will be removed by 2021.

Workshops / Get Help | A-Z Index | Publications | Printable Guides | Media Library | Staff

Intermediate Excel

Outcomes: This workshop is aimed at students who are already familiar with using Excel and provides students with an understanding of more advanced features of Excel. The workshop covers: naming cell and range; using functions such as IF, SUMIF, AVERAGEIF, and VLOOKUP; building pivot tables; and using what-if analysis.