Microsoft Excel Advanced Level Course

Attendees should have attended, or have knowledge equivalent to the Introductory Level course.

This course is split across two sessions- Thursday 2nd September and Thursday 9th September

£65

---

Module 6 - Using the Database Functions (Session 2)

-Apply Conditional Formatting

-Applying Data Validation to ensure the correct information is entered

- Remove Duplicate Values for line of data

-Understanding the Database Functions

-Using AutoFilter to view a specific set of data

-Inserting Automatic Subtotals

-Converting Text Strings to separate columns

-Creation of Pivot Tables to display data in varying formats

-Creation and use of Vlook-up table

---

For enquiries, please do not hesitate to contact 01686668670 or e-mail mts@myrick.co.uk