Who is this course aimed at?
Advanced Excel Training - This course is designed to increase knowledge of the Microsoft Excel Program.
Do you need previous experience or qualifications to attend this course?
*** This course builds upon the Intermediate Excel course so we strongly encourage delegates to complete the Intermediate course first. The course assumes a working knowledge of more complex, nested Excel functions such as IF, AND and OR as well as the ability use named cell ranges in a VLOOKUP with confidence.***
Covers advanced chart options (inc. Scatter, Histogram, Trendline, Moving Averages, Pareto), Array formulas, statistical functions, and data consolidation. There is an open forum element to this course which allows delegates to ask work related specific questions, and to discuss solutions.
By the end of the session delegates will be able to:- • Create a wide range of analytical charts • Add descriptive statistics to worksheet data sets • Create simple array formulas • Understand and use statistical functions • Create a working timesheet • Consolidate data across worksheets
No formal assessment
Available on site
Buffet lunch and Teas / coffees provided.
To make a booking please complete the booking form and return to Emma Codd via email: email@example.com - thank you!