Get in Touch

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 ranges

Data Manipulation

  • Creating pivot tables
  • Combining formulas with conditions
  • Comparing lists
  • Finding duplicates

Data Visualisation and Statistical Analysis

  • Scatter plots, correlation, and regression
  • Histograms and bar charts
  • Descriptive statistics and ANOVA
  • Paired tests, F-tests, and Z-tests

Troubleshooting

Summary and Next Steps

Requirements

  • A foundational understanding of data analysis concepts.
  • Familiarity with spreadsheet applications such as Excel, Google Sheets, and others.

Audience

  • Data analysts.
 14 Hours

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories