Skill Sets

Exam Skill Standards

Managing the OneNote Environment

*Manage Page Layout.  This objective may include, but is not limited to: Combine containers, Collapse and expand paragraphs, Set an image as a background, Save current page as template

*Configure OneNote Notebook Backstage.  This objective may include, but is not limited to: Configure Notebook settings and properties, Pin recently opened notebook to list

*Create New OneNote Notebook.  This objective may include, but is not limited to: Create a new notebook on SkyDrive, Create a new notebook on a network, Create a new notebook on My Computer

*Personalize OneNote.  This objective may include, but is not limited to: Default font and size, Display settings, Proofing settings, Language settings, Research and translation options

*Personalize Page Setup.  This objective may include, but is not limited to: Page colour, Rule lines, Grid lines, Page title, Paper size, Full page view, Dock to desktop

Sharing and Collaborating

*Share OneNote Notebooks.  This objective may include, but is not limited to: Share notebook on: SkyDrive, SharePoint document library, Network drive

*Share OneNote Content via E-mail.  This objective may include, but is not limited to: E-mail others about the notebook and configure e-mail options, Invite others to view a notebook, E-mail page in shareable formats

*Collaborate in OneNote.  This objective may include, but is not limited to: Mark co-authors edits as read, View recent edits, Find notes by author, Hide author initials

Organizing and Finding Notes

*Use OneNote Notebook Organization Tools.  This objective may include, but is not limited to: Merge sections, Create new section group, Colour code notebooks and sections, Protect with password, Group and collapse sub-pages, Use Side Notes

*Search OneNote.  This objective may include, but is not limited to: Search for content across Notebooks, Sections or Pages, Display search results pane

*Use History and Backups in OneNote.  This objective may include, but is not limited to: Page versions, Notebook recycle bin, Open backup notebook

*Save Notebook As.  This objective may include, but is not limited to: Save current page, Save as alternate file types

*Use Quick Filing.  This objective may include, but is not limited to: Send to E-mail messages, Meetings notes, Contact notes, Tasks, Web pages, Screenshots, Print to OneNote

*Use and Manage Tags.  This objective may include, but is not limited to: Apply tags to paragraphs, Create new tags, Modify existing tags, Create Tag Summary page, Configure tag options, Find tags

Editing and Linking Content in OneNote

*Use Links and Linked Notes.  This objective may include, but is not limited to: Link to other OneNote pages; Link notes to Pages, Sections, Notebooks, Wikilinks; Create new Docked Window or Side Note; Link notes to other applications such as Microsoft Office Word 2010 documents, Microsoft Office PowerPoint 2010 presentations and Internet Explorer web pages

*Insert Files.  This objective may include, but is not limited to: Insert link to files, Embed file, File print (Print to OneNote)

*Edit Text in OneNote.  This objective may include, but is not limited to: Format painter, Styles, Paste options, Clear formatting, Tables, Research

*Insert and Modify Visual Elements.  This objective may include, but is not limited to: Images, Symbols, Drawing tools, Pen options

Skill Sets

Exam Skill Standards

Creating and Formatting Content

*Navigate the SharePoint hierarchy.

*This objective may include but is not limited to: using Quick Launch, All Site Content, and breadcrumb trails, adding content to Quick Launch, and using content and structure for navigation

*Manage lists and libraries.

*This objective may include but is not limited to: creating lists or libraries, editing properties for new items, enabling email notifications on a library or list, providing a shortcut to a mobile site URL, managing document templates, managing list views, creating an alert on a list or library, enabling rating, adding a column, adding content validation, managing column properties for various column types, and managing workflows

*Manage list items.

*This objective may include but is not limited to: creating a new item, editing content, deleting a list item or a document, versioning items, publishing assets, managing workflows, and uploading documents

*Manage document sets.

*This objective may include but is not limited to: creating a document set and adding a document to a document set

Managing SharePoint Sites

*Manage pages.

*This objective may include but is not limited to: creating, editing, and deleting pages

*Administer a site.

*This objective may include but is not limited to: creating a new site, configuring the site structure, configuring the Content Organizer, displaying a list of all user alerts, modifying the Look and Feel of a site, and recovering a list, library, document or list item

*Manage Web Parts on a page.

*This objective may include but is not limited to: adding a Web Part, configuring a Web Part, hiding or removing a Web Part, and exporting or importing a Web Part

*Manage content types.

*This objective may include but is not limited to: associating a content type to a list and extending the columns of a content type

*Manage users and groups.

*This objective may include but is not limited to: managing user access, groups, and group permissions

*Create SharePoint workspace sites.

*This objective may include but is not limited to: using document and meeting workspaces

*Analyze site activity.

*This objective may include but is not limited to: viewing site web analytics and viewing detailed reports

Participating in User Communities

*Configure My Site.

*This objective may include but is not limited to: adding keywords, adding colleagues, selecting a theme, configuring the Colleague *Tracker Web Part, configuring RSS feeds, and configuring profiles

*Collaborate through My Site.

*This objective may include but is not limited to: updating profile status, sharing pictures in My Site, managing personal documents, sharing documents in My Site, browsing the organization hierarchy, and adding Web Parts to My Site

*Tag and note content.

*This objective may include but is not limited to: adding notes on the Note Board for a list or a library, adding tags for a list or a library, rating an item, using tag clouds, and reviewing tags on My Site

Configuring and Consuming Site Search Results

*Administer search at the site level.

*This objective may include but is not limited to: configuring searchable columns, configuring list search, and configuring site search visibility

Search SharePoint for content.

*This objective may include but is not limited to: performing search by using Windows Internet Explorer, Windows Explorer, Office Word 2010 Research Pane, or SharePoint Workspace 2010

*View search results.

*This objective may include but is not limited to: browsing search results, using best bet results, using the refinement panel, using alerts and RSS feeds, and viewing document previews

Perform advanced searches.

*This objective may include but is not limited to: using boolean operators in searches, using wild cards in searches, running property searches, and running phonetic searches

*Search for people.

*This objective may use but is not limited to: using People Search, refining people searches, and using advanced searches      

Integrating SharePoint 2010 Services and Microsoft Office 2010 applications

*Configure SharePoint 2010 Services.

*This objective may include but is not limited to: using Form Services, Excel Services, Access Services, and Visio Services

*Run Microsoft Office 2010 applications with SharePoint 2010 services.

*This objective may use but is not limited to: integrating with Microsoft Outlook, accessing content with SharePoint Workspace 2010, and integrating with Office Web applications

*Create dashboards.

*This objective may include but is not limited to: creating a dashboard page, adding and configuring the Key Performance Indicators (KPI) Web Part, KPI Details Web Part, Chart Web Part, Current User Filter Web Part, and Excel Web Access Web Part, displaying business data actions, and creating KPI lists

Skill Sets

Exam Skill Standards

Sharing and Maintaining Documents

*Configure Word options.

*This objective may include but is not limited to: changing default program, spelling, and grammar checking options

*Apply protection to a document.

*This objective may include but is not limited to: restricting editing and applying controls or restrictions to document access

*Apply a template to a document.

*This objective may include but is not limited to: modifying an existing template, creating a new template, applying a template to an existing document, and managing templates by using the Organizer

Formatting Content

*Apply advanced font and paragraph attributes.

*This objective may include but is not limited to: using character attributes and character-specific styles

*Create tables and charts.

*This objective may include but is not limited to: inserting tables by using Microsoft Excel data in tables, applying formulas or calculations on a table, modifying chart data, saving a chart as a template, and using the chart Layout tab

*Construct reusable content in a document.

*This objective may include but is not limited to: creating customized building blocks, saving a selection as a quick part, saving quick parts after a document is saved, inserting text as a quick part, and adding content to a header or footer

*Link sections.

*This objective may include but is not limited to: linking text boxes, breaking links between text boxes, and linking different sections

Tracking and Referencing Documents

*Review, compare, and combine documents.

*This objective may include but is not limited to: applying tracking, merging different versions of a document, tracking changes in a combined document, and reviewing comments in a combined document

*Create a reference page.

*This objective may include but is not limited to: adding citations, managing sources, compiling a bibliography, and applying cross references

*Create a Table of Authorities in a document.

*This objective may include but is not limited to: applying default formats, adjusting alignment, applying a tab leader, modifying styles, marking citations, and using passim (short form)

*Create an index in a document.

*This objective may include but is not limited to: specifying index type, columns, and language, modifying an index, and marking index entries

Performing Mail Merge Operations

*Execute Mail Merge.

*This objective may include but is not limited to: merging rules and sending personalized email messages to multiple recipients

*Create a Mail Merge by using other data sources.

*This objective may include but is not limited to: using Microsoft Outlook, Access, Excel, or Word tables as data source for a mail merge operation

*Create labels and forms.

*This objective may include but is not limited to: preparing data and creating mailing labels, envelope forms, and label forms

Managing Macros and Forms

*Apply and manipulate macros.

*This objective may include but is not limited to: recording a macro, running a macro, and applying macro security

*Apply and manipulate macro options.

*This objective may include but is not limited to: running macros when a document is opened, running macros when a button is clicked, assigning a macro to a command button, and creating a custom macro button on the Quick Access Toolbar

*Create forms.

*This objective may include but is not limited to: using the Controls group, adding Help content to form fields, linking a form to a database, and locking a form

*Manipulate forms.

*This objective may include but is not limited to: unlocking a form, adding fields to a form, and removing fields from a form

Skill Sets

Exam Skill Standards

Sharing and Maintaining Workbooks

*Apply workbook settings, properties, and data options.

*This objective may include but is not limited to: setting advanced properties, saving a workbook as a template, and importing and exporting XML data

*Apply protection and sharing properties to workbooks and worksheets.

*This objective may include but is not limited to: protecting the current sheet, protecting the workbook structure, restricting permissions, and requiring a password to open a workbook

*Maintain shared workbooks.

*This objective may include but is not limited to: merging workbooks and setting Track Changes options

Applying Formulas and Functions

*Audit formulas.

*This objective may include but is not limited to: tracing formula precedents, dependents, and errors, locating invalid data or formulas, and correcting errors in formulas

*Manipulate formula options.

*This objective may include but is not limited to: setting iterative calculation options and enabling or disabling automatic workbook calculation

*Perform data summary tasks.

*This objective may include but is not limited to: using an array formula and using a SUMIFS function

*Apply functions in formulas.

*This objective may include but is not limited to: finding and correcting errors in functions, applying arrays to functions, and using Statistical, Date and Time, Financial, Text, and Cube functions

Presenting Data Visually

*Apply advanced chart features.

*This objective may include but is not limited to: using Trend lines, Dual axes, chart templates, and Sparklines

*Apply data analysis.

*This objective may include but is not limited to: using automated analysis tools and performing What-If analysis

*Apply and manipulate PivotTables.

*This objective may include but is not limited to: manipulating PivotTable data and using the slicer to filter and segment your PivotTable data in multiple layers

*Apply and manipulate PivotCharts.

*This objective may include but is not limited to: creating, manipulating, and analyzing PivotChart data

*Demonstrate how to use the slicer.

*This objective may include but is not limited to: choosing data sets from external data connections

Working with Macros and Forms

*Create and manipulate macros.

*This objective may include but is not limited to: running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access *Toolbar, and applying modifications to a macro

*Insert and manipulate form controls.

*This objective may include but is not limited to: inserting form controls and setting form properties        

Skill Sets

Exam Skill Standards

Working with Microsoft Word 2010

*Apply different views to a document

*Apply protection to a document

*Demonstrate how to use the Manage Versions tool in Backstage

*Demonstrate how to Share documents by using Backstage

*Apply saving by using the Save/Save As dialogs in Backstage

*Demonstrate knowledge of working with templates

Text and Paragraph Formatting

*Apply font attributes

*Demonstrate how to use Find features

*Apply indentation and tab settings to paragraphs

*Apply spacing settings to text and paragraphs

*Demonstrate how to insert tables

*Manipulate tables in a Microsoft Word 2010 document

*Demonstrate how to work with bullets in a *Microsoft Word 2010 document

Page Layout and Quick Parts

*Apply and manipulate page setup settings in a Microsoft Word 2010 document

*Apply themes to a Microsoft Word 2010 document

*Construct content in a Microsoft Word 2010 document by using the Quick Parts tool

*Create and manipulate page backgrounds in Microsoft Word 2010

*Demonstrate how to work with headers and footers

Illustrations and Graphics

*Demonstrate knowledge of working with Pictures in a Microsoft Word 2010 document

*Demonstrate knowledge of working with Shapes

*Demonstrate knowledge of working with Clip Art

*Apply and manipulate text boxes

Proofing

*Demonstrate the use of various spelling and grammar checking options in Word 2010

*Demonstrate how to modify AutoCorrect settings

*Demonstrate how to use comments in a Microsoft Word 2010 document

References and Hyperlinks

*Apply a hyperlink to text in a Microsoft Word 2010 document

*Create Endnotes and Footnotes in a Microsoft Word 2010 document

*Demonstrate knowledge of Table of Contents in a Microsoft Word 2010 document

Mail Merge

*Perform a mail merge operations

*Demonstrate how to Print and Print Preview a mail merge

Skill Sets

Exam Skill Standards

Working with Excel 2010

*Identify specific cell content through navigation tools

*Construct cell data

*Apply AutoFill

*Demonstrate how to print

*Demonstrate how to use Backstage

*Apply and manipulate hyperlinks

Formatting Cells and Worksheets

*Apply and modify cell formats

*Apply merging to cells

*Create row and column titles

*Demonstrate how to hide and unhide rows and columns

*Manipulate Page Setup options for worksheets

*Demonstrate knowledge of working with cell and table styles

Worksheet and Workbook Management and Organization

*Demonstrate how to work with worksheets

*Manipulate window views

*Manipulate workbook views

Working with Formulas and Functions

* Create formulas

*Demonstrate understanding of the order of operations (precedence)

*Apply cell references in formulas

*Apply conditional logic in a formula (<,>,=)

*Apply named ranges in formulas

*Apply cell ranges in formulas

Present Data Visually

*Create charts based on worksheet data

*Apply and manipulate illustrations

*Perform tasks using the in-application image editor

*Apply Sparklines

Data Security and Collaboration

*Demonstrate how to use Backstage to share spreadsheets

*Demonstrate management of comments

Data Analysis and Organization

*Apply filtering to data

*Apply sorting to data

*Apply conditional formatting

Skill Sets

Exam Skill Standards

Managing the PowerPoint Environment

*Adjust views. 

*This objective may include but is not limited to: adjusting views by using ribbon or status bar commands

*Manipulate the PowerPoint window.

*This objective may include but is not limited to: working with multiple presentation windows simultaneously

*Configure the Quick Access Toolbar.

*This objective may include but is not limited to: showing the Quick Access Toolbar (QAT) below the ribbon

*Configure PowerPoint file options.

*This objective may include but is not limited to: using PowerPoint, Proofing, and Save options

Creating a Slide Presentation

*Construct and edit photo albums.

*This objective may include but is not limited to: adding captions to pictures, inserting text, inserting images in black and white, reordering pictures in an album, and adjusting image rotation, brightness, and contrast

*Apply slide size and orientation settings.

*This objective may include but is not limited to: setting up a custom size and changing the orientation

*Add and remove slides.

*This objective may include but is not limited to: inserting an outline, reusing slides from a saved presentation, reusing slides from a slide library, duplicating selected slides, deleting multiple slides simultaneously, and including non-contiguous slides in a presentation

*Format slides.

*This objective may include but is not limited to: formatting sections, modifying themes, switching to a different slide layout, applying a fill color, gradient, picture, texture, or pattern to a slide, and setting up slide footers

*Enter and format text.

*This objective may include but is not limited to: using text effects, changing the indentation, alignment, line spacing, and direction of text, changing the formatting of bulleted and numbered lists, entering text in a placeholder text box, converting text to SmartArt, copying and pasting text, using Paste Special, and using Format Painter

*Format text boxes.

*This objective may include but is not limited to: applying a fill color, gradient, picture, texture, or pattern to a text box, changing the outline color, weight, or style, changing the shape of the text box, applying effects, setting the alignment, creating columns in a text box, setting internal margins, setting the current text box formatting as the default for new text boxes, adjusting text wrapping, sizing and positioning a text box, and using AutoFit

Working with Graphical and Multimedia Elements

*Manipulate graphical elements.

*This objective may include but is not limited to: arranging, positioning, and resizing graphical elements, applying effects, applying styles, applying borders, and adding hyperlinks

*Manipulate images.

*This objective may include but is not limited to: applying color adjustments, applying image corrections (sharpen, soften, brightness, contrast), adding artistic effects to an image, removing a background, cropping a picture, compressing selected pictures or all pictures, changing a picture, and resetting a picture

*Modify WordArt and shapes.

*This objective may include but is not limited to: setting the formatting of the current shape as the default for future shapes, changing the fill color or texture, changing the  WordArt, converting to SmartArt

*Manipulate SmartArt.

*This objective may include but is not limited to: adding and removing shapes, changing SmartArt styles, changing the SmartArt layout, reordering shapes, converting a SmartArt graphic to text, converting SmartArt to shapes, making shapes larger or smaller, and promoting or demoting bullet levels

*Edit video and audio content.

*This objective may include but is not limited to: applying a style to video or audio content, adjusting, arranging, and sizing video or audio content, and adjusting playback options

Creating Charts and Tables

*Construct and modify tables.

*This objective may include but is not limited to: drawing a table, inserting a Microsoft Excel spreadsheet, setting table style options, adding shading, borders, and effects, changing the alignment, resizing, merging or splitting columns and rows, distributing columns and rows, arranging columns and rows

*Insert and modify charts.

*This objective may include but is not limited to: selecting a chart type, entering chart data, changing the chart type, changing the chart layout, switching row and column, selecting data, editing data

*Apply chart elements.  

*This objective may include but is not limited to: using chart labels, axes, gridlines, and backgrounds

*Manipulate chart layouts.

*This objective may include but is not limited to: selecting chart elements and formatting selections

*Manipulate chart elements.

*This objective may include but is not limited to: arranging chart elements, specifying a precise position, applying effects, resizing chart elements, applying Quick Styles, applying a border, and adding hyperlinks

Applying Transitions and Animations

*Apply built-in and custom animations.

*This objective may include but is not limited to: using More Entrance, More Emphasis, and More Exit effects, and using More Motion paths

*Apply effect and path options.

*This objective may include but is not limited to: setting timing and start options

*Manipulate animations.

*This objective may include but is not limited to: changing the direction of an animation, attaching a sound to an animation, using Animation Painter, reordering animations, and selecting text options

*Apply and modify transitions between slides.

*This objective may include but is not limited to: modifying a transition effect, adding a sound to a transition, modifying transition duration, and setting up manual or automatically timed advance options

Collaborating on Presentations

*Manage comments in presentations.

*This objective may include but is not limited to: inserting and editing comments, showing or hiding markup, moving to the previous or next comment, and deleting comments

*Apply proofing tools.

*This objective may include but is not limited to: using Spelling and Thesaurus features, comparing and combining presentations

Preparing Presentations for Delivery

*Save presentations.

*This objective may include but is not limited to: saving the presentation as a picture presentation, PDF, XPS, outline, or OpenDocument presentation, saving a slide or object as a picture file, and saving a presentation as a show (.ppsx)

*Share presentations.

*This objective may include but is not limited to: packaging a presentation for CD delivery, creating video, creating handouts (send to Microsoft Word),  and compressing media

*Print presentations.

*This objective may include but is not limited to: adjusting print settings

*Protect presentations.

*This objective may include but is not limited to: setting a password, changing a password, and marking a presentation as final

Delivering Presentations

*Apply presentation tools.

*This objective may include but is not limited to: adding pen and highlighter annotations, changing the ink color, erasing an annotation, and discarding or retaining annotations upon closing

*Set up slide shows.

*This objective may include but is not limited to: setting up Slide Show, playing narrations, setting up Presenter view, using timings, showing media controls, broadcasting presentations, and creating a Custom Slide Show

*Set presentation timing.

*This objective may include but is not limited to: rehearsing and keeping timings, adjusting a slide's timing

*Record presentations.

*This objective may include but is not limited to: starting recording from the beginning of a slide show and starting recording from the current slide of the slide show

Skill Sets

Exam Skill Standards

Managing the Outlook Environment

*Apply and manipulate Outlook program options. This objective may include but is not limited to: setting General, Mail, Calendar, Tasks, Notes and Journal, Advanced, and Language options

*Manipulate item tags. This objective may include but is not limited to: categorizing items, setting flags, setting sensitivity level, marking items as read or unread, and viewing message properties

*Arrange the Content Pane. This objective may include but is not limited to: showing or hiding fields in a list view, changing the reading view, and using the Reminders Window and People Pane

*Apply search and filter tools. This objective may include but is not limited to: using built-in Search folders

*Print an Outlook item. This objective may include but is not limited to: printing attachments, calendars, multiple messages, multiple contact records, tasks, and multiple notes

Creating and Formatting Item Content

*Create and send email messages. This objective may include but is not limited to: specifying a message theme, specifying plain text, rich text, or HTML message content format, showing or hiding the From and Bcc fields, setting a reminder for message recipients, specifying the sending account, specifying the sent item folder, configuring message delivery options, configuring voting and tracking options, and sending a message to a contact group

*Create and manage Quick Steps. This objective may include but is not limited to: performing, creating, editing, deleting, and duplicating Quick Steps, resetting Quick Steps to default settings

*Create item content. This objective may include but is not limited to: inserting graphical elements and inserting a hyperlink

*Format item content. This objective may include but is not limited to: using formatting tools, applying styles, creating styles and themes, using Paste Special, and formatting graphical elements

*Attach content to email messages. This objective may include but is not limited to: attaching an Outlook item and attaching external files

Managing Email Messages

*Clean up the mailbox. This objective may include but is not limited to: viewing mailbox size, saving message attachments, saving a message in an external format, ignoring a conversation, and using clean-up tools

*Create and manage rules.

*This objective may include but is not limited to: creating, modifying, and deleting rules

*Manage junk mail. This objective may include but is not limited to: allowing a specific message (Not junk), and filtering junk mail with Never Block Sender, Never Block Sender’s Domain, Never Block this Group or Mailing List, and Block Sender

*Manage automatic message content. This objective may include but is not limited to: managing signatures, specifying the font for new HTML messages, plain-text messages, specifying options for replies and forwards, and setting a default theme for all HTML messages, stationery, and fonts

Managing Contacts

*Create and manipulate contacts. This objective may include but is not limited to: modifying a default business card, forwarding a contact, and updating a contact in the address book

*Create and manipulate contact groups. This objective may include but is not limited to: creating a contact group, managing contact group membership, showing notes about a contact group, forwarding a contact group, deleting a contact group, and sending a meeting to a contact group

Managing Calendar Objects

*Create and manipulate appointments and events. This objective may include but is not limited to: setting appointment options, printing appointment details, forwarding an appointment, and scheduling a meeting with a message sender

*Create and manipulate meeting requests. This objective may include but is not limited to: setting response options, updating a meeting request, canceling a meeting or invitation, and proposing a new time for a meeting

*Manipulate the Calendar pane. This objective may include but is not limited to: arranging the calendar view, changing the calendar color, displaying or hiding calendars, and creating a calendar group

Working with Tasks, Notes, and Journal Entries

*Create and manipulate tasks. This objective may include but is not limited to: creating a task, managing task details, sending a status report, marking a task as complete, moving or copying a task to another folder, assigning a task to another Outlook user, accepting or declining a task assignment, updating an assigned task, and using Current view

*Create and manipulate notes. This objective may include but is not limited to: creating a note, changing the current view, and categorizing notes

*Create and manipulate Journal entries. This objective may include but is not limited to: automatically record Outlook items, automatically record files, and editing a Journal entry

Skill Sets

Exam Skill Standards

Managing the Access Environment

*Create and manage a database. This objective may include but is not limited to: using Save Object As, Open, Save and Publish, Compact & Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options

*Configure the Navigation Pane. This objective may include but is not limited to: renaming objects, deleting objects, and setting Navigation options

*Apply Application Parts. This objective may include but is not limited to: using Blank Forms, Quick Start, and user templates

Building Tables

*Create tables. This objective may include but is not limited to: creating tables in Design View

*Create and modify fields. This objective may include but is not limited to: inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties

*Sort and filter records. This objective may include but is not limited to: using Find, Sort, and Filter commands

*Set relationships. This objective may include but is not limited to: defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships

*Import data from a single data file. This objective may include but is not limited to: importing source data into a new table, appending records to an existing table, and importing data as a linked table

Building Forms

*Create forms. This objective may include but is not limited to: using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms

*Apply Form Design Tab options. This objective may include but is not limited to: using the Themes, Controls, Header/Footer, and Tools groups

*Apply Form Arrange Tab options. This objective may include but is not limited to: using the Table, Move, and Position groups

*Apply Form Format Tab options. This objective may include but is not limited to: using the Background and Control Formatting groups

Creating and Managing Queries

*Construct queries. This objective may include but is not limited to: using Select, Make Table, Append, and Crosstab query types

*Manage source tables and relationships. This objective may include but is not limited to: using the Show Table and Remove Table commands, and creating ad hoc relationships

*Manipulate fields. This objective may include but is not limited to: adding, removing, and rearranging fields, and using Sort and Show options

*Calculate totals. This objective may include but is not limited to: using the Total row and using Group By

*Generate calculated fields. This objective may include but is not limited to: performing calculations, using the Zoom box, and using Expression Builder

Designing Reports

*Create reports. This objective may include but is not limited to: creating a Blank Report, using Report Design Tools, and using the Report Wizard

*Apply Report Design Tab options. This objective may include but is not limited to: using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups

*Apply Report Arrange Tab options. This objective may include but is not limited to: using the Table, Move, Position, and Sizing & Ordering groups

*Apply Report Format Tab options. This objective may include but is not limited to: adding color, background images, and conditional formatting

*Apply Report Page Setup Tab options. This objective may include, but is not limited to: using the Page Size andPage Layout groups

*Sort and filter records for reporting. This objective may include but is not limited to: using the Find, Sort, and Filter commands, and using view types

Skill Sets

Exam Skill Standards

Creating and Modifying

Advanced

Document Types

*Create a mail merge document. This objective may include but is not limited to: creating a new recipient list, selecting recipients from Outlook contacts, and conditional mail merge

*Create and manage master documents. This objective may include but is not limited to: converting a document to a master document, converting an outline to a master document, importing subdocuments, and managing subdocuments

*Create forms. This objective may include but is not limited to: creating forms using fields, creating forms using content controls, and protecting forms

Customizing Word 2007

*Customize the Quick Access toolbar. This objective may include but is not limited to: adding commands not in the ribbon, adding separators, and reorganizing commands

*Change default save options. This objective may include but is not limited to: file formats and file locations

*Assign keyboard shortcuts. This objective may include but is not limited to: assigning keyboard shortcuts to an existing macro, a style, a symbol, or autotext

*Manage building blocks. This objective may include but is not limited to: distributing building blocks for reuse and creating a custom building block

Managing Styles

and Templates

*Manage styles. This objective may include but is not limited to: updating style based on selected text, copying styles from one document or template to another, and setting outline levels for styles

*Manage style sets. This objective may include but is not limited to: creating a custom style set, saving a custom style set, and modifying an existing style set

*Manage multilevel lists. This objective may include but is not limited to: creating a multilevel list, linking styles to a multilevel list, modifying an existing multilevel list, and defining a new number format

*Manage templates. This objective may include but is not limited to: attaching a global template, attaching a local template, automatically updating styles using an attached template, saving style changes to the attached template, and saving gallery changes to the attached template

Managing Data Objects and Automation

*Manage objects. This objective may include but is not limited to: creating an object, embedding an existing object, linking to an existing object, and display as icon

*Manage XML. This objective may include but is not limited to: viewing XML tags, moving text with XML tags, validating a document against an XML schema, and attaching a custom XML schema

*Record and edit a macro. This objective may include but is not limited to: recording a macro in a document, recording a macro in a template, inserting a breakpoint, stepping through a macro, and changing actions in a macro

*Manage an existing macro. This objective may include but is not limited to: moving macros between documents (copy a macro, rename a copied macro, import a macro, export a macro) and configuring macro security (digitally sign a macro, macro security levels)

Managing Fields

and References

*Create a custom TOC. This objective may include but is not limited to: including or excluding specific levels, including or excluding specific styles, and modifying the TOC properties

*Insert cross-references within a document. This objective may include but is not limited to: inserting reference to a document element, inserting a specific type of reference, and inserting above/below reference

*Manage fields. This objective may include but is not limited to: updating all fields in a document, converting all fields of a document to text, creating a custom field by using modifiers and switches, changing the display format of a data field (switches), associating properties in the Document Information Panel, and creating a custom document property field

*Create object captioning. This objective may include but is not limited to: autocaptioning different object types (numbering, position) and creating a custom label (numbering, position)

Managing

Content

*Manage visual content. This objective may include but is not limited to: creating a custom watermark and inserting and modifying a SmartArt graphic (modify a SmartArt graphic layout, convert a list to a SmartArt graphic)

*Manage table properties. This objective may include but is not limited to: repeating a header row on subsequent pages, allowing a row to break across pages, and wrapping text around a table

*Apply paste options. This objective may include but is not limited to: setting default paste options and applying paste options for text, tables, graphics, and lists

*Find and replace content. This objective may include but is not limited to: finding and replacing content by format, using special characters, and using wildcards

Managing Documents

*Embed fonts. This objective may include but is not limited to: embedding fonts on the current document, all new documents, all characters, or characters in use

*Apply variable formatting by using sections. This objective may include but is not limited to: restarting page numbering with a different number format, linking and unlinking headers and footers, changing page orientation, changing page size and margins, and applying advanced page setup options (automatically align content vertically on a page, add line numbering)

*Restrict formatting and editing. This objective may include but is not limited to: restricting editing to selected parts of a document, limiting formatting to specific styles, allowing only specific types of editing, and allowing per-user document permissions

*Recover documents. This objective may include but is not limited to: Open and Repair, recovering text from any file, and locating the autorecover file (.asd file)

*Combine multiple documents. This objective may include but is not limited to: Insert file option and Insert objects

Skill Sets

Exam Skill Standards

Capturing Data

*Restrict data entry by using data validation. This objective may include but is not limited to: referencing external data in drop-down lists, validating data by using formulas, and encircling invalid data

Link form controls to cells. This objective may include but is not limited to: scroll bars, check box, label, and drop-down

*Import data from an external source. This objective may include but is not limited to: importing data from a text file, importing data by using a Web query, using the Microsoft Query Wizard to edit an existing query, and referencing data in a database

*Link to data in an external source. This objective may include but is not limited to: referencing data in another workbook, refreshing and editing workbook links, and changing data refresh options to optimize file size

Calculating Data by Using Advanced Formulas

*Create formulas that combine Lookup & Reference and Statistical functions. This objective may include but is not limited to: using common Lookup & Reference functions (HLOOKUP, VLOOKUP, TRANSPOSE, INDIRECT, MATCH, INDEX, CHOOSE) and using common Statistical functions (COUNTIF, COUNTIFS, COUNTBLANK, AVERAGEIF, AVERAGEIFS, FREQUENCY)

*Create formulas that combine Date & Time, Text, and Logical functions. This objective may include but is not limited to: using Date & Time functions, using Text functions, and using common Logical functions (IFERROR, Nested IF, OR, and AND)

*Manage and reference defined names. This objective may include but is not limited to: creating a dynamic named range, creating and referencing a named formula, modifying named ranges by using Names Manager, and navigating across worksheets by using named ranges

Audit formulas. This objective may include but is not limited to: trace dependents, trace precedents, and adding a watch to the Watch Window

Managing Data Ranges

*Consolidate data ranges. This objective may include but is not limited to: consolidating data ranges by position, by category, or with links to a source

*Select and manipulate similar cells and objects. This objective may include but is not limited to: blanks, comments, objects, conditional formats, formulas, visible cells only, and find and replace by format

*Apply advanced filtering. This objective may include but is not limited to: using multiple conditionals on the same column, using the OR condition across multiple columns, and applying filtering to unique records only

*Protect data in a worksheet. This objective may include but is not limited to: locking and unlocking cells, locking and unlocking objects, and hiding formulas

Summarizing and Analyzing Data

*Create PivotTables and PivotCharts. This objective may include but is not limited to: consolidating multiple data ranges by using PivotTables, creating a PivotTable from an existing worksheet, creating a PivotTable linked to an external database, and creating a PivotChart from an existing worksheet

*Modify PivotTable content. This objective may include but is not limited to: grouping (group by dates, group by numbers, group by text), inserting a calculated field, and showing report filter pages

*Perform what-if analysis. This objective may include but is not limited to: using Scenario Manager (create scenarios, compare scenarios), using a data table, using Goal Seek, and using the Solver add-in

Formatting Worksheet and Chart Content

*Create custom number formats. This objective may include but is not limited to: number formats, date and time formats, and conditional number formats

*Define advanced conditional formatting rules by using formulas. This objective may include but is not limited to: creating rules based on dates, creating rules based on numbers, and creating rules based on text

*Add visual elements to a chart. This objective may include but is not limited to: adding a Z axis, adding a second Y axis, and adding analysis indicators (Trendlines, R-squared value, Series lines, High-Low lines)

Managing Macros and User-Defined Functions

*Record and edit a macro. This objective may include but is not limited to: recording a macro and editing a macro in Visual Basic for Applications (VBA)

*Manage existing macros. This objective may include but is not limited to: moving macros between workbooks, assigning a shortcut key to an existing macro, assigning a macro to a button in a worksheet, and configuring macro security levels

*Create a user-defined function (UDF).

Skill Sets

Exam Skill Standards

Creating and Customising

Documents

*Create and format documents

*Layout documents

*Make documents and content easier to find

*Personalise Office Word 2007

Formatting Content

*Format text and paragraphs     

*Manipulate text

*Control pagination

Working with Visual Content

*Insert illustrations

*Format illustrations

*Format text graphically

*Insert and modify text boxes

Organising Content

*Structure content by using Quick Parts

*Use tables and lists to organise content

*Modify tables

*Insert and format references and captions

*Merge documents and data sources

Reviewing Documents

*Navigate documents

*Compare and merge document versions

*Manage tracked changes

*Insert, modify, and delete comments

Sharing and Securing Content

*Prepare documents for sharing

*Control document access

*Attach digital signatures

Skill Sets

Exam Skill Standards

Creating and Manipulating Data

*Insert data by using AutoFill

*Ensure data integrity

*Modify cell contents and formats

*Change Worksheet Views

Formatting Data and Content

*Format worksheets

*Insert and modify rows and columns

*Format cells and cell content

*Format data as a table

Creating and Modifying Formulas

*Reference data in formulas

*Summarise data using a formula.

*Summarise data using subtotals.

*Conditionally summarise data by using a formula 

*Look up data by using a formula. 

*Use conditional logic in a formula. 

*Format or modify text by using formulas.

Presenting Data Visually

*Create and format charts

*Modify charts

*Apply conditional formatting

*Insert and modify illustrations

*Outline data

Collaborating and Securing Data

*Manage changes to workbooks

*Protect and share workbooks

*Prepare workbooks for distribution

*Set print options for printing data, worksheets, and workbooks

*Filter data by using AutoFilter

*Filter and sort data by using conditional formatting

*Filter and sort data by using cell attributes

Skill Sets

Exam Skill Standards

Creating and Formatting Presentations

*Create new presentations

*Customise slide masters.

*Add elements to slide masters

*Create and change presentation elements

*Arrange slides

Creating and Formatting Slide Content

*Insert and format text boxes.

*Manipulate text.

*Add and link existing content to presentations

*Apply, customise, modify, and remove animations

Working with Visual Content

*Create SmartArt diagrams

*Modify SmartArt diagrams.

*Insert illustrations and shapes.

*Modify illustrations

*Arrange illustrations and other content

*Insert and modify charts

*Insert and modify tables

Collaborating on and Delivering

Presentations

*Review presentations

*Protect presentations.

*Secure and Share Presentations

*Prepare printed materials

*Prepare for and rehearse presentation delivery

Skill Sets

Exam Skill Standards

Structuring a Database

*Define data needs and types

*Define and print table relationships

*Add, set, change, or remove primary keys

*Split databases

Creating and Formatting

Database Elements

*Create Databases

*Create and modify tables

*Create reports and forms

*Modify the design of reports and forms

*Enter and modify data

*Enter, edit, delete and navigate among records

*Find, replace and import data

*Attach documents to and detach from records

Queries

*Create and modify queries

*Present and share data

*Sort and filter data

*Export data

Database

*Save database objects as other file types

*Print database objects

*Manage and maintain databases

*Perform routine database operations

*Manage databases

Skill Sets

Exam Skill Standards

Managing Messaging

*Create and send e-mail message

*Create and manage your signature and automated messages

*Managed e-mail message attachments

*Configure e-mail message sensitivity and

importance settings

*Configure e-mail message security settings

*Configure e-mail message delivery reports

*View e-mail messages

Managing Scheduling

*Create appointments, meetings and events

*Send meeting requests

*Update, cancel, and respond to meeting requests

*Customise calendar settings

*Share your calendar with others

*View other calendars

Managing Tasks

*Create and modify contacts

*Accept, decline, assign, update, and respond to tasks

Managing Contacts and

Personal Contacts Information

*Create and modify contacts

*Edit and use electronic business cards

*Create and modify distribution lists

*Create a secondary address book

Organising Information

*Categorise items by colour

*Create and manage data files

*Organise mail folders

*Locate items by using the search feature

*Create, modify, and remove rules to manage e-mail messages.

Skill Sets

Exam Skill Standards

Protecting Your Computer

*Managing Windows Firewall

*Manage Malicious software (malware) Protection

*Configure Windows Update Settings

*Lock a Computer

*Manage Windows Internet Explorer Security

*Configure Local User Accounts

Managing Mobile & 

Remote Computing

*Manage the Computer Power State

*Manage Network Connections

*Manage Remote Access to your Computer

*Connect to another Computer

*Access files stored in shared network folders when your computer is offline

Managing Software, Disks and Devices

*Manage Software

*Manage Disks

*Manage Devices and Drivers

*Manage Display Settings

*Configure Multiple Monitors

*Install and Configure a Printer

Managing Files & Folders 

*Manage Windows Explorer Settings

*Manage and Secure Folders

*Share Folders

*Back up and Restore Files and Folders

Collaborating with Other People

*Collaborate in Real Time Present information to an audience

Customising Your Windows Vista Experience

*Customise and Modify the Start Menu

*Customise the taskbar

*Personalise the Appearance and Sound of a Computer

*Manage the Windows Sidebar

Optimising and Troubleshooting Your Computer

*Increase Processing speed

*Locate Trouble shooting and system information

*Repair a Network Connection

*Recover from Software Errors

*Troubleshooting Printing Errors

*Recover the Operating System from a problem

*Request and Mange Remote Assistance

Skill Sets

Exam Skill Standards

Creating and Modifying Advanced Document Types

*Create a mail merge document. This objective may include but is not limited to: creating a new recipient list, selecting recipients from Outlook contacts, and conditional mail merge

*Create and manage master documents. This objective may include but is not limited to: converting a document to a master document, converting an outline to a master document, importing subdocuments, and managing subdocuments

*Create forms. This objective may include but is not limited to: creating forms using fields, creating forms using content controls, and protecting forms

Customizing Word 2007

*Customize the Quick Access toolbar. This objective may include but is not limited to: adding commands not in the ribbon, adding separators, and reorganizing commands

*Change default save options. This objective may include but is not limited to: file formats and file locations

*Assign keyboard shortcuts. This objective may include but is not limited to: assigning keyboard shortcuts to an existing macro, a style, a symbol, or autotext

*Manage building blocks. This objective may include but is not limited to: distributing building blocks for reuse and creating a custom building block

Managing Styles and Templates

*Manage styles. This objective may include but is not limited to: updating style based on selected text, copying styles from one document or template to another, and setting outline levels for styles

*Manage style sets. This objective may include but is not limited to: creating a custom style set, saving a custom style set, and modifying an existing style set

*Manage multilevel lists. This objective may include but is not limited to: creating a multilevel list, linking styles to a multilevel list, modifying an existing multilevel list, and defining a new number format

*Manage templates. This objective may include but is not limited to: attaching a global template, attaching a local template, automatically updating styles using an attached template, saving style changes to the attached template, and saving gallery changes to the attached template

Managing Data Objects and Automation

*Manage objects. This objective may include but is not limited to: creating an object, embedding an existing object, linking to an existing object, and display as icon

*Manage XML. This objective may include but is not limited to: viewing XML tags, moving text with XML tags, validating a document against an XML schema, and attaching a custom XML schema

*Record and edit a macro. This objective may include but is not limited to: recording a macro in a document, recording a macro in a template, inserting a breakpoint, stepping through a macro, and changing actions in a macro

*Manage an existing macro. This objective may include but is not limited to: moving macros between documents (copy a macro, rename a copied macro, import a macro, export a macro) and configuring macro security (digitally sign a macro, macro security levels)

Managing Fields and References

*Create a custom TOC. This objective may include but is not limited to: including or excluding specific levels, including or excluding specific styles, and modifying the TOC properties

*Insert cross-references within a document. This objective may include but is not limited to: inserting reference to a document element, inserting a specific type of reference, and inserting above/below reference

*Manage fields. This objective may include but is not limited to: updating all fields in a document, converting all fields of a document to text, creating a custom field by using modifiers and switches, changing the display format of a data field (switches), associating properties in the Document Information Panel, and creating a custom document property field

*Create object captioning. This objective may include but is not limited to: autocaptioning different object types (numbering, position) and creating a custom label (numbering, position)

Managing Content

*Manage visual content. This objective may include but is not limited to: creating a custom watermark and inserting and modifying a SmartArt graphic (modify a SmartArt graphic layout, convert a list to a SmartArt graphic)

*Manage table properties. This objective may include but is not limited to: repeating a header row on subsequent pages, allowing a row to break across pages, and wrapping text around a table

*Apply paste options. This objective may include but is not limited to: setting default paste options and applying paste options for text, tables, graphics, and lists

*Find and replace content. This objective may include but is not limited to: finding and replacing content by format, using special characters, and using wildcards

Managing Documents

*Embed fonts. This objective may include but is not limited to: embedding fonts on the current document, all new documents, all characters, or characters in use

*Apply variable formatting by using sections. This objective may include but is not limited to: restarting page numbering with a different number format, linking and unlinking headers and footers, changing page orientation, changing page size and margins, and applying advanced page setup options (automatically align content vertically on a page, add line numbering)

*Restrict formatting and editing. This objective may include but is not limited to: restricting editing to selected parts of a document, limiting formatting to specific styles, allowing only specific types of editing, and allowing per-user document permissions

*Recover documents. This objective may include but is not limited to: Open and Repair, recovering text from any file, and locating the autorecover file (.asd file)

*Combine multiple documents. This objective may include but is not limited to: Insert file option and Insert objects

Skill Sets

Exam Skill Standards

Capturing Data

*Restrict data entry by using data validation. This objective may include but is not limited to: referencing external data in drop-down lists, validating data by using formulas, and encircling invalid data

*Link form controls to cells. This objective may include but is not limited to: scroll bars, check box, label, and drop-down

*Import data from an external source. This objective may include but is not limited to: importing data from a text file, importing data by using a Web query, using the Microsoft Query Wizard to edit an existing query, and referencing data in a database

*Link to data in an external source. This objective may include but is not limited to: referencing data in another workbook, refreshing and editing workbook links, and changing data refresh options to optimize file size

Calculating Data by Using Advanced Formulas

*Create formulas that combine Lookup & Reference and Statistical functions. This objective may include but is not limited to: using common Lookup & Reference functions (HLOOKUP, VLOOKUP, TRANSPOSE, INDIRECT, MATCH, INDEX, CHOOSE) and using common Statistical functions (COUNTIF, COUNTIFS, COUNTBLANK, AVERAGEIF, AVERAGEIFS, FREQUENCY)

*Create formulas that combine Date & Time, Text, and Logical functions. This objective may include but is not limited to: using Date & Time functions, using Text functions, and using common Logical functions (IFERROR, Nested IF, OR, and AND)

*Manage and reference defined names. This objective may include but is not limited to: creating a dynamic named range, creating and referencing a named formula, modifying named ranges by using Names Manager, and navigating across worksheets by using named ranges

*Audit formulas. This objective may include but is not limited to: trace dependents, trace precedents, and adding a watch to the Watch Window

Managing Data Ranges

*Consolidate data ranges. This objective may include but is not limited to: consolidating data ranges by position, by category, or with links to a source

*Select and manipulate similar cells and objects. This objective may include but is not limited to: blanks, comments, objects, conditional formats, formulas, visible cells only, and find and replace by format

*Apply advanced filtering. This objective may include but is not limited to: using multiple conditionals on the same column, using the OR condition across multiple columns, and applying filtering to unique records only

*Protect data in a worksheet. This objective may include but is not limited to: locking and unlocking cells, locking and unlocking objects, and hiding formulas

Summarizing and Analyzing Data

*Create PivotTables and PivotCharts. This objective may include but is not limited to: consolidating multiple data ranges by using PivotTables, creating a PivotTable from an existing worksheet, creating a PivotTable linked to an external database, and creating a PivotChart from an existing worksheet

*Modify PivotTable content. This objective may include but is not limited to: grouping (group by dates, group by numbers, group by text), inserting a calculated field, and showing report filter pages

*Perform what-if analysis. This objective may include but is not limited to: using Scenario Manager (create scenarios, compare scenarios), using a data table, using Goal Seek, and using the Solver add-in

Formatting Worksheet and Chart Content

*Create custom number formats. This objective may include but is not limited to: number formats, date and time formats, and conditional number formats

*Define advanced conditional formatting rules by using formulas. This objective may include but is not limited to: creating rules based on dates, creating rules based on numbers, and creating rules based on text

*Add visual elements to a chart. This objective may include but is not limited to: adding a Z axis, adding a second Y axis, and adding analysis indicators (Trendlines, R-squared value, Series lines, High-Low lines)

Managing Macros and User-Defined Functions

*Record and edit a macro. This objective may include but is not limited to: recording a macro and editing a macro in Visual Basic for Applications (VBA)

*Manage existing macros. This objective may include but is not limited to: moving macros between workbooks, assigning a shortcut key to an existing macro, assigning a macro to a button in a worksheet, and configuring macro security levels

*Create a user-defined function (UDF).

Skill Sets

Exam Skill Standards

Creating Content

*Insert and edit text, symbols and special characters

*Insert frequently used and pre-defined text

*Navigate to specific content

*Insert, position and size graphics

*Create and modify diagrams and charts

*Locate, select and insert supporting information

Organising Content

*Insert and modify tables

*Create bulleted lists, numbered lists and outlines

*Insert and modify hyperlinks

Formatting Content 

*Format text

*Format paragraphs

*Apply and format columns

*Insert and modify content in headers and footers

*Modify document layout and page setup

Collaborating

*Circulate documents for review

*Compare and merge documents

*Insert, view and edit comments

*Track, accept and reject proposed changes

Formatting and Managing Documents

*Create new documents using templates

*Review and modify document properties

*Organise documents using file folders

*Save documents in appropriate formats for different uses

*Print documents, envelopes and labels

*Preview documents and Web pages

*Change and organise document views and windows

Skill Sets

Exam Skill Standards

Creating Data and Content

*Enter and edit cell content

*Navigate to specific cell content

*Locate, select and insert supporting information

*Insert, position, and size graphics

Analysing Data

*Filter lists using AutoFilter

*Sort lists

*Insert and modify formulas

*Use statistical, date and time, financial, and logical               functions

*Create, modify, and position diagrams and charts                  based on worksheet data

Formatting Data and Content

*Apply and modify cell formats

*Apply and modify cell styles

*Modify row and column formats

*Format worksheets

Collaborating

*Insert, view and edit comments

Managing Workbooks

*Create new workbooks from templates

*Insert, delete and move cells

*Create and modify hyperlinks

*Organize worksheets

*Preview data in other views

*Customise Window layout

*Setup pages for printing

*Print data

*Organise workbooks using file folders

*Save data in appropriate formats for different uses

Skill Sets

Exam Skill Standards

Structuring Databases

*Create Access databases

*Create and modify tables

*Define and modify field types

*Modify field properties

*Create and modify one-to-many relationships

*Enforce referential integrity

*Create and modify queries

*Create forms

*Add and modify form controls and properties

*Create reports

*Add and modify report control properties

*Create a data access page

Entering Data

*Enter, edit and delete records

*Find and move among records

*Import data to Access

Organising Data

*Create and modify calculated fields and aggregate                     functions

*Modify form layout

*Modify report layout and page setup

*Format datasheets

*Sort records

*Filter records

Managing Databases

*Identify object dependencies

*View objects and object data in other views

*Print database objects and data

*Export data from Access

*Back up a database

*Compact and repair databases

Skill Sets

Exam Skill Standards

Creating Content

*Create new presentations from templates

*Insert and edit text-based content

*Insert tables, charts and diagrams

*Insert pictures, shapes and graphics

*Insert objects

Formatting Content

*Format text-based content

*Format pictures, shapes and graphics

*Format slides

*Apply animation schemes

*Apply slide transitions

*Customise slide templates

*Work with masters

Collaborating

*Track, accept and reject changes in a presentation

*Add, edit and delete comments in a presentation

*Compare and merge presentations

Managing and Delivering Presentations 

*Organise a presentation

*Set up slide shows for delivery

*Rehearse timing

*Deliver presentations

*Prepare presentations for remote delivery

*Save and publish presentations

*Print slides, outlines, handouts, and speaker notes

*Export a presentation to another Microsoft Office                    program

Skill Sets

Exam Skill Standards

Messaging

*Organising

*Attach files to items

*Create and modify a personal signature for messages

*Modify e-mail message settings and delivery options

*Create and edit contacts

*Accept, decline, and delegate tasks

Scheduling

*Create and modify appointments, meetings, and events

*Update, cancel, and respond to meeting requests

*Customise Calendar settings

*Create, modify, and assign tasks

Organising

*Create and modify distribution lists

*Link contacts to other items

*Create and modify notes

*Organise items

*Organise items using folders

*Search for items

*Save items in different file formats

*Assign items to categories

*Preview and print items

Skill Sets

Exam Skill Standards

Organising and Analysing Data

*Use subtotals

*Define and apply advanced filters

*Group and outline data

*Use data validation

*Create and modify list ranges

*Add, show, close, edit, merge and summarise                    scenarios

*Perform data analysis using automated tools

*Create PivotTable and PivotChart reports

*Use Lookup and Reference functions

*Use Database functions

*Trace formula precedents, dependents and errors

*Locate invalid data and formulas

*Watch and evaluate formulas

*Define, modify and use named ranges

*Structure workbooks using XML

Formatting Data and Content

*Create and modify custom data formats

*Use conditional formatting

*Format and resize graphics

*Format charts and diagrams

Collaborating

*Protect cells, worksheets, and workbooks

*Apply workbook security settings

*Share workbooks

*Merge workbooks

*Track, accept, and reject changes to workbooks

Managing Data and Workbooks

*Import data to Excel

*Export data from Excel

*Publish and edit Web worksheets and workbooks

*Create and edit templates

*Consolidate data

*Define and modify workbook properties

Customising Excel

*Customise toolbars and menus

*Create, edit, and run macros

*Modify Excel default settings

Skill Sets

Exam Skill Standards

Formatting Content

*Create custom styles for text, tables and lists

*Control pagination

*Format, position and resize graphics using advanced                   layout features

*Insert and modify objects

*Create and modify diagrams and charts using data from               other sources

Organising Content

*Sort content in lists and tables

*Perform calculations in tables

*Modify table formats

*Summarise document content using automated tools

*Use automated tools for document navigation

*Merge letters with other data sources

*Merge labels with other data sources

*Structure documents using XML

Formatting Documents

*Create and modify forms

*Create and modify document background

*Create and modify document indexes and tables

*Insert and modify endnotes, footnotes, captions, and cross-references

*Create and manage master documents and subdocuments

Collaborating

*Modify track changes options

*Publish and edit Web documents

*Manage document versions

*Protect and restrict forms and documents

*Attach digital signatures to documents

*Customise document properties

Customising Word

*Create, edit, and run macros

*Customise menus and toolbars

*Modify Word default settings

Skill Sets

Exam Skill Standards

Computer Hardware

* Identify different types of computers, how computers work (process information) and how individual computers fit into larger systems

*  Identify the function of computer hardware components and common problems associated with individual components

*  Identify issues relating to computer performance and how it is affected by different components of the computer

*  Identify the factors that go into a decision on how to purchase a computer or select a computer for work, school, or home

Computer Software

*  Identify how software works and how software and hardware work together to perform computing tasks

*  Identify different types of software, the tasks for which each type of software is most suited, and the popular programs in each software category

Using an Operating System

*  Identify what an operating system is and how it works

*  Be able to manipulate and control the Windows desktop, files and disks

*  Be able to change system settings and install software

Skill Sets

Exam Skill Standards

Common Programme Functions

*  Be able to start and exit a Windows application and utilise sources of online help

*  Identify common on-screen elements of Windows applications, change application settings, and manage files within an application

*  Perform common editing (cut, copy, paste, spellcheck, etc.) and formatting (fonts, margins, tabs, etc.) functions

*  Perform common printing functions

Word Processing Functions

*  Be able to format text and documents including the ability to use automatic formatting tools

*  Be able to add tables and graphics to a document

Spreadsheet Functions

*  Be able to modify worksheet data and structure

*  Be able to sort data and manipulate data using formulas and functions

*  Be able to format a worksheet

*  Be able to add pictures and charts to a worksheet

Skill Sets

Exam Skill Standards

Networks and the Internet

*  Identify network fundamentals and the benefits and risks of network computing

*  Identify the relationship between computer networks, other communications networks (like the telephone network) and the Internet

Electronic Mail

*  Identify how electronic mail works

*  Identify how to use an electronic mail application

*  Identify the appropriate use of e-mail and e-mail related "netiquette"

Using the Internet

*  Identify different types of information sources on the Internet

*  Be able to use a Web browsing application

*  Be able to search the Internet for information

The Impact of Computing and the Internet on Society

*  Identify how computers are used in different areas of work, school, and home

*  Identify the risks of using computer hardware and software

*  Identify how to use the Internet safely and legally