The Excel Intermediate course assumes that attendees have attended the foundation course. Here are a few questions and exercises. Please have a go and see how far you can get with these exercises but don’t worry if you can’t complete everything. If on the other hand you don’t know where to start on these then it may be best to book the foundation course.
This exercise consolidates several Excel skills: looking up data, and summarising data with pivot tables and/or formulas. Download this exercise Excel spreadsheet and follow the instructions. It should take about 30 minutes to complete.
This exercise covers writing formulas and using functions such as the IF and MAX functions. Download this exercise Excel spreadsheet and follow the instructions in the Introduction sheet. It should take about 30 minutes to complete.