Microsoft Excel Level 2 Training Course
- Training Courses
- IT Toolkit & Microsoft
- Microsoft Excel Level 2 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
Regular User – This level is aimed at existing users who want to get more out of Excel and hone their skills further.
- Exploring more Excel functions (such as SUMIF, SUMIFS, AVERAGEIF, COUNTIF, AND, OR, NOT and SUBTOTAL).
- Applying formulae to text data (e.g. to convert text to upper or lower-case or to extract part of a text string).
- Using dates within formulae (e.g. to calculate a due date).
- ‘Nesting’ functions to perform more complex tasks.
- Working with Named Ranges to simplify navigation and formulae.
- Using Multiple Worksheets and referencing cells on other sheets.
- When to use Absolute, Relative and Mixed cell addressing.
- Hiding and Protecting data (including security considerations).
- Using Conditional Formatting to highlight key cells.
- Creating hierarchical data structures with Outlines.
- Working with data lists (including Sorting and using AutoFilters).
- Working with Pivot Tables and Pivot Charts (including customising the layout and changing what’s displayed).
- Adding a quick filter to a Pivot Table with Slicers.
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 2 Training Course Course?
Real change starts with a conversation.
Request Classroom Learning For
Microsoft Excel Level 2 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.
