Get in Touch
 Duration 42 hours

Course Outline

Excel Fundamentals

  • Interface navigation and basics
  • Techniques for manipulating data sets
  • Utilizing formulas and cell addressing
  • Chart creation and design

Advanced Excel Capabilities

  • Implementing logical functions
  • Conducting scenario-based analysis
  • Utilizing the Solver tool
  • Developing and managing Macros
  • Introductory programming concepts via VBA

VBA Programming

  • Understanding data structures and types
  • Constructing custom functions
  • Program flow control through conditionals and loops
  • Applying effective debugging strategies

Analytics with R

  • Overview of the R ecosystem
  • Handling variables and data types
  • Data processing and transformation in R
  • Developing reusable functions
  • Generating visualizations with ggplot
  • Data cleansing and manipulation using Dplyr

Machine Learning Foundations in R

  • Applying Linear Regression
  • Using Classification and regression trees
  • Classification algorithms including Support Vector Machines and Random Forests
  • Exploring clustering methodologies

Requirements

No prior specific prerequisites or technical background is required to participate in this course.

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories