Microsoft Excel Level 3 Training Course
- Training Courses
- IT Toolkit & Microsoft
- Microsoft Excel Level 3 Training Course
Unleash the power of your spreadsheets with our bespoke Excel training courses.
Course Description
Our training courses for Excel will help you produce quality spreadsheets with the minimum of effort. They cover practical tasks that will help you get more out of the package and increase your productivity. All of our courses are fully customisable, so you can focus on developing the Excel skills that are most important to you.
Benefits
Microsoft Excel is a powerful tool for creating spreadsheets in order to manage and analyse data in almost any way. Whilst it’s relatively easy to grasp the basics you will soon discover there’s a lot more to learn! Our courses are designed to help you master the key features of Excel so you can create high-quality spreadsheets with far less effort.
Who Is It For?
Our courses are aimed at anyone who wants to develop practical Excel skills and increase their productivity at work.
Course Content
Advanced User – This level is aimed at experienced users who really want to push the boundaries and develop their Excel skills even further.
- Important spreadsheet design considerations (to improve integrity and make them easier to use and maintain).
- Working with data in ‘Tables’ to aid visual clarity and make summary formulae easier to understand.
- Using Data Validation rules to control user input.
- Using Array formulae to improve integrity and assist auditing.
- Using the Formula Auditing tools and the ‘Watch Window’ to check formulae integrity and to experiment with outcomes.
- Creating Scenarios to store multiple values in cells and analyse several outcomes.
- Handling errors using the ISERROR and IFERROR functions.
- Using VLOOKUP to find key values in a list or to compare lists.
- Using INDEX, MATCH and XLOOKUP to overcome some of the shortcomings of VLOOKUP.
- Using custom numerical formats (to format values as thousands or millions, for example).
- Setting-up and using Custom Views to save and re-use specific screen and print settings (such as zoom factor and print area).
- Creating and saving Custom Charts (such as a combined axis charts or one with a Trendline).
- Customising the Quick Access Toolbar and Ribbon.
- Creating a keystroke Macro.
Bespoke Content
- If you want to mix subjects from two (or more) levels we can do that.
- If you want to focus on specific areas within a level we can also do that.
- If you want to use your own exercises (or suggest extra subjects) then we can usually do that too!
Find out more in our training brochure
Looking to arrange a group training course?
- We are able to offer competitive pricing schemes for various group sizes.
Scheme
Group size
Price
Per delegate
Scheme 1
Up to 4 delegates
£795 + VAT
£199 per head
Scheme 2
Up to 8 delegates
£995 + VAT
£125 per head
Scheme 3
Up to 12 delegates
£1,250 + VAT
£105 per head
Ready to begin our Microsoft Excel Level 3 Training Course Course?
Real change starts with a conversation.
Request Classroom Learning For
Microsoft Excel Level 3 Training Course
Your custom is important to us.
Please get in touch if you need to clarify anything or would like further details about any of our courses.
