Get in Touch

Course Outline

Foundations of Excel

  • Interface navigation
  • Data management and manipulation
  • Application of formulas and cell references
  • Creating charts

Advanced Excel Capabilities

  • Utilising logical functions
  • Conducting scenario analysis
  • Applying the Solver add-in
  • Creating macros
  • Introduction to programming with VBA

Programming with VBA

  • Understanding data types
  • Developing custom functions
  • Program control via conditional logic and loops
  • Debugging strategies

Data Analytics using R

  • Overview of the R environment
  • Variables and data types
  • Data manipulation workflows in R
  • Function development
  • Visualising data with ggplot
  • Wrangling data using Dplyr

Machine Learning Fundamentals with R

  • Linear Regression
  • Classification and regression trees
  • Classification using Support Vector Machines and Random Forests
  • Clustering methodologies

Requirements

No prior specific prerequisites are required to participate in this course.

 42 Hours

Testimonials (7)

Upcoming Courses

Related Categories