Excel Advanced Module 6 - Database Functions, 24th May Online delivery via teams,

The Excel Advanced level covers the following module:-

• 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

Duration: 1pm - 4pm

Date: Tuesday 6th June 2023

Cost: Free to attend

Venue: Online delivery via teams

Course Delivery: This course will be delivered by Pat Jones, PS Training.

Book online using the booking form below, call 01686 628778 or email sam@mwmg.org