コース概要
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
要求
- An understanding of data analysis concepts
- Familiarity with spreadsheet applications (Excel, Google Sheets, etc.)
Audience
- Data analysts
お客様の声 (5)
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.
Ian - Archeoworks Inc.
コース - ArcGIS Fundamentals
Lab exercise
Tse Kiat - ST Engineering Training & Simulation Systems Pte. Ltd.
コース - Automated Monitoring with Zabbix
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
コース - QGIS for Geographic Information System
私はパブロのスタイル、レポートのデザイン、HTML によるカスタマイズからシンプルな ML アルゴリズムの実装まで、多くのテーマをカバーしている点が気に入りました。Go理論情報と演習のバランスも取れています。パブロは私が興味を持っているすべてのトピックを実際にカバーし、私の質問に包括的に答えてくれました。
Cristian Tudose - SC Automobile Dacia SA
コース - Advanced Data Analysis with TIBCO Spotfire
Machine Translated
Actual application of spotfire and all basic functions.