Microsoft Office 2013

COURSE 1 MICROSOFT OFFICE 2013 - Word - Single Level

Contents:

MODULE 1 - Getting started with Word

• Know the work 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
• The Tabulations

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 a picture
• Adjust an image
• Set the style of an image
• Arrange the illustrative elements
• Change the size

MODULE 7 - The text boxes and shapes

• Insert a shape
• Format a shape
• Edit 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 Cap button
• The Date and Time button
• The Equation button
• The Symbol button

MODULE 9 - Page Layout and Sections

• The themes
• The background setting
• Document formatting
• The formatting of the sections
• 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         

• Getting to 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 -  Basic Excel

Contents:

MODULE 1 - The basics of Excel

• Know the work 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 font  
• Align the text            
• Insert and delete items in a workbook         
• Use the cell format options.       

MODULE 4 -  The tables

• Insert a table      
• Name a table  
• Resize a table      
• Convert a table to a range of cells  
• Export the data of a table   
• Set the style of a table             
• Changing 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 -  The graphs

• Choose and insert a chart  
• Edit 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 row and column titles          
• Insert page breaks            
• Remove page breaks       
• Set the 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 a picture   
• Adjust the image    
• Reset the image           
• Set the style of an image         
• Insert a picture from the web 
• Arrange the illustrative elements
• Change the size           

MODULE 9 -  The SmartArt

• Use smartArt   
• Edit SmartArt
• Set the layout       
• Choose styles             
• Reset SmartArt           
• Choose shapes, styles and WordArt
• Define the size and position relative to other graphics                  

 

COURSE 3 MICROSOFT OFFICE 2013 -  Advanced Excel

Contents:

MODULE 1 - THE DISPLAY AND AUTOMATION OF DATA

• The View tab
• Manage zoom
• The viewing 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 number formats
• Automatic filling
• Custom lists
• Data validation
• Apply Data Validation

MODULE 3 - DATA REVIEW

• The auditing activity
• Spell check
• Apply spell check          
• 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 reject revisions

MODULE 4 - IMPORT OF DATA

• Introduction
• Import data from Access
• Text File
• Import data from Text
• XML file
• Import data from XML

MODULE 5 - DATA ORGANIZATION

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

MODULE 6 - ADVANCED FORMULAS

• Use formulas
• Learn about the SE function
• Understanding the syntax of the SE formula
• Enter the formula SE
• Use the Insert Function command
• Know the COUNTIF formula
• Enter the COUNTIF formula
• Know the SUM formula
• Enter the formula DB.SUM
• Know the DB.MEDIA formula
• Know the VLOOKUP formula
• Know the syntax of the VLOOKUP formula
• Enter the VLOOKUP formula
• Know the STRING.EXTRACT formula
• Enter the formula STRING.EXTRACT

MODULE 7 - TABLES AND THE PIVOT GRAPH

• Get to know the pivot table
• Examine a pivot table
• Insert a pivot table          
• Edit a pivot table
• Update the data and view the detailed data
• Filter the data of a report
• Group the data
• Grouping of text elements
• Group by date and time or by numeric ranges
• Pivot chart
• Insert a pivot chart
• Filter and edit data in a pivot chart

 

COURSE 4 MICROSOFT OFFICE 2013 -  Power point

Contents:

MODULE 1 - Getting started with PowerPoint

• Know the work 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 a picture
• 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 the 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
• Edit SmartArt
• Choose styles
• Reset SmartArt
• Change the individual elements

 

MODULE 7 - Graphs

• Choose and insert a chart
• Choose the graphic layout
• Choose the styles of the chart
• Change the chart type
• 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 the audio options
• Set the audio changes
• Enter a subject
• 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 footers
• Insert a symbol
• Insert a WordArt
• Edit a WordArt

MODULE 12 - The work area

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

MODULE 13 - Managing a presentation - Transitions and animations

• Start a presentation
• Use the 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 schema
• Set up the page
• Close the schema view

MODULE 16 - The printed scheme

• Design the printed diagram
• Set up the page
• Define the placeholders
• Set the wallpaper
• Close the schema view

 

COURSE 5 MICROSOFT OFFICE 2013 -  Outlook

Contents:

1 MODULE

• First steps with Microsoft Outlook 2013

 2 MODULE

• Managing the items in the address book

 3 MODULE

• The management of agenda items

4 MODULE

• Notes and Activities