Microsoft Excel Level 2 Training Course
Unleash the power of your spreadsheets with our bespoke Excel training courses.
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 of attending this course…
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.
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.
Duration
1 Day
Classroom or Online
Classroom Learning
Up to 3 Delgates for £425 + VAT *
Additional delegates £105 + VAT each.
The maximum class size is 6.
We train at your premises within 15 miles of Bristol, or further afield and off-site at additional cost.
Let us quote you. You’ll be pleasantly surprised!
Online Learning
Up to 3 Delgates for £400 + VAT *
Additional delegates £95 + VAT each.
The maximum class size is 6.
Training is instructor-led in a live online session.
* Special prices available for abridged courses, small groups, individuals and bulk bookings.
Please contact us for a quote.
