Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

Course Basics
Introduces the user to the layout of Excel, identifying commonly used features and functions.
 Menu bar
 Ribbon
 Status bar

Spreadsheet Management
Build confidence by performing simple tasks whilst navigating through Excel.
 Creating new documents
 Saving spreadsheets
 Closing Excel

Data Management
Sorting and filtering your data to get more accurate statistics from your spread sheet.
 Sorting Data
 Subtotalling data
 Using Filters
 Freezing Panes

Formatting Excel
Changing the look and feel of spreadsheets.
 Displaying data as currency (£)
 Displaying figures as percentages (%)
 Changing cell, text and border colour

Formulas and Functions
Creating and using simple formulae to return totals from a range of data.
 Understanding simple formulas
 Using AutoSum
 Understanding Absolute Cell 

References
 Using AutoFill tools

Formula Auditing
Understanding and fixing complex spreadsheets that other users may have set up.
 Trace Precedents
 Trace Dependents
 Evaluating formulas
 Tracing errors
 Using the Watch Window

Charts
How to use your data in various chart types.
 Using the Chart Wizard
 Select appropriate chart types
 Specifying the data source
 Customising your charts

Learning Objectives

This course is aimed at giving users the confidence and knowledge to create and use Excel Spreadsheets, by the end of the course users will be able to create, amend and manipulate their own 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