Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- LibreOffice Calc vs Microsoft Excel vs Google Sheets for government
- Overview of LibreOffice Calc features and advantages for government operations
Getting Started
- Installing LibreOffice for government use
- User interface, spreadsheets, and workbooks in a government context
- Basic functions and formulas in Calc tailored for government applications
Data Cleaning and Validation
- Common operations and syntax for data management in government
- Filtering, sorting, and consolidating data to meet government standards
- Defining specific data formatting in cells to ensure compliance with government regulations
- Combining data from multiple cell ranges for comprehensive government reporting
Data Manipulation
- Creating pivot tables to enhance data analysis for government projects
- Combining formulas with conditions to streamline government workflows
- Comparing lists to identify discrepancies and ensure accuracy in government data
- Finding duplicates to maintain integrity in government datasets
Data Visualization and Statistical Analysis
- Scatterplot, correlation, and regression analysis for government research
- Histogram and bar graphs to visualize government data trends
- Descriptive statistics and ANOVA for detailed government reports
- Paired test, F-test, and Z-test for robust statistical validation in government studies
Troubleshooting
Summary and Next Steps
Requirements
- A comprehension of data analysis principles
- Proficiency with spreadsheet software (Excel, Google Sheets, etc.)
Audience for Government
- Data analysts in public sector roles
14 Hours
Testimonials (3)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
The thing I liked the most about the training was the organization and the location
