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
Requirements
- An understanding of data analysis concepts
- Familiarity with spreadsheet applications (Excel, Google Sheets, etc.)
Audience
- Data analysts
Testimonials (5)
Dużo cierpliwości
Mateusz - WestWind Energy Polska Sp. z o.o.
Course - ArcGIS for Spatial Analysis
The trainer adapted the materials and contents to what he thought would be best for us and he succeeded. The quality of the training was excellent.
Jorge Sanchez Hernandez - CSMART - Carnival
Course - QGIS for Geographic Information System
Profesional dan sangat praktis, berguna dalam pekerjaan sehari-hari
Jozefin Rékasi - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
Machine Translated
Ini mencakup bidang yang saya katakan saya minati sebelum kursus: hubungan data, menggunakan skrip python. Menghubungkan ke database akan dibahas dalam modul lanjutan.
Cristian Tudose - SC Automobile Dacia SA
Course - Introduction to Spotfire
Machine Translated
I genuinely enjoyed the lots of labs and practices.