Get in Touch

Course Outline

Fundamental Excel Skills

  • Navigation and interface mastery
  • Data entry and manipulation techniques
  • Utilizing formulas and cell references
  • Creating and formatting charts

Advanced Excel Capabilities

  • Implementation of logical functions
  • Conducting scenario analysis
  • Using the Solver add-in
  • Automating tasks with Macros
  • Introduction to VBA programming for government operations

VBA Programming

  • Understanding data types
  • Developing custom functions
  • Program control via conditional statements and loops
  • Essential debugging methods

Data Analytics with Python

  • Overview of the Python language
  • Variables and data typing fundamentals
  • Data manipulation using the Pandas library
  • Function creation and implementation
  • Visualizing data with Matplotlib and Seaborn for government reporting
  • Advanced data wrangling techniques with Pandas

Introduction to Machine Learning with Python

  • Linear Regression implementation using scikit-learn
  • Classification and Regression Trees (CART) in Python
  • Classification methods: Support Vector Machines and Random Forests
  • Clustering algorithms utilizing scikit-learn

Requirements

No prerequisites are required for individuals seeking to participate in this training program for government personnel.
 42 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories