Get in Touch

Course Outline

Excel Fundamentals

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

Advanced Excel 

  • Logical functions
  • Scenario planning
  • Solver applications
  • Macro development
  • Introduction to programming with VBA

VBA Programming

  • Data types
  • Creating functions
  • Program control via conditionals and loops
  • Debugging strategies

Analytics with R

  • Overview of R
  • Variables and data types
  • Manipulating data in R
  • Function authoring
  • Visualizing data with ggplot
  • Data wrangling using Dplyr

Foundations of Machine Learning in R

  • Linear Regression
  • Classification and regression trees
  • Classification via Support Vector Machines and Random Forests
  • Clustering methods

Requirements

No prior prerequisites are required to participate in this course.

 42 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories