Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per individual

£150 +VAT
Public course

Cost per course

£495 +VAT
Client site, max 10 individuals

Duration

1 Day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

09/01/2019 Bradford
17/01/2019 Barnsley
21/01/2019 Doncaster
21/01/2019 Liverpool
25/01/2019 Mansfield
01/02/2019 Bradford
13/02/2019 Liverpool
08/03/2019 Barnsley
11/03/2019 Liverpool
20/03/2019 Bradford
05/04/2019 Mansfield
17/04/2019 Doncaster
18/04/2019 Bradford
16/05/2019 Liverpool
24/05/2019 Barnsley
31/05/2019 Bradford
14/06/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
  • 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