Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back



Course Type


Price Per Delegate

£195 +VAT
Public Scheduled Course

Price Per Course

£695 +VAT
On-Site at Customer Premises, Max 10 Delegates


1 Day

Full/Part Time

Part Time


SmartStyle Training

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