office logo

Goals


- Know how to use a table in Excel

- Generate a standard document in Word

- Create simple presentations with PowerPoint

- Manage your mail with Outlook

Program

- EXCEL -

Presentation of Excel 2013
Description of the ribbon
Workbook / worksheet operation
Move around in the workbook (using the keyboard, menus, mouse)

Choice of font
Color of text and background
Borders, patterns
Alignment in the cell
Merge cells
Format of numbers and dates
Cell properties

AutoFormat
Insert and delete rows and columns
Change the height and width of rows and columns
Select cells

The formula bar
Addition, subtraction, multiplication, division, exponent
Use of parentheses
Percentage format
Automatic formulas
Copy calculations

Layout of a table
Management of page breaks
Define a print area Print
preview
Print

Duration

3 days

Price

£ 2495

Audience

Office users

Prerequisites

Knowledge of the PC environment

Reference

BUR1016-F

- WORD -

Introducing Word 2013
Description of the ribbon
The ruler
Windows
Display mode
Show / hide formatting marks

Create
Open, save, close
Use recent documents
Create a document based on a template
Save a document in Word 97-2003 format

Select text
Move around in the document
Move and duplicate text
Find a character string
Perform a deep search
Replace one string with another
Use automatic spell checking
Replace formatting

The styles for a layout
Add, modify, delete a Style

How to use themes?
Mix themes

Design Resize
Insert, move or delete a row
Insert, move or delete a column
Define formatting and wrapping
Retrieve a table from Excel

Margins
Orientation Page
numbering
Borders
Custom header or footer
Modify the format of page numbers
Use « print preview »
Printing

-- POWER POINT --

PowerPoint 2013 presentation
Description of the ribbon
Create a new slide show
Using slide show templates
Set a theme for your presentation

Add / remove slides Slide
layouts
Move a slide

Placeholders
Inserting and formatting text
Inserting and customizing shapes
Inserting and modifying images
Inserting tables
Using WordArt
Organizing inserted content

Animate a content
The timing of the animations (start, duration, delay)
Transitions between slides

- OUTLOOK -

Overview of Outlook 2013
Description of the ribbon
General principles of e-mail operation
Differences between POP, IMAP and SMTP

Inbox management
Sending an email
Integrating an attachment
Activating the follow-up of an email
Spam management Organize
and classify your emails

Creation of a calendar
Event management (addition, modification, deletion)
Change the display mode
Find an appointment

Manually add a contact
Fill in essential information
Modify / delete a contact
Import a contact list
Change the display mode
Find a contact

Sessions

Contact us for more informations about session date