MS Excel Intermediate Course. The MS Excel Intermediate Course will take what you learnt in the beginner's course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginner's course. If you are someone who is new to the workforce, you, too, will find that employers are looking for candidates with at least intermediate Excel skills. The course teaches students how to use functions, including AVERAGEA, AVERAGEIF, AVERAGEIFS and ABS. You will also learn data validation information and students work through several modules, each of which are focused on a type of data validation, such as date, list, and time. Learn from the best! Our Microsoft Excel Intermediate Certificate - Now £28. Sign up now.