kshs.20,000 | 16 Weeks
Enrollment Minimum Requirements
- Basic Computer skills
- Laptop
- Access to internet
Course Contents/Details
COURSE OUTLINE
- IF function
- SumIfS
- CountIfS
- Trim
- Concatenate
- Left / Right
- Vlookup
- Xlookup
- IfError
- Value
- Unique
- Sort
- Filter
- Linear regression using Excel
- Power Query
- Box Plots ( Q1, Q2, Q3 , Q4)
- Outlier Detection using Boxplots
- Removing noise using moving averages
- Computing Z Scores
