Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

This one day course will teach you the essentials of Excel and give you the skills needed by a typical spreadsheet user in business organisations today. As you apply Excel's functionality to your facts and figures, you will be able to gain new levels of insight into your business. You'll see trends over time, or by product or service. You learn how to calculate totals and other aggregation results and in short, create real information from what was only data. After attending our course, you'll be able to use Excel to help you organise, amend, calculate, analyse and present your data in ways that will help you make sense out of your plain rows and columns. Topics covered include Getting Started and Essential Skills, Data Input, Navigation and Selection Techniques, Creating Simple Formulae, Basic Functions, Workbook Structure, Formatting Data, Charts and Printing.

Team Training and Bespoke Sessions
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 £595 + VAT for the first person, plus £150 per additional person, per day.

Learning Objectives

Course Outline

Getting Started - Essential Skills
•	Understanding the Excel interface
•	Customising the Quick Access Toolbar and status bar
•	Opening, saving and closing workbooks
•	The size of a worksheet

Data Input
•	Enter text, dates, and numbers into cells
•	Use Autofill to copy data
•	Understand the difference between deleting and clearing cell contents
•	Reorganise content with sorting techniques

Navigation and Selection Techniques
•	Improve efficiency with fast techniques to navigate around and select data within worksheets

Creating Simple Formula
•	Create calculations using mathematical operators.
•	Use BODMAS
•	Work with both relative and absolute cell addresses

Basic Functions
•	Create calculations using common functions such as SUMS, MIN, MAX and AVERAGE.

Workbook Structure
•	Inserting, moving, naming, and deleting worksheets within a notebook.

Formatting Data
•	Apply formatting to text, dates and numbers.
•	Insert and delete columns and rows.
•	Adjust column widths and row height.

Charts
•	Present your data in various chart formats
•	Create, edit and manipulate charts.

Printing
•	Set your data up for output to print.
•	Include headers and footers.
•	Set specific print area

Funding Option

Funding Eligibility

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

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