The core knowledge needed to effectively use formulas in Excel, removing complexity & redundancy is presented in this lecture. Many potential participants would assume that this course is beneath them and that they understand the subject area it covers, but most users will find new information available to them in this course.

It is suitable for those who need to improve their technical knowledge and as a revision for those who want to focus on the finer points. Participants should be familiar with Excel and comfortable working with formulas and functions such as IF, SUM, COUNT, SUMIF, VLOOKUP, IFERROR..