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
- Overview of LibreOffice Calc features and advantages
Getting Started
- Installing LibreOffice
- Overview of the user interface, spreadsheets, and workbooks
- Introduction to basic functions and formulas in Calc
Data Cleaning and Validation
- Common operations and syntax
- Techniques for filtering, sorting, and consolidating data
- Defining specific data formatting within cells
- Combining data from multiple cell ranges
Data Manipulation
- Creating pivot tables
- Combining formulas with conditional logic
- Comparing lists
- Identifying duplicates
Data Visualization and Statistical Analysis
- Scatterplots, correlation, and regression analysis
- Creating histograms and bar graphs
- Descriptive statistics and ANOVA
- Paired tests, F-tests, and Z-tests
Troubleshooting
Summary and Next Steps
Requirements
- A foundational understanding of data analysis concepts.
- Familiarity with spreadsheet applications such as Excel or Google Sheets.
Audience
- Data analysts.
14 Hours
Testimonials (2)
Doing Exercise
Joe Pang - Lands Department, Hong Kong
Course - QGIS for Geographic Information System
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.
