Excel Level 2 Ninjas

Start Date 10/01/2024, 09:30 AM
End Date 11/01/2024, 12:30 PM
Where? Online

Imagine training logo for ECMS Courses

-

Imagine Training joins ECMS for a two part course in Microsoft Excel Level 2 Ninjas, split between 2 half days. The first part of the course will be delivered on Wednesday 10th January 2024 at 09:30am - 12:30pm and the second part on Thursday 11th January 2024 at 09:30am - 12:30pm. 

With 10 years experience of successfully delivering online training, Imagine Training could help you learn essential skills for business. Trainers use the internet to deliver our training courses, direct to your desktop. Electronic training manuals help you retain what you learn and you can interact with us in the session and ask questions, watching the screen on your desk instead of the projector screen in your training room.

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 condense large worksheets to see the totals you need and charting your data.  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.  

This One Day 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. 

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

Course / Webinar & Seminar delivery is supported by the ECMS.  By booking onto the short course you are agreeing to share your data with ECMS and with the Training Provider.  The ECMS will collect limited and specified personal information to enable it to deliver business support services, to comply with its funding obligations and to better understand its community so that it can meet the needs of clients with a view to continually improving services.  For further information please view the ECMS Privacy Notice (Please request a copy from ecmsenquiries@wlv.ac.uk)