Excel Ninjas (Level 2)

Overview

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

Classroom Training – Public courses are available or we can come to you.

Online Training

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
detail at:

Cost

£300 + VAT

Learn to

  • You’ll get the upper hand by knowing how to create a table in one click so you can easily sort and filter your data.
  • Take your charting skills to a professional level by learning how to use 5 key types of charts and manipulate them to show off your data!
  • How to save time using special number formats and working with functions to format text.
  • We’ll show you how to use multiple workbooks and link them to save replication and keep data up to date. You’ll also learn the magic of 3-D formulas.
  • Tired of creating the same documents over and over again? Learn how to simply create templates you can use repeatedly.
  • Learn the benefits of Pivot Tables and feel like a Jedi Master of Excel!
  • How to save time using special number formats and working with functions to format text.
  • See the advantages of creating and using range names in your spreadsheets and how to manage them.

Hands-on exercises

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

  • Excel Gurus Level 3
  • Excel Business Intelligence Level 4
  • Excel Dashboards Level 5