The Excel Advanced course assumes that attendees have mastered the content covered in the foundation and intermediate courses. Here are a few questions and exercises. You should only join the advanced course if you can complete these exercises and answer the questions - otherwise best to book the foundation course.
You should also complete the intermediate pre-course questionnaire if you have not already done so.
This exercise covers understanding then simplifying (and therefore improving) a complex formula. Download this exercise Excel spreadsheet and follow the instructions. It should take about 30 minutes to complete.
This exercise consolidates the advanced use of the TEXTBEFORE and TEXTAFTER functions. Download this exercise Excel spreadsheet and follow the instructions. It should take about 30 minutes to complete.