Get in Touch

Course Outline

Core Excel Competencies

  • Interface navigation
  • Data entry and manipulation
  • Formula application and cell referencing
  • Chart creation

Advanced Excel Functions

  • Logical function implementation
  • What-if scenario analysis
  • Solver optimization tool
  • Automation via macros
  • Initial exposure to VBA coding

Visual Basic for Applications (VBA)

  • Variable data types
  • Custom function development
  • Program control: conditional logic and iterative loops
  • Code debugging strategies

Data Analytics Using R

  • Overview of the R environment
  • Variables and data structures
  • Data manipulation techniques
  • Function creation
  • Statistical graphics with ggplot
  • Data processing using Dplyr

Introduction to Machine Learning with R

  • Linear regression models
  • Classification and regression trees (CART)
  • Support Vector Machines and Random Forests for classification
  • Unsupervised clustering methods

Requirements

There are no eligibility requirements for government professionals seeking to participate in this course.

 42 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories