Plan Szkolenia
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
Wymagania
- An understanding of data analysis concepts
- Familiarity with spreadsheet applications (Excel, Google Sheets, etc.)
Audience
- Data analysts
Opinie uczestników (5)
Szkolenie prowadzone w sposób przykuwający uwagę
Karol - Centralny Ośrodek Informatyki
Szkolenie - Nagios XI Administration
Trener dostosował materiały i treści do tego, co uważał za najlepsze dla nas i udało mu się. Jakość szkolenia była doskonała.
Jorge Sanchez Hernandez - CSMART - Carnival
Szkolenie - QGIS for Geographic Information System
Przetłumaczone przez sztuczną inteligencję
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
Szkolenie - Data Analysis with SQL, Python and Spotfire
Professional and very practical, usuefull in a daily work
Jozefin Rékasi - SC Automobile Dacia SA
Szkolenie - 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.