Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

This course is aimed at basic Excel users who want to up their skills by mastering the more challenging (and rewarding) features of Excel. Our course covers the use of formula help tools to find and write formulae. We show you how to confidently nest functions and to analyse data. We teach you how to use rules to automatically format data to alert you (conditional formatting) and how to create a Table format to run totals. Topics covered include Working with multiple worksheets, Naming Cells and Ranges, Extending your Function Toolbox, Working with Data, Tables and Conditional Formatting.

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

Sessions can be run online or in person, on your site or at our London training centre.
We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £525 + VAT.

Learning Objectives

Course Outline:

Revision
•	A quick review of common statistical functions, MIN, MAX, and AVERAGE
•	Working with absolute cell references

Worksheets
•	Using the Group feature
•	Hiding and Unhiding worksheets within a workbook
•	Locking cells and protecting entire sheets
•	Creating a 3-D formula
•	Creating a summary sheet using internal links

Naming Cells/Ranges
•	Create and edit cell names and ranges
•	Use names within a formula

Extending your Function Toolbox
•	Creating formula with SUMIFs and COUNTIFs, VLOOKUP and XLOOKUP

Working with Data
•	Learn multiple techniques to filter your data to display the required results
•	Use the Subtotal command to create a quick summary
•	Group and Ungroup columns and rows.

Tables
•	Organise your content into attractive and responsive tables
•	Filter with slicers

Conditional Formatting
•	Apply conditional formatting to visually display conditions such as above and below average values

Funding Option

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

Learners will require access to a laptop with an internet connection and access to the relevant software to enrol on this course.

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

I accept the Terms and Conditions and Privacy Policy

NoYes