Course Outline
Excel Fundamentals
- Interface navigation and basics
- Techniques for manipulating data sets
- Utilizing formulas and cell addressing
- Chart creation and design
Advanced Excel Capabilities
- Implementing logical functions
- Conducting scenario-based analysis
- Utilizing the Solver tool
- Developing and managing Macros
- Introductory programming concepts via VBA
VBA Programming
- Understanding data structures and types
- Constructing custom functions
- Program flow control through conditionals and loops
- Applying effective debugging strategies
Analytics with R
- Overview of the R ecosystem
- Handling variables and data types
- Data processing and transformation in R
- Developing reusable functions
- Generating visualizations with ggplot
- Data cleansing and manipulation using Dplyr
Machine Learning Foundations in R
- Applying Linear Regression
- Using Classification and regression trees
- Classification algorithms including Support Vector Machines and Random Forests
- Exploring clustering methodologies
Requirements
No prior specific prerequisites or technical background is 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.