Course Outline
Core Excel Competencies
- Interface navigation
- Data entry and manipulation
- Formula application and cell referencing
- Chart creation
Advanced Excel Functions
- Logical function implementation
- What-if scenario analysis
- Solver optimization tool
- Automation via macros
- Initial exposure to VBA coding
Visual Basic for Applications (VBA)
- Variable data types
- Custom function development
- Program control: conditional logic and iterative loops
- Code debugging strategies
Data Analytics Using R
- Overview of the R environment
- Variables and data structures
- Data manipulation techniques
- Function creation
- Statistical graphics with ggplot
- Data processing using Dplyr
Introduction to Machine Learning with R
- Linear regression models
- Classification and regression trees (CART)
- Support Vector Machines and Random Forests for classification
- Unsupervised clustering methods
Requirements
There are no eligibility requirements for government professionals seeking to participate in this course.
Testimonials (7)
Very practical
Deenan - Vodacom
Course - Data and Analytics - from the ground up
I really was benefit from the real life practical examples.
Wioleta
Course - Data and Analytics - from the ground up
I mostly liked the patience of Tamil.
Laszlo Maros
Course - Data and Analytics - from the ground up
Tamil is very knowledgeable and nice person, I have learned from him a lot.
Aleksandra Szubert
Course - Data and Analytics - from the ground up
Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.
Justin Roche
Course - Data and Analytics - from the ground up
The way the trainer made complex subjects easy to understand.
Adam Drewry
Course - Data and Analytics - from the ground up
Learning how to use excel properly.