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
  14 Hours
 

Testimonials

Related Courses

Automated Monitoring with Zabbix

  14 hours

Databricks

  14 hours

Data Cleaning

  7 hours

Datadog Monitoring

  7 hours

Netdata

  7 hours

Zenoss Monitoring for Administrators

  21 hours

Fluentd for Log Data Unification

  14 hours

KNIME Analytics Platform for BI

  21 hours

Microsoft Power Platform Fundamentals

  14 hours

Monitoring Your Resources with Munin

  7 hours

Nagios

  35 hours

Nagios Core

  21 hours

Nagios XI Administration

  21 hours

Sensu: Beginner to Advanced

  14 hours

SPSS Modeler

  14 hours