Get in Touch

Course Outline

Essential Excel

  • Interface navigation
  • Data management and modification
  • Utilizing formulas and cell references
  • Chart creation

Advanced Excel 

  • Logic-based functions
  • Scenario modeling
  • Solver tool application
  • Macro development
  • Introduction to coding: VBA

VBA

  • Data type concepts
  • Developing custom functions
  • Program flow control: conditionals and loops
  • Error identification and resolution

Data Analytics using R

  • Overview of R
  • Variables and data types
  • Data processing in R
  • Function creation
  • Visualizing data with ggplot
  • Data cleaning using Dplyr

Foundations of Machine Learning in R

  • Linear Regression models
  • Decision trees for classification and regression
  • Classification via Support Vector Machines and Random Forests
  • Clustering algorithms

Requirements

No prior specific requirements are necessary to join this course.

 42 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories