Course Outline
Basic Excel
- Navigation
- Manipulating data
- Working with formulas and cell references
- Creating charts
Advanced Excel
- Logical functions
- Scenario analysis
- Solver
- Macros
- Initial exposure to code: VBA
VBA
- Data types
- Writing a function
- Program control: conditional evaluation and loops
- Debugging techniques
Data Analytics with R
- Introducing R
- Variables and types
- Data manipulation in R
- Writing functions
- Data visualisation using ggplot
- Data wrangling with Dplyr
Introduction to Machine Learning with R
- Linear Regression
- Classification and regression trees
- Classification using Support Vector Machines and Random Forests
- Clustering techniques
Requirements
No specific prerequisites are required to enrol in this course.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
