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