Description
COURSE OBJECTIVE:
This online Excel course introduces a range of counting and text
functions. You will discover how to count records that meet specific
criteria and manipulate text information in order to clean, combine, and
analyse data more efficiently.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheet formulae.
PREREQUISITES:
Participants should be able to perform the following tasks without
assitance:-
• Create formula using basic function such as SUM, AVERAGE etc
• Fix a cell reference within a formula (absolute cell referencing)
To gain these skills we recommend that you attend the folloiwng course
first:-
Excel Understanding Formula to learn basic formula & functions)
CONTENT
• Counting functions:
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
• Text functions
- LEFT
- RIGHT
- MID
- CONCAT
- TEXTJOIN
- TRIM
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
