world

Goals


- Navigate in the explorer

- Discover the Internet and emails

- Know the basics of Office tools (Word, Excel, PowerPoint)

Program

Presentation of Excel and the other tools of the Office suite
Examples of realization with Excel

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
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
Apply a cell format

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

Workshop: Creation of a personalized style and application on a board

Insert pictures (local or online)
Add and edit shapes
Insert organization chart

Define the application area
Use the predefined rules
Modify an existing rule
Create a new rule
Apply to an entire table

The formula bar
Addition, subtraction, multiplication, division
The value of parentheses
Applying a calculation to an entire column

Apply a sort on one or more columns
Modify sorting options
Apply filters on a table
Use advanced filters

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

Available display modes
Show / hide cells
Zoom
Freeze panes

Duration

5 days

Price

£ 1875

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR100383-F

  

Presentation of Word and the other tools of the Office suite
Examples of realization with Word

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (pages, sections, paragraphs …)
Display the ruler, paragraph marks and gridlines

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

Enter text
Move around the document
Select text to edit
Move and duplicate text
Change text formatting
Manage paragraph alignment
Use automatic spell checking

Search for a character string
Launch an in-depth search
Replace one string with another
Replace formatting

Define a hierarchy at the style level
Apply a predefined style to a text
Create a new text style

Workshop: Apply a style to all of its text content

Choose the theme of your document
Apply a variant of the active theme
Customize the colors, fonts and effects of a theme

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

Presentation of PowerPoint and the other tools of the Office suite
Examples of realization with PowerPoint

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (slideshows, sections, slides)
Create a new slide show
Using slide show templates

Add / remove slides Slide
layouts
Group your slides into sections
Move a slide

Placeholders
Insert and format text
Insert and customize shapes
Insert and customize images
Create a photo album
Use WordArt
Organize inserted content

Use slide themes
Add a background
Create your own theme

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

Launching the slideshow mode
Creating a personalized slideshow
Configure the slideshow
The other display modes
Inserting a header and footer
Adding comments

Email
Overview Outlook

Software interface Basic
functions
Presentation of the mailbox
Presentation of the Address book
Presentation of the Agenda

Send an email
Read your emails
Reply or forward a message
Inserting attachments
Text format
Signing emails View
panel and virus rules
Create folders

Create a list of contacts
Add contacts to a list
Insert contacts in an e-mail Group
management
The diary
Presentation of the calendar
Display mode
Creation of tasks
Alerts

Keyboard shortcuts
Rules
Creating acknowledgment filters

Revisions
Questions / Answers
Passing the PCIE certification

Passing the certification (if provided for in the funding)

Sessions

Contact us for more informations about session date