Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back



Course type


Cost per individual

£150 +VAT
Public course

Cost per course

£495 +VAT
Client site, max 10 individuals


1 Day

Full/Part time

Part Time


ITS SmartStyle Training

Dates and Locations

28/10/2019 Liverpool
31/10/2019 Bradford
05/11/2019 Bradford
11/12/2019 Bradford

Book course

This course is intended for users who need to be able to create, edit and format Excel spreadsheets, including creating basic calculations and formulae.

Objectives: By the end of the course users will be able to produce a variety of spreadsheets, use formatting tools and page setup techniques to display and print spreadsheets effectively. Users will also be able to create simple calculations and use basic Excel functions.

Prerequisites: Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close.

Download Outline (PDF)

Spreadsheet Basics
  • Spreadsheet Concepts
  • Exploring the Excel Window
  • Working with the Ribbon & Commands
Navigating, Selecting & Entering Data
  • Creating, Saving & Closing Spreadsheets
  • Opening an Existing Spreadsheet
  • Moving Around a Spreadsheet
  • Entering, Editing & Deleting Data
  • Using AutoFill & Flash Fills
  • Creating Custom Lists
Editing Data, Columns & Rows
  • Inserting & Navigating Worksheets
  • Inserting & Deleting Rows & Columns
  • Adjusting Column Widths & Row Heights
  • Using Cut, Copy & Paste
  • Formatting Text & Sizes
  • Changing Cell Alignment
  • Changing Number & Date Formats
  • Adding Shading & Borders
Basic Formulae & Functions
  • Using Formulas to Add, Subtract, Divide & Multiply Numbers
  • Using the AutoSum Function
  • Working with Relative & Absolute Cell References
Data List Essentials
  • Introducing Data Lists
  • Freezing Worksheet Titles
  • Sorting A List of Data
  • Filtering Data using AutoFilter
Page Setup & Printing
  • Using Print Preview
  • Change Page Layouts
  • Changing & Applying Print Options

Book a course

Fill in your information to book this course. The information you provide on this booking form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here