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