LibreOffice Calc for Data Analysis Training Course
LibreOffice Calc serves as the spreadsheet application within the LibreOffice suite. It is a free, cross-platform alternative to Microsoft Excel, offering comprehensive capabilities for advanced data analysis.
This instructor-led live training (available online or onsite) is designed for data analysts looking to leverage LibreOffice Calc for a wide range of analytical tasks, from basic to advanced levels, utilizing functionalities comparable to those found in Excel and other spreadsheet tools.
Upon completion of this training, participants will be able to:
- Install the LibreOffice suite across any operating system.
- Gain a thorough understanding of the full feature set and functionalities available in LibreOffice Calc.
- Master the techniques for cleaning, validating, manipulating, and visualizing data within Calc.
- Utilize various Calc functions and tools to execute complex data analysis projects.
- Acquire valuable tips and insights for conducting advanced data analysis.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practice sessions.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- For requests regarding customized training for this course, please contact us to arrange details.
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 ranges
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
- A foundational understanding of data analysis concepts
- Familiarity with spreadsheet applications such as Excel or Google Sheets
Audience
- Data analysts
Open Training Courses require 5+ participants.
LibreOffice Calc for Data Analysis Training Course - Booking
LibreOffice Calc for Data Analysis Training Course - Enquiry
LibreOffice Calc for Data Analysis - Consultancy Enquiry
Testimonials (2)
Doing Exercise
Joe Pang - Lands Department, Hong Kong
Course - QGIS for Geographic Information System
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.
Course - ArcGIS Fundamentals
Upcoming Courses
Related Courses
Advanced Alerting and Automation with Grafana and Prometheus
14 HoursThis instructor-led live training in Greece (online or onsite) targets advanced DevOps and SRE professionals aiming to enhance their alerting and automation skills with Grafana and Prometheus.
By the end of this training, participants will be able to:
- Create and manage advanced alerting rules in Prometheus.
- Integrate Prometheus Alertmanager with external tools using webhooks.
- Automate responses to alerts for faster issue resolution.
- Use Grafana to visualize and manage alerts effectively.
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in Greece (online or onsite) is aimed at field ecologists and conservation managers who wish to create data spatial projects in ArcGIS.
By the end of this training, participants will be able to:
- Output spatial data as visualizations.
- Conduct geostatics on actual data.
- Implement spatial data analysis, data processing, and mapping with ArcGIS.
- Analyze spatial data for projects in ArcGIS.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in Greece (online or onsite) targets GIS professionals and analysts from beginner to advanced levels who aim to learn how to effectively utilize ArcGIS for data visualization, spatial analysis, and geospatial project management.
By the end of this training, participants will be able to:
- Navigate and leverage ArcGIS tools for geospatial data management.
- Design and tailor maps using layers and attributes.
- Execute advanced spatial analysis and geoprocessing operations.
- Streamline workflows through ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis instructor-led, live training in Greece (online or onsite) is aimed at beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, addressing any anomalies or failures effectively.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise.
- Gain skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master the techniques for backup, recovery, and performance optimization.
ArcGIS Fundamentals
14 HoursThis instructor-led live training in Greece (online or onsite) is designed for beginner-level professionals who wish to learn the fundamental concepts and tools of ArcGIS.
By the end of this training, participants will be able to:
- Understand the basic concepts of GIS and spatial data.
- Navigate the ArcGIS interface.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Create maps and visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus represents the advanced tier of the ArcGIS Pro suite, providing expanded capabilities for geospatial data analysis, 3D modeling, process automation, and enterprise-level collaboration.
This instructor-led live training, available either online or onsite, is designed for intermediate GIS professionals aiming to enhance their expertise in spatial data analysis, automation, and sharing through the use of ArcGIS Professional Plus tools.
Upon completion of this course, participants will be equipped to:
- Utilize ArcGIS Pro Plus tools to enhance data visualization and analytical outcomes.
- Develop sophisticated 2D and 3D maps employing advanced symbology and geoprocessing methods.
- Streamline workflows through ModelBuilder and Python scripting.
- Seamlessly integrate ArcGIS with external data services and enterprise systems.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practical application.
- Hands-on implementation within a live-lab environment.
Customization Options
- For tailored training needs, please contact us to arrange a customized session.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in Greece (online or onsite) is aimed at advanced-level GIS professionals who wish to use ArcGIS Pro to enhance their spatial analysis capabilities, conduct comprehensive geostatistical analysis, and apply advanced 3D modeling techniques for more effective decision-making and problem-solving in real-world scenarios.
By the end of this training, participants will be able to:
- Develop advanced skills in spatial analysis techniques using ArcGIS Pro.
- Utilize Python scripting for automation and complex data processing.
- Apply spatial modeling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the dynamic energy landscape, merging electrical transient analysis with accurate geographic information has become a strategic imperative. At present, depending on disjointed data sources introduces considerable operational risks. This intensive 14-day course, held in Melbourne, aims to close the divide between electrical engineering principles and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led live training, available in Greece (online or onsite), is designed for intermediate-level geographers who wish to deepen their expertise in spatial analysis, data management, and GIS applications.
By the end of this training, participants will be able to:
- Apply advanced spatial analysis techniques to solve complex geographical problems.
- Manage large spatial databases and perform data quality control.
- Create dynamic and interactive maps and visualizations for various applications.
- Utilize programming and automation to streamline GIS workflows.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era offers a practical overview of how digital transformation is reshaping products, operations, and customer engagement within the insurance sector.
This instructor-led live training, available either online or onsite, targets intermediate-level insurance professionals seeking to understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernize their insurance offerings and operational processes.
By the end of this training, participants will be able to:
- Explain the role of AI, Big Data, IoT, and automation in modern insurance workflows.
- Identify InsurTech trends and how they affect the insurance ecosystem.
- Design customer-centric strategies enabled by digital tools and data insights.
- Apply data-driven approaches to risk management and decision making.
- Develop an innovation and change management approach suitable for insurers.
- Assess real-world case studies and translate lessons into local initiatives.
Format of the Course
- Interactive lecture and discussion.
- Case study analysis and group workshops.
- Practical exercises and action planning for participants’ organizations.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
IREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursRequirements Engineering (RE) plays a pivotal role in software and systems development, concentrating on identifying, documenting, and managing stakeholder needs and constraints to guarantee project success.
This instructor-led, live training (available online or onsite) targets intermediate-level professionals aiming to deepen their grasp of practical Requirements Engineering while preparing for the IREB CPRE – Foundation Level certification exam.
After completing this training, participants will be capable of:
- Understanding and applying the core concepts and terminology outlined in the IREB CPRE Foundation syllabus.
- Identifying and eliciting requirements using effective and context-appropriate techniques.
- Modeling, documenting, and validating requirements for real-world projects.
- Managing requirements changes, traceability, and prioritization throughout the project lifecycle.
- Leveraging Requirements Engineering tools and best practices to enhance communication and project outcomes.
- Being fully prepared to take and pass the IREB CPRE – Foundation Level certification exam.
Course Format
- Interactive lectures and discussions.
- Case-based exercises and collaborative workshops.
- Exam preparation sessions and practice questions.
Customization Options
- Additional modules or industry-specific case studies can be added upon request.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led live training in Greece (online or onsite) is designed for beginner-level professionals in earth sciences and engineering who wish to apply Python for geospatial analysis in ArcGIS and QGIS environments.
By the conclusion of this training, participants will be able to:
- Acquire Python syntax and control structures to execute geospatial tasks efficiently.
- Utilize Pandas, Numpy, and Matplotlib for data analysis and visualization in GIS.
- Manipulate and analyze vector data using Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows via Python scripting in ArcGIS and QGIS.
- Develop custom Python-based geoprocessing tools for ArcGIS and QGIS to streamline tasks.
QGIS for Geographic Information System
21 HoursA Geographic Information System (GIS) is a framework engineered to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The term GIS is occasionally used to denote Geographic Information Science (GIScience), referring to the academic field dedicated to the study of geographic information systems, which constitutes a significant area within the broader discipline of geoinformatics.
QGIS operates as a Geographic Information System (GIS) application, enabling users to analyze and edit spatial data, as well as design and export graphical maps. It supports both raster and vector layers; vector data is stored in the form of points, lines, or polygons. The software accommodates various raster image formats and offers georeferencing capabilities. In essence, it empowers users to create, edit, visualize, analyze, and publish geospatial information across Windows, macOS, Linux, and BSD platforms.
In its initial phase, this program introduces the QGIS interface for general application. During the second phase, we delve into PyQGIS—the Python libraries of QGIS—which facilitates the integration of GIS functionalities into your Python code or applications, potentially allowing you to develop custom Python plugins around specific GIS features.
Requirements Analysis
21 HoursThis instructor-led, live training in Greece (online or in-person) is aimed at individuals who wish to understand requirements analysis and to conduct it efficiently and accurately using analysis techniques for their projects.
By the end of this training, participants will be able to:
- Identify different types of requirements.
- Understand the overall concepts and activities within requirements analysis.
- Be familiar with the requirements analysis methodology.
- Use different requirements analysis techniques to their advantage.
- Structure requirements to communicate efficiently with architects and developers via an iterative requirement gathering process.