Course Outline
Foundational Spreadsheet Proficiency
- Interface navigation and layout
- Data management and modification techniques
- Formula construction and cell referencing
- Chart creation and data visualization
Advanced Spreadsheet Applications
- Logic-based functions
- What-if scenario analysis
- Optimization using Solver tools
- Macro development and automation
- Introduction to programming: Visual Basic for Applications (VBA)
Visual Basic for Applications (VBA)
- Data type definitions
- Function creation and structure
- Program flow control: conditional statements and iterative loops
- Error detection and debugging methods
Data Analytics Using R
- Overview of the R programming environment
- Variable assignment and data typing
- Data processing and transformation in R
- Development of custom functions
- Statistical visualization via ggplot2
- Data summarization and manipulation with Dplyr
Machine Learning Foundations in R
- Linear regression modeling
- Classification and regression trees (CART)
- Advanced classification: Support Vector Machines and Random Forests
- Unsupervised clustering methodologies
Requirements
No prior technical proficiency or specific pre-requisites are required to participate in this training program.
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.