Excel Functions 3:

Dates & Text 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 it’s calculations.
DESCRIPTION You will learn how to deal with special characters in Excel, how to change case, change the way text is displayed, remove unwanted characters from a string and extract part of a string.  You will also learn how to manipulate dates by pulling out parts of dates, or working out the difference between dates.

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

  • Working with Characters and Codes

    • The CHAR() Function

    • The CODE() Function

  • Converting Text

    • The Lower() Function

    • The Upper() Function

    • The Proper() Function

    • Formatting Text

  • Manipulating Text

    • Removing Unwanted Characters from a String

    • The REPT() Function:  Repeating a Character

    • Extracting a Substring

  • Case Study

    • Generating Account Numbers

    • Searching for Substrings

    • Substituting One Substring for Another

WORKING WITH DATE AND TIME FUNCTIONS

  • How Excel Deals with Dates and Times
    • Entering Dates and Times
    • Excel and Two-Digit Years
  • Using Excel's Date Functions
    • Returning a Date
    • Returning Parts of a Date
    • Calculating the Difference Between Two Dates
  • Using Excel's Time Functions
    • Returning a Time
    • Returning Parts of a Time
    • Calculating the Difference between Two Times
  • Case Study
    • Building an Employee Time Sheet