Excel Functions 2:

Lookup & Logical Functions
 Course Outline

DURATION 3 Hours
PREREQUISITES You need to have some experience of using Excel.  You should be familiar with using Sum, Average, Count, Min, Max, as well as performing typical mathematical functions in Excel.  You should know about absolute and relative cell referencing in formulas as well as the order in which Excel performs its calculations.
DESCRIPTION Lookup and Logical Functions within Excel, namely, IF(), nesting functions, Cell(), Error.Type(), Info(), IsError(), IsNA(), VLookup, HLookup , etc

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.
Weekday Mon, 20-Feb-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 17-Mar-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 19-Mar-12 09:30 - 12:30 £100.00 +VAT
Weekday Thu, 19-Apr-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 14-May-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 16-Jun-12 09:30 - 12:30 £100.00 +VAT
Weekday Wed, 20-Jun-12 09:30 - 12:30 £100.00 +VAT
Weekday Wed, 18-Jul-12 09:30 - 12:30 £100.00 +VAT
Weekday Tue, 14-Aug-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 15-Sep-12 09:30 - 12:30 £100.00 +VAT
Weekday Thu, 20-Sep-12 09:30 - 12:30 £100.00 +VAT
Weekday Fri, 12-Oct-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 10-Nov-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 19-Nov-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 15-Dec-12 09:30 - 12:30 £100.00 +VAT
Weekday Thu, 20-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.

 

 

 

 

WORKING WITH LOOKUP FUNCTIONS

  • Adding Intelligence with Logical Functions

    • Using the IF() Function

    • Performing Multiple Logical tests

    • Combining Logical functions with Arrays

  • Building an Accounts receivable Aging Worksheet

    • Calculating a Smarter Due date

    • Aging Overdue Invoices

  • Getting Data with Information

    • The CELL() Function

    • The ERROR.TYPE() Function

    • The INFO() Function

    • The IS Functions

  • Understanding Lookup Tables

  • The Choose() Function

    • Determining the Name of the Day of the Week

    • Determining the Month of the Fiscal year

    • Calculating Weighted Questionnaire Results

    • Integrating Choose() and Worksheet Option Buttons

  • Lookup up Values in tables

    • The VLookup() Function

    • The HLookup() Function

    • Performing Range Lookups

    • Finding Exact Matches

    • Advanced Lookup Operators