Sunday, 22 September 2013

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


  • 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


  • 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

No comments:

Post a Comment