Overview
LibreOffice Calc is the spreadsheet component of the LibreOffice software suite. It is a cross-platform and free alternative to Microsoft Excel, providing the full features for advanced analysis.
This instructor-led, live training (online or onsite) is aimed at data analysts who wish to use LibreOffice Calc to conduct many forms of data analysis (from basic to advanced), leveraging similar functionalities found in Excel and other spreadsheet software.
By the end of this training, participants will be able to:
- Install the LibreOffice suite on any operating system.
- Understand the full features and functionalities available in LibreOffice Calc.
- Learn how to clean, validate, manipulate, and visualize data in Calc.
- Apply the various functions and tools in Calc to perform complex data analysis.
- Gain some tips and insights on conducting advanced data analysis.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Requirements
- An understanding of data analysis concepts
- Familiarity with spreadsheet applications (Excel, Google Sheets, etc.)
Audience
- Data analysts
Course Outline
Introduction
- LibreOffice Calc vs Microsoft Excel vs Google Sheets
- Overview of LibreOffice Calc features and advantages
Getting Started
- Installing LibreOffice
- User interface, spreadsheets, and workbooks
- Basic functions and formulas in Calc
Data Cleaning and Validation
- Common operations and syntax
- Filtering, sorting, and consolidating data
- Defining specific data formatting in cells
- Combining data from multiple cell range
Data Manipulation
- Creating pivot tables
- Combining formulas with conditions
- Comparing lists
- Finding duplicates
Data Visualization and Statistical Analysis
- Scatterplot, correlation, and regression
- Histogram and bar graphs
- Descriptive statistics and ANOVA
- Paired test, F-test, and Z-test
Troubleshooting
Summary and Next Steps