Goals
- Be able to perform calculations and use formulas with Excel
- Know how to handle graphics and pivot tables
- Have an in-depth use of Word
- Work with reference tables
- Carry out a direct mail; Insert multimedia content on Powerpoint
- Customize the slide master
Program
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: Realization of a summary document with the main Excel formulas
Create named areas and integrate them into formulas
Find antecedents and dependencies in formulas
Check formulas for errors
Change the way your workbook is calculated
Select the data to integrate into the graph
Choose a type of graph according to needs (histogram, curve, sector in 2D or 3D)
Define a quick layout for its graph
Add additional information to the graph (axis title, data labels, curve trend …)
Choose the visual aspect of your graphic via the styles
Apply table updates to associated charts
Change the type of chart
Move a chart within its workbook
Customize the style of its chart
Integrate a chart into an external document (Word, PowerPoint)
Workshop: Generate a graph according to your needs
The principle of a pivot table
Define which calculation and label fields will be
Select the source of its pivot table
Place the fields to analyze
Apply a style to the pivot table
Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields
Workshop: Highlight the desired statistics from your table
Integrate subtotals into a table
Convert and consolidate
Data validation
Scenario analysis
Adding and modifying comments
Protect your workbook and sheets
Duration
2 days
Price
£ 750
Audience
Excel users
Prerequisites
Have followed the course « Excel: Initiation » or have equivalent knowledge
Reference
BUR100429-F
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 …)
Select the source of the recipients
Match the fields between the source and Word
Filter the recipients of a mail merge
Prepare your mail
merge template Insert merge fields
Define rules
Preview the results
Finish and merge
Workshop: Prepare a standard letter for several recipients
Create a comment
Show / hide comments
Manage comments
Enable track changes
Compare two Word documents
Restrict changes
Workshop: Revision of a document
Presentation of Microsoft’s OneDrive service
Creating a OneDrive account
Save a file in your OneDrive space
Share a file or a folder
Define the action rights per user
Workshop: Share a document and work with others on it
Copy Excel data to Word
Insert an Excel spreadsheet into Word
Create hyperlinks to other applications
Save as HTML
Workshop: Import a table and a chart from Excel
Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools
Insert tables
Customize table layout
Charts and flowcharts
Insert audio and video
Insert text from Word
Recover table from Excel
Embed chart from Excel
Create a link to a website
Define a contact link
Add internal navigation links
Use PowerPoint actions
Usefulness of the slide master
Display and customize a layout
Create a new mask
Other types of mask
Compare two presentations
Protect a slide show
Check that there are no problems
Share your presentation
Broadcast your slide show online
Presentation of Microsoft’s OneDrive service
Creating a OneDrive account
Save a file in your OneDrive space
Share a file or a folder
Define the action rights by user
Workshop: Share a presentation and work with others on it
Integrate shortcuts into the Quick Access toolbar
Create a tab with your favorite tools
Revisions
Questions / Answers
Passing the TOSA certification
Passing the certification (if requested by the trainee)
Sessions
Contact us for more informations about session date