libre office

Goals


- Know the main features of LibreOffice Calc

- Be able to create and modify tables with LibreOffice

Program

Presentation of Calc
Various components of LibreOffice: description and presentation
Functional comparisons with Microsoft Office Excel
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, the mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Use styles
Create, modify, delete a style

Layout Page
breaks
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations
Use of a referring cell ($)

Basic formulas
Date and time functions
Text formulas

Sorting, sorting options
Automatic
filters Custom filters

Select data
Choose a chart type as needed
Insert title, legend, data labels
Modify values
Modify chart type

Insert subtotals
Create and modify a pilot table
Validate data
Consolidate

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

No

Reference

BUR106-F

Sessions

Contact us for more informations about session date