Course Outline

Basic Excel for Government

  • Navigation within the application
  • Manipulating and organizing data
  • Utilizing formulas and cell addresses
  • Creating and customizing charts for government reports

Advanced Excel for Government

  • Using logical functions to enhance data analysis
  • Conducting scenario analysis for informed decision-making
  • Utilizing Solver for optimization problems
  • Developing and utilizing macros for efficiency
  • Introduction to coding with VBA for automation tasks

VBA for Government Applications

  • Understanding data types in VBA
  • Writing custom functions to streamline processes
  • Controlling program flow with conditional statements and loops
  • Implementing debugging techniques for reliable code

Data Analytics with R for Government

  • Introduction to the R programming language
  • Managing variables and data types in R
  • Manipulating and cleaning data using R
  • Writing functions to automate data processing tasks
  • Creating advanced visualizations with ggplot for government reports
  • Efficient data manipulation using the Dplyr package

Introduction to Machine Learning with R for Government

  • Implementing linear regression models for predictive analysis
  • Utilizing classification and regression trees for decision support
  • Applying Support Vector Machines and Random Forests for classification tasks
  • Exploring clustering techniques for data segmentation

Requirements

There are no specific prerequisites required to participate in this course for government.

 42 Hours

Number of participants


Price per participant

Testimonials (7)

Upcoming Courses

Related Categories