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

SPSS Modeler

  14 hours

Databricks

  14 hours

Microsoft Power Platform Fundamentals

  14 hours

PL-900T00: Microsoft Power Platform Fundamentals

  7 hours

Data Cleaning

  7 hours

Sensu: Beginner to Advanced

  14 hours

Monitoring Your Resources with Munin

  7 hours

Automated Monitoring with Zabbix

  14 hours

Fluentd for Log Data Unification

  14 hours

Nagios Core

  21 hours

Nagios

  35 hours

Nagios XI Administration

  21 hours

Advanced Nagios

  21 hours

Nagios Certified Professional Preparation

  21 hours

Nagios Certified Administrator Preparation

  21 hours