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.
Testimonials (7)
Very practical
Deenan - Vodacom
Course - Data and Analytics - from the ground up
I really was benefit from the real life practical examples.
Wioleta
Course - Data and Analytics - from the ground up
I mostly liked the patience of Tamil.
Laszlo Maros
Course - Data and Analytics - from the ground up
Tamil is very knowledgeable and nice person, I have learned from him a lot.
Aleksandra Szubert
Course - Data and Analytics - from the ground up
Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.
Justin Roche
Course - Data and Analytics - from the ground up
The way the trainer made complex subjects easy to understand.
Adam Drewry
Course - Data and Analytics - from the ground up
Learning how to use excel properly.