Course Outline
Foundations of Excel
- Interface navigation
- Data handling and manipulation
- Utilizing formulas and cell references
- Chart creation
Advanced Excel Capabilities
- Application of logical functions
- Scenario analysis techniques
- Optimization using Solver
- Macro development
- Introduction to programming with VBA
Programming with VBA
- Data type management
- Function creation
- Program control via conditionals and loops
- Debugging methods
Data Analytics using R
- Introduction to the R environment
- Variables and data types
- Data manipulation workflows
- Developing custom functions
- Data visualization through ggplot
- Data wrangling utilizing Dplyr
Machine Learning Foundations in R
- Linear Regression models
- Classification and regression trees
- Classification using Support Vector Machines and Random Forests
- Clustering methodologies
Requirements
No prior specific knowledge or prerequisites are required 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.
