Excel Level 2 Ninjas - 15/3/22 (PM) & 16/3/22 (PM)

To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting.

Making 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 multiple worksheets and workbooks

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.

Advanced formatting

How to save time using special number formats and working with functions to format text.

Outlining and subtotals

Learn the amazing benefits of using Outlining on large lists of data and how to consolidate data to see totals by category and how to create subtotals quickly and easily.

Cell and range names

See the advantages of creating and using range names in your spreadsheets and how to manage them.

Tables

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.

Delegates should have completed Excel Secrets Level 1 course or have equivalent experience. If you are not sure what level knowledge/experience you have please contact us to complete a free Training Needs Analysis.

Delivery: Online (live)
Level: Intermediate
Certification:
Exam Required
Voucher Incuded
Accredited
Guaranteed Pass
Practice test
On-site exam
Course Dates : 15/3/22 (PM) & 16/3/22 (PM)
Day & Time:
Week Days
Weekend
Daytime
Evening
What is included:
VAT
Breakfast
Lunch
Refreshments
Digital courseware
Digital Recording
Printed courseware
Accommodation
Extra revision sessions
Training Instructor accredited by: Microsoft (MCT)
Starts: March 2022

Public discussion (0)

You must log in to send a new comment.