ALX Training / Excel / Excel – Formulas and Functions III

Audience

For individuals who work with text or date fields in their spreadsheets and need to clean or manipulate these text fields.

Outcomes

To clean Excel data by writing and troubleshooting text and date formulas.

Course Content

LEFT, RIGHT, MID functions
FIND, SEARCH, CONCATENATE & LEN functions
WORKDAY, NOW, TODAY, NETWORKDAYS functions
EDATE, EOMONTH

Duration

3 hours with lots of hands-on practical exercises

Prerequisites

Must be familiar with the principles of writing basic formulas

Price

£435 including the hire of 8 laptops

Includes

All training spreadsheets for future practice
Full-colour booklet to accompany the lesson

Download Course Info Here