Course Outline
Excel Essentials
- Interface navigation
- Data manipulation
- Formulas and cell addressing
- Charting and visualization
Advanced Excel
- Logical functions
- Scenario analysis
- Solver applications
- Macro creation
- Introduction to coding with VBA
VBA Programming
- Understanding data types
- Defining functions
- Program flow control: conditionals and loops
- Debugging strategies
Data Analytics with R
- Overview of R
- Variables and data types
- Manipulating data in R
- Function development
- Visualization with ggplot
- Data wrangling using Dplyr
Machine Learning Foundations with R
- Linear Regression
- Decision trees for classification and regression
- SVM and Random Forest classification
- Clustering methods
Requirements
No prior experience or specific prerequisites are required to join this session.
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.