Get in Touch
 Duration 42 hours

Course Outline

Foundational Spreadsheet Proficiency

  • Interface navigation and layout
  • Data management and modification techniques
  • Formula construction and cell referencing
  • Chart creation and data visualization

Advanced Spreadsheet Applications

  • Logic-based functions
  • What-if scenario analysis
  • Optimization using Solver tools
  • Macro development and automation
  • Introduction to programming: Visual Basic for Applications (VBA)

Visual Basic for Applications (VBA)

  • Data type definitions
  • Function creation and structure
  • Program flow control: conditional statements and iterative loops
  • Error detection and debugging methods

Data Analytics Using R

  • Overview of the R programming environment
  • Variable assignment and data typing
  • Data processing and transformation in R
  • Development of custom functions
  • Statistical visualization via ggplot2
  • Data summarization and manipulation with Dplyr

Machine Learning Foundations in R

  • Linear regression modeling
  • Classification and regression trees (CART)
  • Advanced classification: Support Vector Machines and Random Forests
  • Unsupervised clustering methodologies

Requirements

No prior technical proficiency or specific pre-requisites are required to participate in this training program.

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories