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 (7)
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
The trainers flexibility, showing us everything we needed for our work, but also teaching the basics and giving some very good tips. Saadoon and Mateen were great!
Ana Vicente - CSMART - Carnival
Course - QGIS for Geographic Information System
A lot of patience
Mateusz - WestWind Energy Polska Sp. z o.o.
Machine Translated
Professional and very practical, usuefull in a daily work
Jozefin Rékasi - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
I liked Pablo's style, the fact that he covered a lot of subjects from report design , customization with html to implementing simple ML algortithms. Good balance theoretical information / exercices. Pablo really covered all topics i was interested in and gave comprehensive answers to my questions.
Cristian Tudose - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
It covered the areas i said i was interested in before the course: data relationships, using python script. Connecting to databases will be covered in the advanced module.
Cristian Tudose - SC Automobile Dacia SA
Course - Introduction to Spotfire
Good teaching skils, good knowledge of the subjekts