On this course we'll start by showing you how to use grouping and auditing tools, and how to setup advanced filters and work with tables. The course will build on your existing skills using formula, and will show you methods to insert and use nested functions. We end the course covering ways to setup advanced conditional formatting and show you how to get proficient with PivotTables!
1 day (5 to 6 hours approx).
Learners should have some experience using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course.
Learners will receive user-friendly course notes for future reference.
The course is delivered using Microsoft Excel Office 365. We can provide training using other versions of Microsoft Excel on request.
Learners who complete the course will receive the following e-Certificate: EC-PC Microsoft Excel Proficient User. The certificate may be used as evidence of CPD depending on the requirements of the learner’s profession.
The course can be delivered at locations throughout the UK including: Aberdeen, Dundee, Edinburgh, Glasgow, Inverness, Perth, Stirling, Birmingham, London, Manchester, Reading, Slough.
Please contact us for a quote.