Building on the previous Intermediate series modules, the Excel Advanced course introduces the topics of Formula Auditing, the ‘conditional’ functions SUMIF and COUNTIF, ‘What If’ analysis, removing duplicates, and an introduction to the important topic of Macros. The course has x pages including 3 multiple choice questions and a practical exercise. You should ideally have completed all of the Excel foundation and Intermediate modules before embarking on the Advanced.
There are 15 pages including 3 multiple choice questions.
The module features videos presented by our trainer Viv Brownlee to supplement the learning on the written pages.