Price:
R345.00 (VAT Incl.)
Level:
Business Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
90 Minutes
Additionals:
R345.00 (VAT Incl.)
Level:
Business Professionals
Sub-level:
Microsoft
Lecturer:
Tristan David-Crewe White
Duration:
90 Minutes
Additionals:
CPD Assessment
Certificate
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.
• 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.