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
- Comparing LibreOffice Calc with Microsoft Excel and Google Sheets
- Key features and advantages of LibreOffice Calc
Getting Started
- Installing LibreOffice
- Navigating the user interface, spreadsheets, and workbooks
- Mastering basic functions and formulas in Calc
Data Cleaning and Validation
- Essential operations and syntax
- Filtering, sorting, and consolidating data
- Setting specific data formats for cells
- Merging data from multiple cell ranges
Data Manipulation
- Creating and managing pivot tables
- Combining formulas with conditional logic
- Comparing data lists
- Identifying duplicate entries
Data Visualization and Statistical Analysis
- Scatterplots, correlation, and regression analysis
- Generating histograms and bar graphs
- Calculating descriptive statistics and performing ANOVA
- Executing paired tests, F-tests, and Z-tests
Troubleshooting
Summary and Next Steps
Requirements
- A solid understanding of data analysis concepts.
- Prior familiarity with spreadsheet applications such as Excel or Google Sheets.
Target 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.
