LibreOffice Calc for Data Analysis Training Course
LibreOffice Calc serves as the spreadsheet application within the LibreOffice software suite. It offers a free, cross-platform alternative to Microsoft Excel, delivering comprehensive capabilities for advanced data analysis.
This instructor-led live training, available either online or on-site, is designed for data analysts looking to utilize LibreOffice Calc for a wide range of analytical tasks, from foundational to sophisticated levels, by leveraging functionalities comparable to those in Excel and other spreadsheet tools.
Upon completion of this training, participants will be capable of:
- Installing the LibreOffice suite across various operating systems.
- Gaining a thorough understanding of the full range of features and functionalities in LibreOffice Calc.
- Mastering the techniques to clean, validate, manipulate, and visualize data using Calc.
- Applying diverse functions and tools within Calc to execute complex data analysis.
- Acquiring valuable tips and insights for conducting advanced data analysis.
Format of the Course
- Interactive lectures and discussions.
- Numerous exercises and practice sessions.
- Practical implementation within a live laboratory environment.
Course Customization Options
- For personalized training arrangements, please reach out to us to coordinate.
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
- 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
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in Argentina (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 Argentina (online or onsite) targets GIS professionals and analysts at beginner to advanced levels who seek to learn effective ArcGIS usage for data visualization, spatial analysis, and geospatial project management.
By the conclusion of this training, participants will be able to:
- Navigate and utilize ArcGIS tools for geospatial data management.
- Create and customize maps with layers and attributes.
- Perform advanced spatial analysis and geoprocessing tasks.
- Automate workflows using ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis live, instructor-led training session Argentina (online or in-person) is tailored for beginner-level IT support personnel seeking to provide comprehensive support for ArcGIS Enterprise, effectively addressing system anomalies and failures.
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 Argentina (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamental concepts and tools of ArcGIS.
Upon completing this training, participants will be able to:
- Grasp the core concepts of GIS and spatial data.
- Navigate the ArcGIS interface effectively.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Design maps and create visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus serves as an enhanced iteration of ArcGIS Pro, delivering extended 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-level GIS professionals seeking to advance their expertise in spatial data analysis, automation, and data sharing through ArcGIS Professional Plus tools.
Upon completion of this training, participants will be equipped to:
- Utilize ArcGIS Pro Plus tools for effective data visualization and analysis.
- Develop advanced 2D and 3D maps employing sophisticated symbology and geoprocessing methods.
- Streamline workflows through ModelBuilder and Python scripting.
- Seamlessly integrate ArcGIS with external data services and enterprise systems.
Course Format
- Engaging interactive lectures and discussions.
- Numerous practical exercises and hands-on practice.
- Real-time implementation within a live laboratory environment.
Customization Options
- For requests regarding customized training for this course, please reach out to us to coordinate arrangements.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in Argentina (online or onsite) is designed for advanced-level GIS professionals aiming to leverage ArcGIS Pro to improve their spatial analysis capabilities, perform comprehensive geostatistical analysis, and apply sophisticated 3D modeling techniques to facilitate more effective decision-making and problem-solving in practical scenarios.
Upon completion of this training, participants will be capable of:
- Developing advanced proficiency in spatial analysis techniques using ArcGIS Pro.
- Employing Python scripting to automate tasks and process complex data.
- Applying spatial modeling to address real-world challenges.
- Performing geostatistical analysis for advanced data interpretation.
- Integrating external data sources and utilizing 3D spatial data analysis.
Applied ArcGIS Pro for Remote Sensing, Spatial Data Management, and AI
21 Hours
Upon completing this training, participants will be able to:
• Process and analyze satellite images for conservation and environmental monitoring applications.
• Manage spatial data in a structured manner using geodatabases in ArcGIS Pro.
• Establish an institutional repository of geospatial information following best practices.
• Apply Artificial Intelligence tools and advanced analysis in ArcGIS Pro for remote sensing.
• Integrate efficient workflows for spatial analysis and geographic data management.
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. Currently, depending on disjointed data sources creates substantial operational vulnerabilities. This intensive 14-day course in Melbourne aims to connect the disciplines of electrical engineering with geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in Argentina (online or onsite) is designed for geographers at an intermediate level who aim to enhance their proficiency in spatial analysis, data management, and GIS applications.
Upon completion of this training, participants will be able to:
- Employ advanced spatial analysis techniques to address complex geographical challenges.
- Manage large-scale spatial databases and conduct rigorous data quality assurance.
- Develop dynamic and interactive maps and visualizations for diverse applications.
- Implement programming and automation to optimize GIS workflows.
Google Maps API for Developers
14 HoursThis instructor-led, live training in Argentina (online or onsite) is designed for developers who wish to enhance their website or web application by adding geo-location functionality through Google Maps.
By the conclusion of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchronizes with the current location.
- Create a mashup that includes Google Maps.
- Apply effective CSS and JavaScript coding practices.
- Construct a custom map for an application.
Insurance in the Digital Era
14 HoursThis course provides a practical look at how digital transformation is reshaping products, operations, and customer engagement within the insurance sector.
Designed for intermediate-level insurance professionals, this instructor-led live training (available online or onsite) focuses on helping participants understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernize their insurance offerings and operational processes.
Upon completion of this training, participants will be able to:
- Explain how AI, Big Data, IoT, and automation impact modern insurance workflows.
- Identify key InsurTech trends and their influence on the insurance ecosystem.
- Design customer-centric strategies leveraging digital tools and data insights.
- Apply data-driven approaches to risk management and decision-making.
- Develop an innovation and change management approach tailored 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) serves as a fundamental discipline in software and systems development, concentrating on the identification, documentation, and management of 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.
Upon completing this training, participants will be equipped to:
- Grasp and apply the core concepts and terminology outlined in the IREB CPRE Foundation syllabus.
- Identify and elicit requirements using effective, context-appropriate techniques.
- Model, document, and validate requirements for real-world projects.
- Manage requirements changes, traceability, and prioritization throughout the project lifecycle.
- Leverage Requirements Engineering tools and best practices to improve communication and project outcomes.
- Gain full readiness to take and pass the IREB CPRE – Foundation Level certification exam.
Format of the Course
- Interactive lectures and discussions.
- Case-based exercises and collaborative workshops.
- Exam preparation sessions and practice questions.
Course 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 Argentina (online or onsite) targets beginner-level professionals in earth sciences and engineering who wish to apply Python for geospatial analysis in both ArcGIS and QGIS environments.
Upon completion of this training, participants will be equipped to:
- Master Python syntax and control structures to efficiently execute geospatial tasks.
- Employ Pandas, Numpy, and Matplotlib for data analysis and visualization within GIS contexts.
- Manipulate and analyze vector data using Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows through Python scripting in ArcGIS and QGIS.
- Create custom Python-based geoprocessing tools for ArcGIS and QGIS to optimize task efficiency.
QGIS for Geographic Information System
21 HoursA Geographic Information System (GIS) is a framework designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The term GIS is also occasionally used to refer to Geographic Information Science (GIScience), which denotes the academic discipline studying these systems and represents a significant subfield within the broader domain of geoinformatics.
QGIS serves as a robust GIS software solution, enabling users to analyze and edit spatial information, as well as compose and export graphical maps. It supports both raster and vector layers; vector data is stored as point, line, or polygon features. The software accommodates multiple raster image formats and can georeference images. In essence, it empowers users to create, edit, visualize, analyze, and publish geospatial data across Windows, Mac, Linux, and BSD operating systems.
In its first phase, this program introduces the QGIS interface for general usage. The second phase covers PyQGIS—the Python libraries of QGIS—which allows the integration of GIS functionalities into your Python code or applications. This capability even enables you to develop custom Python plugins tailored to specific GIS functionalities.