Goals
- Know the main Calc tools
- Be able to perform calculations and use formulas
- Know how to handle diagrams and data tools
Program
Presentation of Calc and the other tools of the LibreOffice / OpenOffice suite
Examples of implementation with Calc
Description of the interface (Menu, Toolbars)
Structure of a file (workbooks, sheets and cells)
Create a workbook
Adding a sheet to the workbook
Rename a sheet
Move a sheet (on the same workbook or in another)
Identify a sheet using a tab color
The different ways to select cells
Insert rows and columns
Change the height and width of rows / columns
Format the content of a cell (font, colors …)
Apply borders
Manage alignment in a cell
Merge several cells
Use the predefined styles
Create and manage a custom style
Workshop: Making a simple painting
The formula bar
Addition, subtraction, multiplication, division
The value of parentheses
Applying a calculation to an entire column
Duration
2 days
Price
£ 2495
Audience
All
Prerequisites
Knowledge of the PC environment
Reference
BUR1124-F
Manage the page layout (margins, header and footer, etc.)
Scale your table
Manually manage page breaks
Define a print area
Define print options then print
Manage the display in your workbook
Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )
Workshop: Production of a summary document with the main formulas
Create named areas and integrate them into formulas
Find antecedents and dependents to formulas
Check formulas for errors
Apply a sort on one or more columns
Modify the sort options
Apply filters on a table
Use special filters
Select the data to integrate into the diagram
Choose a type of diagram according to needs (histogram, curve, sector in 2D or 3D)
Add additional information to the diagram (title of axes, data labels, etc.) Apply updates from a table to associated diagrams
Change the type of diagram
Customize the visual of its diagram
Workshop: Generate a diagram according to your needs
Apply conditional formatting
Integrate subtotals into a table
Ungroup or consolidate a spreadsheet
Manage data validity
Find a target value
Use the solver
The principle of a pilot table
Define which calculation and label fields will be
Select the source and destination of its pilot table
Place the fields to be analyzed
Configure the options
Workshop: Highlight the desired statistics from your table
Adding and modifying comments
Enable tracking of changes
Protect your workbook and sheets
Reviews on Calc
Questions / Answers
Passing the PCIE certification
Passing of the certification (if foreseen in the financing).
Sessions
Contact us for more informations about session date