Advanced Excel Training (Microsoft Office 2007/ 2010/2016)

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.***

Course Content

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.  

Objectives

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  

Assessment

No formal assessment

Car Parking

Available on site

Refreshments

Buffet lunch and Teas / coffees provided.

Contact

To make a booking please complete the booking form and return to Emma Codd via email: emma@hgta.org - thank you!