Microsoft Office 2013

CONTENTS

COURSE 1 MICROSOFT OFFICE 2013 - Word - Single Level

Contents:

MODULE 1 - Getting started with Word

• Know the working environment
• Open a document
• Save a document
• Print a document

MODULE 2 - Text and paragraph formatting

• The concept of paragraph
• Character commands
• Paragraph commands

MODULE 3 - Distribute the text

• Page break
• Layout
• Text break
• Tabs

MODULE 4 - The styles

• Apply a style
• Create a new style
• Change a style

MODULE 5 - The Tables

• Insert a new table
Format a table
• Define the layout of a table

MODULE 6 - Images

• Insert an image
• Adjust an image
• Set the style of an image
• Arrange the illustrative elements
• Change the size

MODULE 7 - The text boxes and shapes

• Enter a shape
Format a shape
• Change a shape
• Insert a text box
Format a text box

MODULE 8 - Textual elements and symbols

• The Quick Parts button • The WordArt button
• The Drop button
• The Date and Time button
• The Equation button
• The Symbol button

MODULE 9 - Page Layout and Sections

• The themes
• The background setting
• Formatting the document
Section formatting
• The header and footer

MODULE 10 - The final revision

• Check spelling and grammar
• The Thesaurus button
• The Translate button
• The Language button
• The Word Count button

MODULE 11 - Collaborative review

• The Comments group
• The Change Tracking group
• The Revisions group
• The Protect group
• The Compare group

MODULE 12 - References

• The Summary group
• The Footnotes group
• The Citations and Bibliography group
• The Captions group
• The Index group
• The Links group

MODULE 13 - Master documents

• Know a master document
• Create the structure of the master document
• Create the master document
• The Compress Subdocuments button
• Manage secondary documents

MODULE 14 - The mail union

• The mail merge
• The main document
• Enter the data source
• Insert the merge fields
• Preview and merge the two documents

 

COURSE 2 MICROSOFT OFFICE 2013 - Excel Base
Contents:

MODULE 1 - The basics of Excel

• Know the working environment
• Open a workbook
• Know the folders
• Activate a cell
• Select the intervals
• Enter and edit information
• Save and close a folder

MODULE 2 - The cells

• Set the format of a cell
• Choose cell styles
• Conditional formatting
• Apply conditional formatting

MODULE 3 - Operations on cells

• Use the Copy, Paste, Cut functions
• Use the Format Painter command
• Set the character
• Align the text
• Insert and delete items in a workbook
• Use the cell format options.

MODULE 4 - Tables

• Insert a table
• Name a table
• Resize a table
Convert a table into a range of cells
• Export data from a table
• Set the style of a table
• Change the style of a table: example of a total row

MODULE 5 - The formulas

• Use formulas
• Define ranges in functions
• Insert a quick function
• Use the Fill command

MODULE 6 - Graphs

• Choose and insert a chart
• Modify a chart
• Change and customize the type of a chart
• View the analysis of a graph

MODULE 7 - The page setup

• Manage page settings
• The Page Layout tab
• Repeat the row and column titles
• Insert page breaks
• Remove page breaks
• Set margins
• Manage orientation
• Set the print format
• The Print Area button
• The Fit to page group
• The Sheet Options group
• The Themes group

MODULE 8 - Images

• Insert an image
• Adjust the image
• Reset the image
• Set the style of an image
• Insert an image from the web
• Arrange the illustrative elements
• Change the size

MODULE 9 - The SmartArt

• Use smartArt
• Modify the SmartArt
• Set the layout
• Choose styles
• Reset the SmartArt
• Choose shapes, styles and WordArt
• Define the size and position with respect to other graphic elements

COURSE 3 MICROSOFT OFFICE 2013 - Advanced Excel
Contents:

MODULE 1 - THE DISPLAY AND AUTOMATION OF DATA

• The View tab
• Manage the zoom
• The display modes
• Set up a custom view
• The visualization tools
• Lock the worksheet titles
• Divide the worksheet
Compare two worksheets
• Compare multiple worksheets
• Manage windows
• Making macros
• Manage macros

MODULE 2 - MODIFICATION OF DATA

• Custom numeric formats
• Automatic filling
• Custom lists
Validation of data
• Apply data validation

MODULE 3 - DATA REVIEW

• The audit activity
• Spell checking
• Apply spell checking
• Use synonyms and antonyms
• Use the multilingual dictionary
• Enter a comment
• Manage comments
• Protect the worksheet
• Protect the workbook
• Share the workbook
• View revisions
• Accept or decline revisions

MODULE 4 - DATA IMPORT

• Introduction
• Import data from Access
• Text file
• Import data from Testo
XML files
• Import data from XML

MODULE 5 - DATA ORGANIZATION

• Define a database
• Organize your data
• Sort the data
• Sort the data by multiple criteria
• Perform a sorting of data based on multiple criteria
• Filter the data
• Run the Filter command
• Criteria for filtering
• Divide the text into a column
• Text to Column Conversion Wizard
• Remove duplicates
Calculate the subtotals
• Find and replace information
• Use a list of Excel data in the mail merge procedure in Word
• How to use a list of Excel data in the mail merge procedure in Word

MODULE 6 - ADVANCED FORMULAS

• Use formulas
• Know the SE function
Understand the syntax of the SE formula
• Enter the formula SE
• Use the Insert Function command
• Know the CONTA.SE formula
• Enter the formula COUNTIF
• Know the formula DB.SOMMA
• Enter the formula DB.SOMMA
• Know the DB.MEDIA formula
• Know the formula VLOOKUP
• Know the syntax of the SEARCH.VERT formula
• Enter the formula VLOOKUP
• Know the STRINGA.ESTRAI formula
• Enter the formula STRINGA.ESTRAI

MODULE 7 - TABLES AND THE PIVOT GRAPH

• Know the pivot table
• Examine a pivot table
• Insert a pivot table
• Modify a pivot table
• Update data and view detailed data
• Filter the data of a report
• Group data
• Grouping text elements
• Group by date and time or by numerical ranges
• Pivot chart
• Insert a pivot chart
• Filter and edit data in a pivot chart

COURSE 4 MICROSOFT OFFICE 2013 - PowerPoint
Contents:

MODULE 1 - Getting started with PowerPoint
• Know the working environment
• Open a presentation
• Save and close a presentation

MODULE 2 - Basic operations

• Audio Video Title Code
• Set up your slides
• Choose a theme
• Set the wallpaper
• Choose the layout
• Insert content
• Insert a new slide

MODULE 3 - The text boxes and shapes

• Insert a text box
• Set the style
• Insert and edit a shape

MODULE 4 - The Images

• Insert an image
• Adjust an image
• Set the style of an image
• Arrange the illustrative elements
• Change the size

MODULE 5 - The Tables

• Insert a table
• Set the style of a table
• Set style options
• Insert and delete rows and columns
• Merge or split cells
• Set the size of the cells
• Manage text alignment

MODULE 6 - The SmartArt

• Use SmartArt
• Modify the SmartArt
• Choose styles
• Reset the SmartArt
• Change the individual elements

MODULE 7 - Graphs

• Choose and insert a chart
• Choose the graphic layout
• Choose chart styles
• Change the type of chart
• Set the graphic format from the contextual tab
• Other formatting modes

MODULE 8 - Multimedia elements

• Insert a movie
• Set options for a movie
• Insert an audio contribution
• Set audio options
• Set up your audio changes
• Insert an object
• Create a photo album

MODULE 9 - The text

Format the text
Format the paragraph
• Copy, cut and paste
• Search and replace

MODULE 10 - Review and comment

• Use the spell checker
• Use dictionaries
• Manage comments

MODULE 11 - Notes and accessory text

• Insert the footers
• Insert a symbol
• Insert a WordArt
• Modify a WordArt

MODULE 12 - The work area

• Set the workspace display
• Set the guides
• Adjust the zoom
• Set up windows

MODULE 13 - Managing a presentation - Transitions and animations

• Start a presentation
• Use tools during projection
• Choose a transition
• Set the speed and timing of the transition
• Associate an audio effect
• Set up an animation

MODULE 14 - Custom animations and interactions

• Add an effect
• Customize an effect
• Insert a hyperlink
• Set up an action

MODULE 15 - The slide design

• Design the slide master
Format a pattern
• Set up the page
• Close the outline view

MODULE 16 - The printed scheme

• Design the printed layout
• Set up the page
• Define the placeholders
• Set the wallpaper
• Close the outline view

 

COURSE 5 MICROSOFT OFFICE 2013 - Outlook
Contents:

1 MODULE
• First operations with Microsoft Outlook 2013

2 MODULE
• The management of the items in the address book

3 MODULE
• Management of agenda items

4 MODULE
• Notes and Activities