LibreOffice Calc for Data Analysis Training Course
LibreOffice Calc is the spreadsheet component of the LibreOffice software suite. It is a cross-platform and free alternative to Microsoft Excel, providing the full features for advanced analysis.
This instructor-led, live training (online or onsite) is aimed at data analysts who wish to use LibreOffice Calc to conduct many forms of data analysis (from basic to advanced), leveraging similar functionalities found in Excel and other spreadsheet software.
By the end of this training, participants will be able to:
- Install the LibreOffice suite on any operating system.
- Understand the full features and functionalities available in LibreOffice Calc.
- Learn how to clean, validate, manipulate, and visualize data in Calc.
- Apply the various functions and tools in Calc to perform complex data analysis.
- Gain some tips and insights on conducting advanced data analysis.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
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
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
Provisional Courses
Related Courses
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level to advanced-level GIS professionals and analysts who wish to learn how to effectively use ArcGIS for data visualization, spatial analysis, and geospatial project management.
By the end 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 instructor-led, live training in Poland (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 Poland (online or onsite) is aimed at 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 is an advanced version of ArcGIS Pro, offering extended features for geospatial data analysis, 3D modeling, automation, and enterprise collaboration.
This instructor-led, live training (online or onsite) is aimed at intermediate-level GIS professionals who wish to deepen their skills in spatial data analysis, automation, and sharing using ArcGIS Professional Plus tools.
By the end of this training, participants will be able to:
- Leverage ArcGIS Pro Plus tools for data visualization and analysis.
- Create 2D and 3D maps with advanced symbology and geoprocessing techniques.
- Automate workflows using ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in Poland (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.
Insurtech: A Practical Introduction for Managers
14 HoursInsurtech (a.k.a Digital Insurance) refers to the convergence of insurance + new technologies. In the field of Insurtech "digital insurers" apply technology innovations to their business and operating models in order to reduce costs, improve the customer experience and enhance the agility of their operations.
In this instructor-led training, participants will gain an understanding of the technologies, methods and mindset needed to bring about a digital transformation within their organizations and in the industry at large. The training is aimed at managers who need to gain a big picture understanding, break down the hype and jargon, and take the first steps in establishing an Insurtech strategy.
By the end of this training, participants will be able to:
- Discuss Insurtech and all its component parts intelligently and systematically
- Identify and demystify the role of each key technology within Insurtech.
- Draft a general strategy for implementing Insurtech within their organization
Audience
- Insurers
- Technologists within the insurance industry
- Insurance stakeholders
- Consultants and business analysts
Format of the course
- Part lecture, part discussion, exercises and case study group activities
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the evolving energy sector, the integration of electrical transient analysis with precise geographic data is a strategic necessity. Currently, reliance on fragmented data leads to significant operational risks. This 14-day intensive program in Melbourne is designed to bridge the gap between electrical engineering and geospatial management.
Fintech: A Practical Introduction for Managers
14 HoursIn this instructor-led, live training in Poland, participants will gain an understanding of the technologies, methods and mindset needed to implement a Fintech strategy.
This training is aimed at managers who need to gain a "big picture" understanding of Fintech, break down the hype and jargon, and take tangible first steps towards the adoption of new technologies applicable to financial business and services.
By the end of this training, participants will be able to
- Present viable Fintech strategies for their organization.
- Understand and explain the role and functionality of key technologies.
- Draft an action plan for introducing new technologies in step-by-step fashion.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at 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.
Google Maps API for Developers
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to enhance their website or web application by adding geo-location functionality through Google Maps.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchs with current location.
- Create a mashup that includes Google Maps.
- Apply good CSS and JavaScript coding practices
- Create a custom map for an application.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era is an applied overview of how digital transformation reshapes products, operations, and customer engagement in the insurance industry.
This instructor-led, live training (online or onsite) is aimed at intermediate-level insurance professionals who wish to understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernize insurance offerings and operations.
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.
Python for Geographic Information System (GIS)
21 HoursA geographic information system (GIS) is a system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS is sometimes used for geographic information science (GIScience) to refer to the academic discipline that studies geographic information systems and is a large domain within the broader academic discipline of geoinformatics.
The use of Python with GIS has substantially increased over the last two decades, particularly with the introduction of Python 2.0 series in 2000, which included many new programming features that made the language much easier to deploy. Since that time, Python has not only been utilized within commercial GIS such as products by Esri but also open source platforms, including as part of QGIS and GRASS. In fact, Python today is by far the most widely used language by GIS users and programmers.
This program covers the usage of Python and its advance libraries like geopandas, pysal, bokeh and osmnx to implement your own GIS features. The program also covers introductory modules around ArcGIS API, and QGIS toolboox.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level earth sciences and engineering professionals who wish to use Python for geospatial analysis in both ArcGIS and QGIS environments.
By the end of this training, participants will be able to:
- Learn Python syntax and control structures for executing geospatial tasks efficiently.
- Use Pandas, Numpy, and Matplotlib for data analysis and visualization in GIS.
- Manipulate and analyze vector data with Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows using 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 system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS is sometimes used for geographic information science (GIScience) to refer to the academic discipline that studies geographic information systems and is a large domain within the broader academic discipline of geoinformatics.
QGIS functions as geographic information system (GIS) software, allowing users to analyze and edit spatial information, in addition to composing and exporting graphical maps. QGIS supports both raster and vector layers; vector data is stored as either point, line, or polygon features. Multiple formats of raster images are supported, and the software can georeference images. To summarize it allows the users to Create, edit, visualise, analyse and publish geospatial information on Windows, Mac, Linux, BSD.
This program, in its first phase, introduces the QGIS interface for general usage. In the second phase, we introduce PyQGIS - the python libraries of QGIS that allows the integration of GIS functionalities in your python code or your python application, so that you may even create your own Python Plugin around a particular GIS functionality.