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
- Comparison of LibreOffice Calc, Microsoft Excel, and Google Sheets for government use
- Overview of key features and advantages of LibreOffice Calc in the public sector
Getting Started
- Installation process for LibreOffice for government operations
- User interface components, including spreadsheets and workbooks for government tasks
- Basic functions and formulas in Calc for efficient data management for government use
Data Cleaning and Validation
- Common operations and syntax for data cleaning in government datasets
- Filtering, sorting, and consolidating data to enhance accuracy for government reports
- Defining specific data formatting in cells to ensure consistency for government records
- Combining data from multiple cell ranges to streamline information for government analysis
Data Manipulation
- Creating pivot tables for comprehensive data summarization for government purposes
- Combining formulas with conditions to perform complex calculations for government projects
- Comparing lists to identify discrepancies and ensure data integrity for government use
- Finding duplicates to maintain clean and reliable datasets for government operations
Data Visualization and Statistical Analysis
- Creating scatterplots, correlation analyses, and regression models for insightful data visualization for government studies
- Generating histograms and bar graphs to represent data distributions for government presentations
- Conducting descriptive statistics and ANOVA tests to analyze data trends for government reports
- Performing paired tests, F-tests, and Z-tests to assess statistical significance for government research
Troubleshooting
Summary and Next Steps
Requirements
- An understanding of data analysis concepts for government use.
- Familiarity with spreadsheet applications (such as Excel, Google Sheets).
Audience
- Data analysts in the public sector
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
