Course Outline
Basic Excel
- Navigation
 - Manipulating data
 - Working with formulas and addresses
 - Charts
 
Advanced Excel
- Logical functions
 - Scenario analysis
 - Solver
 - Macros
 - First glimpse of code: VBA
 
VBA
- Data types
 - Writing a function
 - Controlling a program: conditional evaluation and loops
 - Debugging techniques
 
Data Analytics with R
- Introducing R
 - Variables and types
 - Data manipulation in R
 - Writing functions
 - Data visualization using ggplot
 - Data wrangling with Dplyr
 
Introduction to Machine Learning with R
- Linear Regression
 - Classification and regression trees
 - Classification using Support Vector Machines and Random Forests
 - Clustering techniques
 
Requirements
There are no specific requirements needed to attend 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.