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 have been working with spreadsheets created by others and now need to be able to build their own spreadsheets and create automated calculations using formulae and functions.

Objectives: 

By the end of the course users will be able to create spreadsheets, which include simple calculations, as well as use some of the popular functions, such as Sum, Min, Max, Average and Count. They will also be able to create calculations containing multiple operators with the effective use of brackets and understand the importance of Relative and Absolute cell references when copying formulae. 

Prerequisites: 

Users must be able to create simple spreadsheets and be able insert and delete columns and rows and apply basic text and number formatting.

Download Outline (PDF)

 

Revision
  • Navigating, Selecting & Entering Data
  • Entering Data with AutoFill
  • Undo Errors
  • Modifying Column Widths & Row Heights
Basic Formulae & Functions
  • Introducing the Formula Bar
  • Entering Simple Calculations
  • Moving & Copying Formulae
  • Absolute & Relative Cell Referencing
AutoSum & Statistical Functions
  • Introducing Functions
  • Adding Numbers with AutoSum
  • Circular References & Errors
  • Creating Statistical Functions
    • Sum
    • Average
    • Min
    • Max
    • Count
IF Functions & Percentages
  • What is an IF Function?
  • Creating an IF Function
  • Calculating Percentages

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.