Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Basic Excel
- Navigation
- Manipulating data
- Working with formulas and addresses
- Charts
Advanced Excel
- Logical functions
- Scenario analysis
- Solver
- Macros
- First glimpse of code: VBA
VBA
- Data types
- Writing a function
- Controlling a program: conditional evaluation and loops
- Debugging techniques
Data Analytics with R
- Introducing R
- Variables and types
- Data manipulation in R
- Writing functions
- Data visualization 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
There are no specific requirements needed to attend this course.
Testimonials
real life practical examples
Wioleta (Vicky) Celinska-Drozd
The patience of Kamil.
Laszlo Maros
First session. Very intensive and quick.
Digital Jersey
Kamil is very knowledgeable and nice person, I have learned from him a lot.
Aleksandra Szubert
Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.
Justin Roche
The way the trainer made complex subjects easy to understand.
Adam Drewry
learning how to use excel properly
Torin Mitchell
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Kamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Related Courses
SPSS Modeler
14 hours
Databricks
14 hours
Data Cleaning
7 hours
Sensu: Beginner to Advanced
14 hours
Automated Monitoring with Zabbix
14 hours
Fluentd for Log Data Unification
14 hours
Nagios Core
21 hours
Nagios
35 hours
Nagios XI Administration
21 hours
Advanced Nagios
21 hours
Zenoss Monitoring for Administrators
21 hours
Netdata
7 hours