Get in Touch
 Duration 42 hours

Course Outline

Excel Fundamentals

  • Navigation
  • Data manipulation
  • Utilizing formulas and cell references
  • Charting

Advanced Excel

  • Logical functions
  • Scenario analysis
  • Solver tool
  • Macros
  • Introductory coding with VBA

VBA Programming

  • Data types
  • Function creation
  • Program control: conditional logic and loops
  • Debugging methods

Data Analytics with R

  • Overview of R
  • Variables and data types
  • Data manipulation in R
  • Function development
  • Visualization with ggplot
  • Data wrangling using Dplyr

Machine Learning Introduction with R

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

Requirements

No prior requirements are necessary to join this course.

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories