Course description
Welcome to the Ninja Course! In the Ninja One Day training session you will take the next steps in your Microsoft Excel learning journey. In this session you will expect to 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 to make amazing tables in one click with secret built in formula. You’ll learn how to speed up navigation around your spreadsheet.
Upcoming start dates
Suitability - Who should attend?
Who is this for?
This TWO HALF 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.
Training Course Content
- 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.
Reviews
Average rating 4.8
Pivot Tables
Shortcuts
Slicers
Flash fill
Column split
The slicers and ctrl 8 function
Trace Precedents/Trace Dependents and Slicers