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
the trainer was very good and made the training perfect for my needs
Florentin - Brenda TSATSU, EXPERIS
Search and Analytics with Amazon OpenSearch Course
The training materials.
Mona Dobre - Oana Panceaa, DB Global Technology
SQL Advanced level for Analysts Course
That the trainer provide alot of materials , files and reference to return to them later once need and for self study .
Abdulrahman E. Al Qahtani, Saudi Azm for Communication and Information Technology Co
SQL Advanced level for Analysts Course
Got to know new features in OS which I wasn't aware before.
Dhivyalakshmi Ponnusamy - Mercedes-Benz AG
Search and Analytics with Amazon OpenSearch Course
Patience of the trainer while making sure everyone understand the lesson
Yeo Yu Xin - Ministry of Defence, Singapore
Python for Data Analysis Course
It's very hands-on and I can follow despite the lack of calculus background.
Wei Pin Ho - Ministry of Defence, Singapore
Python for Data Analysis Course
Very hands-on practice, engaging and good amount of breaks in between. Thus did not feel tired/lethargic.
Charles Lim - Ministry of Defence, Singapore
Python for Data Analysis Course
Trainer develops training based on participant's pace
Farris Chua
Data Analysis in Python using Pandas and Numpy Course
Doing the exercises. I really enjoyed the practicals.
Warren Stephen - Quidco
Elasticsearch for Developers Course
Marcin knew exactly what he talking about and had proper hands on in-depth experience with the tools. He had answers to all our questions and made some really strong recommendations that we could start working towards with future projects and uses.
Conor Glasman - Quidco
Elasticsearch for Developers Course
I thought the training was very thorough and while we covered a lot of material, Martin made ample time for questions and gave good focus to each individual and their different requirements.
Jeán Thysse - Quidco
Elasticsearch for Developers Course
His deep knowledge about the subject
MATLAB Fundamentals, Data Science & Report Generation Course
Exercises on time series modeling
Teleperformance
Data Analytics With R Course
That we have used our own data as examples
Glycom A/S
Data Analysis in Python using Pandas and Numpy Course
customized, in-house file processing and data analysis
Glycom A/S
Data Analysis in Python using Pandas and Numpy Course
Overall the Content was good.
Sameer Rohadia
A practical introduction to Data Analysis and Big Data Course
presentation of technologies
Continental AG / Abteilung: CF IT Finance
A practical introduction to Data Analysis and Big Data Course
good overview, good balance between theory and exercises
Proximus
Data Analysis with Hive/HiveQL Course
It was a very practical training, I liked the hands-on exercises.
Proximus
Data Analysis with Hive/HiveQL Course
The way the trainer made complex subjects easy to understand.
Adam Drewry
Data and Analytics - from the ground up Course
learning how to use excel properly
Torin Mitchell
Data and Analytics - from the ground up Course
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Kamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Data and Analytics - from the ground up Course
Liked very much the interactive way of learning.
Luigi Loiacono
Data Analysis with Hive/HiveQL Course
Willingness to share more
Balaram Chandra Paul
A practical introduction to Data Analysis and Big Data Course
I get answers on all my questions.