Course Outline
Foundations of Excel
- Navigating the interface
- Data management and manipulation
- Utilizing formulas and cell references
- Chart creation
Advanced Excel Capabilities
- Applying logical functions
- Conducting scenario analyses
- Using the Solver tool
- Automating tasks with Macros
- Introduction to coding via VBA
VBA Programming
- Understanding data types
- Developing custom functions
- Program control through conditionals and loops
- Effective debugging strategies
Data Analytics using R
- Getting started with R
- Variables and data structures
- Manipulating datasets in R
- Creating reusable functions
- Visualization through ggplot
- Data cleaning and wrangling with Dplyr
Machine Learning Basics with R
- Linear Regression models
- Decision trees for classification and regression
- Advanced classification using Support Vector Machines and Random Forests
- Applying clustering methodologies
Requirements
No prior prerequisites are required for enrollment 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.
