You’ll cover manipulating multiple files and worksheets, 3D formulas, linking cells and editing links; special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Make amazing tables in one click with secret built in formula; You’ll learn how to speed up navigation around your spreadsheet and use range names in formula; using the auditing features to check your work and protect your spreadsheet. We take a look at useful built in templates and how you can use them and finish with a first look at Pivot Tables and Charts.
Duration 1 day
Ways to attend
Online Training – by appointment
Please call us on 01952 581 550
Who is it for?
This course is specifically designed for office staff/managers with some previous knowledge of Excel, and is designed to take you to the next level. Mistakes can be reduced if you use the tools that come with Excel and check your work. This course will cover essential time-saving features and will look in
£300 + VAT
Hands-on exercises and demonstrations help you gain in-class practice creating engagement programs. Take-home your very own Microsoft Certified Manual to help extend your learning beyond the class as you apply what you have learned back in your job.
Suggested follow-on courses
Looking for other topics?