Using Spreadsheets

Company
With Total People
Duration
1 day (7 study hours)

Overview

Spreadsheet software is used for a range of purposes in the workplace, from simply recording financial and numerical data to carrying out complex calculations that analyse information. To meet the demands of an ever-changing workplace, individuals need to ensure they keep up to date with IT packages.

Excel is the spreadsheet package that forms part of the Microsoft Office application. It is used by many businesses and individuals for a range of purposes to store, manipulate and analyse data.

This course is for learners with prior knowledge of using spreadsheets looking to gain knowledge on advanced spreadsheet functions. The purpose of the course is to improve understanding in using the Microsoft Excel package and in particular, how to create advanced Excel spreadsheets using formulas.

Upon completion of the course, learners will be able to create their own spreadsheets and be able to manipulate data using Excel.

Couse details

This course covers the following themes:

Cell and Worksheet Protection

  • To lock and unlock a cell or cells:
  • To protect a worksheet

Conditional Formatting

  • Logical Operators

Data Validation

  • To define the data validation for a group of cells:
  • To identify any invalid values:

Mathematical Operators

  • Addition
  • Subtraction
  • Multiplication
  • Division
  • Autosum
  • Absolute Addressing

IF AND function

VLOOKUP

Automatic Subtotals

Pivot Tables

Course format

This is an online course studied via distance learning. To complete this course, learners will need access to a computer and a basic level of IT knowledge.

Studying via distance learning means learners can choose when and where they study. A dedicated Learner Support Advisor provides support to learners throughout the course.

Who is suitable?

This course is ideal for anyone looking to develop knowledge, understanding and competence in using Microsoft Excel. Learners must already have basic IT skills and basic knowledge of Microsoft Office software (Word, Excel and PowerPoint) to be able to complete the course successfully.

Full or partial funding for this course is dependent upon age, employment status and level of income. Learners must meet one or more eligibility criteria that includes:

  • Working in a small to medium sized business (less than 250 employees)
  • Living in either Greater Manchester or Lancashire
  • On a part-time or temporary contract
  • In receipt of in-work Universal Credit
  • At risk of redundancy or have recently been made redundant
  • Aged 19+

Register interest

This course is supported by funding from Skills Support for the Workforce, part of the Growth Company, and the European Social Fund.