Excel Functions 1:

Introduction to Excel Functions
 Course Outline

DURATION 3 Hours
PREREQUISITES You need to have some Excel knowledge.  You should be familiar with what Excel is, and how to enter data into a spreadsheet.
DESCRIPTION An introduction to using Functions in MS Excel.
COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekend Sat, 11-Feb-12 09:30 - 12:30 £100.00 +VAT
Weekday Fri, 17-Feb-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 12-Mar-12 18:30 - 21:30 £100.00 +VAT
Weekday Fri, 16-Mar-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 14-Apr-12 09:30 - 12:30 £100.00 +VAT
Weekday Wed, 18-Apr-12 09:30 - 12:30 £100.00 +VAT
Weekday Fri, 11-May-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 12-May-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 11-Jun-12 18:30 - 21:30 £100.00 +VAT
Weekday Tue, 19-Jun-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 14-Jul-12 09:30 - 12:30 £100.00 +VAT
Weekday Tue, 17-Jul-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 11-Aug-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 13-Aug-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 10-Sep-12 18:30 - 21:30 £100.00 +VAT
Weekday Wed, 19-Sep-12 09:30 - 12:30 £100.00 +VAT
Weekday Thu, 11-Oct-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 13-Oct-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 5-Nov-12 18:30 - 21:30 £100.00 +VAT
Weekday Fri, 16-Nov-12 09:30 - 12:30 £100.00 +VAT
Evening Wed, 12-Dec-12 18:30 - 21:30 £100.00 +VAT
Weekday Wed, 19-Dec-12 09:30 - 12:30 £100.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £200.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

GETTING THE MOST OUT OF RANGES

  • A review of Excel's range-Selection techniques

  • Advanced Range-Selection Techniques

  • Data Entry in a Range

  • Filling a Range

  • Using the fill handle

  • Creating a Series

  • Copying a range

  • Moving a Range

  • Inserting and Deleting a Range

  • Clearing a Range

  • Using Excel's reference Operators

USING RANGE NAMES

  • Defining a Range Name

  • Working with Range Names

  • Range Names and Reference Operators

BUILDING BASIC FORMULAS
  • SUM()
  • AVERAGE()
  • MAX()
  • MIN()
  • COUNT()
  • COUNTA()
  • Understanding Formula Basics
  • Understanding Operator Precedence
  • Controlling Worksheet calculation
  • Copying and moving Formulas
  • Converting a Formula to a value
  • Working with Range names in Formulas
  • Working with Links in Formulas
  • Formatting Numbers, Dates and Times