Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

Formulas
Shows the user how to action the more enhanced commonly used formulas.
 VLOOKUP formula
 IF Logical Tests
 Nested IF Formulas
 SUMIF formula
 COUNTIF formula
 AVERAGEIF Formula

Formatting Cells
Quick ways to professionalise your cells formatting and appearance.
 Conditional Formatting
 Format Painter Tool
 Data Validation

Working with Data
Effective ways of working with sets of Data in Excel.
 Using Named Ranges
 Formatting data using Tables
 Creating Dynamic Expanding 
Ranges

Excel with other programs
Shows the functions of other programs through excel.
 Linking multiple excel workbooks
 Embedding word documents
 Embedding PDF files

Protection
Restrict the formatting and editing of your spread sheets by users.
 Read Only
 Restricted editing options
 Password protection
 Splitting Windows

Pivot Tables
Creating, editing and understanding the Pivot Table tool in Excel.
 Understanding Pivot Tables
 Creating Pivot Tables
 Modifying data and refresh data
 Creating Pivot Charts

Learning Objectives

This course is aimed at users who have completed the Introduction E-Learning or are an experienced user currently creating and using Excel within their role. By the end of the course users will be able to use features including sort, filters, PivotTables and Linking Spreadsheets.

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

Pre course questionnaires available to assess delegates level if required.

Key advantages
Flexibility Delegates decide when and where. 

Tailored training - Learn and perfect the areas you need. Delegates choose the topics they wish to cover. 

Self-paced – Delegates can take their time and learn at their own pace. Re-cover topics at any time to refresh their memory. 

Knowledge retention - Using different media and examples eLearning will help delegates retain their new skills with the ability to quickly refresh if needed. 

Ready to work on any device - Anywhere with an internet connection will get you access.

Each of our paid courses comes with our full support, if you get stuck, want to check your understanding or require any additional information, our team are here to help!

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

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill