Get in Touch

Course Outline

Foundations of Excel

  • Navigating the interface
  • Manipulating data
  • Working with formulas and cell references
  • Creating charts

Advanced Excel

  • Logical functions
  • Scenario analysis
  • Solver
  • Macros
  • Introduction to code: VBA

Visual Basic for Applications (VBA)

  • Data types
  • Writing a function
  • Program control: conditional evaluation and loops
  • Debugging techniques

Data Analytics with R

  • Introducing R
  • Variables and data 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 prerequisites required to attend this course.

 42 Hours

Testimonials (7)

Related Categories