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

R850.00 incl. VAT

Out of stock

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

In this session we empower your decision-making by helping you organise using an array of formulas, filtering functionality, and 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 with sifting through copious amounts of data, turning it into logical information as well as how to make search queries that only return the 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 Thysse – chantal@capechamber.co.za

Speaker: Yvonne Rossouw

______________________________________________

Part 4: Friday, 28 February 2020

Event Details

Date: 21/02/2020

Start time: 13:00

End time: 15:00

Venue: Webinar

Phone: 021 402 4300

Email: chantal@capechamber.co.za


Category: Tags: ,