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 can be either 2003 or 2007, and is 2003 by default.
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