LibreOffice Calc - Level 1 - Introduction

Training objective: Acquire the basics of the LibreOffice Calc spreadsheet to create, format and manipulate data efficiently through simple spreadsheets. Skills acquired at the end of the training: - Master the LibreOffice Calc interface: understand spreadsheets, cells, columns and rows. - Create and manage spreadsheets: creation, saving, adding, deleting and moving sheets within a workbook. - Enter and format data: text, numbers, dates, cell formatting (fonts, colors, borders). - Use numerical formats: apply monetary, percentage and scientific formats. - Apply basic formulas and functions: SUM, AVERAGE, MIN, MAX, using absolute and relative references. - Sort, filter and search data in tables efficiently. - Create and customize charts: choose the type of chart, customize graphical elements (titles, legends, labels). - Format and print tables: adjust margins, configure page breaks, manage print preview. - Complete a project: data management, formatting, application of simple calculations and visualization in charts.

• Understand the LibreOffice Calc working environment.
• Master the creation and management of spreadsheets.
• Learn to structure, format, and manipulate data.
• Use basic functions to perform simple calculations.
• Sort, filter, and search data in a table.
• Create charts to illustrate data.
• Format and print a spreadsheet.