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

Number of participants



Price per participant

Testimonials (5)

Related Courses

ArcGIS for Spatial Analysis

14 Hours

ArcMap in ArcGIS

14 Hours

ArcGIS Pro for Spatial Analysis

14 Hours

ArcGIS with Python Scripting

14 Hours

QGIS for Geographic Information System

21 Hours

Advanced Data Analysis with TIBCO Spotfire

14 Hours

Introduction to Spotfire

14 Hours

AI-Driven Data Analysis with TIBCO Spotfire X

14 Hours

Data Analysis with SQL, Python and Spotfire

14 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 Certified Administrator Preparation

21 Hours

Advanced Nagios

21 Hours

Related Categories

1