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 course

£495 for any two half-day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

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

Objectives:

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

Prerequisites:Download Outline (PDF)

Revision of Excel Basics
  • Entering, Navigating & Selecting Data
  • Working with Columns & Rows
Formatting Spreadsheets
  • Formatting Text & Sizes
  • Changing Cell Alignment
  • Changing Number & Date Formats
  • Applying Background Shading & Cell Borders
  • Copying Formats using Format Painter
Basic Formulae & Functions
  • Using Formulas to Add, Subtract, Divide & Multiply Numbers
  • Using the AutoSum Function
  • Statistical Functions:
    • Average
    • Minimum
    • Maximum
    • Count
Page Setup & Printing
  • Using Print Preview
  • Changing Page Layouts
  • Changing & Applying Print Options

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application 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.