Data and Analytics – from the ground up Training Course

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