Course Outline
Foundational Excel
- Navigating the interface
- Handling and editing data
- Utilizing formulas and cell references
- Creating charts
Advanced Excel
- Applying logical functions
- Conducting scenario analysis
- Using the Solver tool
- Creating macros
- Initial exposure to programming: VBA
VBA
- Understanding data types
- Developing custom functions
- Managing program flow: conditionals and loops
- Applying debugging strategies
Data Analytics with R
- Overview of R
- Variables and their types
- Transforming data in R
- Creating functions
- Visualizing data with ggplot
- Processing data using Dplyr
Introduction to Machine Learning with R
- Linear Regression
- Classification and regression trees
- Classifying data using Support Vector Machines and Random Forests
- Applying clustering methods
Requirements
No prior knowledge or specific prerequisites are required to join 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.
