EXCEL Part 3 of 4: Data Filtering, Sorting, Searching, Editing and Extraction – CPD Webinar

R850.00 incl. VAT

50 in stock

EXCEL Part 3 of 4: Data Filtering, Sorting, Searching, Editing and Extraction – CPD Webinar

R850.00 incl. VAT

10 Discussion Points Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel is geared towards processing large amounts of data with minimal fuss.

In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulas, filtering functionality, data searching and extraction tools.

The objective of Excel Part 3 is to enable delegates to become comfortable with working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information.

• Data Editing
o Sorting
o Filtering
o Conditional formatting
o Data validation
o Subtotal formula
o Find and replace
• Data Searching
o Searching within filter
o Searching within sheet
o VLookUps
o CountIF formula
o If statements
o Basic data extraction
o Flash fill
o Text-to-Columns
o Concatenate

Certificate of 3 CPD hours issued on completion of course.

Event organiser: Chantal van Schalkwyk on 021 402 4300 or email chantal@capechamber.co.za

Speaker profile: Yvonne Rossouw

__________________________________________________________________

Part 4: Friday, 29 November 2019

Event Details

Date: 22/11/2019

Start time: 13:00

End time: 15:00

Venue: Webinar

Phone: 021 402 4300

Email: chantal@capechamber.co.za