Excel Tutor - Cyprus

Useful Functions

This lesson explains a number of useful functions. The following areas are covered:
1. Functions used in Working with lists. These include COUNT, COUNTA, VLOOKUP and Left VLOOKUP functions using MATCH and INDEX functions;
2. Logical Functions. These include IF, AND, OR and NOT Functions;
3. Text manipulation Functions. These include PROPER, UPPER, LOWER, LEN, TRIM, LEFT, RIGHT, MID and FIND.
4. Functions to manipulate numbers. These include ROUND, INT, ABS, CEILING, FLOOR, and MOD.
5. Sundry Functions. These include RAND and INDIRECT functions.
6.  Date and Time Functions. These include NOW, TODAY, YEAR, MONTH, DAY, WEEKDAY, DATE, DATEDIF, NETWORKDAYS, and WORKDAY.. An explanation is also made on how Excel stores dates and times, and how we can manipulate these values.

Useful Functions - Examples


The two examples below show how functions can be combined into a single formula to produce useful values. In the first example the MID and FIND functions are used to extract the account code from a text stream. In the second example, the INDEX and MATCH functions are used to find the Customer Name from a list.

The example below show some formulas that make various calculations with times. Note that the times should be formatted as [h]:mm (Format/Cells/Number/Custom) so that the totals produced will be correct (in case they exceed 24 hours). If you want a more advanced example you can download the file "Timesheet" found in the Download Page.

Home | Who Am I? | My Training Program and Examples

| Downloads | Links | Contact