Basic Excel Session 3 - Data Searching Editing Extraction

Price:
R345.00 (VAT Incl.)
Level:
Business Professionals
Sub-level:
Microsoft Excel and Word
Lecturer:
Tristan David-Crewe White
Duration:
90 Minutes
Additionals:
   CPD Assessment
   Certificate

Lesson Outline


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

• 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.
• Data Extraction (basic):
o Flash fill
o Text-to-Columns
o Concatenate.