Training Syllabus Microsoft Office 2010 Advanced

Microsoft Word Advanced 2010 (1 Day)

Using Word with Other Programs

• Link an Excel Spreadsheet to Word Document
• Link a chart in word to Excel Data
• Send a document Outline to PowerPoint to create a presentation
• Send a Document as an Email Message

Collaborating on Documents

• Set User Information
• Review a Document
• Merge Document Changes
• Review Track Changes and Comments

Adding Reference Marks and Notes

• Inserting Bookmarks
• Inserting Footnotes and Endnotes
• Inserting Cross-References
• Add Captions
• Insert and edit Hyperlinks
• Create an Index
• Inserting Table of Contents

Working with Long Documents

• Inserting Blank and Cover Pages
• Create an Index
• Insert Table of Contents
• Working with Master Documents and Sub Documents

Mail Merge

• Creating a Data Source
• Creating a standard Letter
• Perform a Mail Merge
• Mail Merge Envelopes and Labels

Modifying Pictures

• Insert a picture
• Resize a Picture
• Set Picture Prominence
• Wrap Text around a Picture

Automating Document Creation

• Create a document using Template Wizard
• Create a document based on a Template
• Create and save a Template

Using Graphic Elements

• Draw Shapes
• Add Special Effects to Text
• Display Text as Graphic using Text Boxes
• Control Text Flow between Text Boxes

Structuring Content Using Quick Parts

• Create Building Blocks
• Insert Building Blocks
• Modify Building Blocks

Forms

• Add Form Fields
• Protect a Form
• Use a Form

Microsoft Excel Advanced 2010 (1 Day)

Auditing a worksheet

• Tracing precedents and dependents
• Tracing errors in the worksheet
• Error checking
• Watch window

Linking worksheets and workbooks

• Setting up related worksheets within a workbook
• Entering a formula to link related worksheets
• Entering a formula to link external workbooks
• Creating a workspace
• Consolidate worksheets/workbooks

What if Analysis

• Goal seek
• 1 way and 2 way data tables
• scenario manager

Additional features

• Worksheet validation
• Protecting a worksheet and workbook
• Group and outlining the worksheet

Advanced functions

• Index function
• Array functions

Formatting

• Create a custom number and date format
• Using conditional formatting
• Inserting Sparklines

Working with Templates

• Creating a new workbook template
• Create a workbook from a template

Importing and Exporting Data

• Importing data from a text or web based file
• Working with other database applications such as Access

Working with other Excel users

• Create a shared workbook
• Tracking changes in a shared workbook
• Responding to proposed changes and comments in a shared workbook

Filtering and summarising worksheet data

• Autofilter and advanced filter
• Adding a criteria range with advanced filter
• Database functions
• Using subtotals and nested subtotals
• Applying a database query
• Removing duplicate entries

Pivot Tables

• What is a pivot table?
• Best practice on setting up pivot tables
• Creating a pivot table
• Resetting the summary function in a pivot table report
• Grouping pivot table data
• Formatting a pivot table
• Charting a pivot table
• Printing the pivot table
• Using other Microsoft data sources with pivot tables
• Using Slicer to make PivotTables more interactive
• Analysing data from multiple sources using PowerPivot plug-in

Recording simple macros

• Why use macros?
• Macro guidelines
• Macro security settings
• Recording/deleting macros
• Running macros
• Assign a macro to an icon and shortcut keys
• Identify the difference between relative and absolute macros 

Microsoft Powerpoint Advanced 2010 (1 Day)

Customising the PowerPoint Environment

• Personalise the PowerPoint interface
• Customise save options
• Apply advanced customisation options

Customising a Design Template

• Set up a slide master
• Customise slide layouts
• Create a custom theme
• Customise Bullets
• Add common slide information
• Modify note master
• Modify handout master

Adding Diagrams to a Presentation

• Create a diagram
• Modify diagrams

Sound and Movies

• Inserting a sound clip to a slide
• Adding a movie clip to a slide

Interactive presentations

• Inserting hyperlinks
• Using action buttons

Advanced Animation

• The animation task pane
• Achieving advanced effects

Customising a Slide Show Presentation

• Set up a custom show
• Annotate a presentation
• Create a presenter-independent slide show
• Set up slide show to repeat automatically

Collaborating on a Presentation

• Publish slides to a slide library
• Share a presentation
• Working with comments within the presentation

Finalising a Presentation

• Review a presentation
• Secure a presentation
• Saving a presentation as a web page