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 (3)

Related Courses

Related Categories