Étiquette : Intermediate

Apply a watermark
Set a page color
Apply a border to the page

Define the type of document (classic, book, booklet)
Choose and customize the margins
Specify the size of the sheets and the orientation
Include predefined headers and footers
Insert the company logo
Add page numbering
Modify the format page numbers
Customize headers and footers
Insert page breaks
Split your document into several sections

Define the pages to print
Configure the printer options
Print your document

Workshop: Create a layout for printing a book

Insert a table (define a number of rows and columns)
Manage the table layout (add / remove cells)
Apply a style to its table
Merge or split cells

Insert and customize a picture
Embed an inline picture
Add shapes to your document
Using WordArt
Add a SmartArt
Create and customize a graphic

Workshop: Enrich your document with several illustrations

Split paragraphs into columns
Configure spaces between these columns
Display a separator line

Prepare Word to manage your templates
Use existing templates
Get a template from Office.com
Create a custom template

Insert and configure a table of contents
Update its table of contents
Insert a footnote
Add citations
Insert captions to illustrations
Add a table of illustrations
Define entries in the index
Insert the index table and put it up to date

Workshop: Integrate several reference tables into your document

Define the type of mail merge (label, envelope, letter, etc.)
Select the source of recipients
Prepare your mail merge template
Customize the document
Finish and merge

Workshop: Prepare a standard letter for several recipients

Manage comments
Enable track changes
Compare two Writer documents

Customize a toolbar
Create a new toolbar

Revisions on Writer
Questions / Answers
Passing the PCIE certification

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

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

The available display modes
Show / hide cells
Zoom
Fix cells

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

Presentation of Impress and the other tools of the LibreOffice / OpenOffice suite
Examples of implementation with Impress

Description of the interface (Menu, Toolbars)
Structure of a file (slide shows, sections, slides)
Create a new slide show
Use of slide show templates

Add / remove slides Slide
layouts
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Insert tables
Use the FontWork gallery
Embed a diagram
Insert audio and video
Organize inserted content

Animating content
Personalizing your animation
Timing of animations (start, duration, delay)
Transitions between slides
Timing of transitions

Launching the slide show mode
The other display modes
Inserting header and footer
Adding comments
Managing the slide master

Revisions on Impress
Questions / Answers
Passing the PCIE certification