Microsoft Office Suite

Office workspace basics

• Basic window elements
• Exploring Office backstage
• Working with the ribbon
• Customising the quick access toolbar
• Using the status bar

Introduction to Word

• What is Word
• How to open a document
• Changing views
• Navigating documents
• How to create documents
• Using templates
• Saving documents
• How to close documents

Creating and editing text

• Entering text
• How to select text
• Moving and copying text
• Using repeat, undo and redo
• Using autocorrect
• Inserting symbols
• Inserting fields

Formatting text

• Introduction to formats and styles
• Applying font formats
• Text alignment
• Changing indents and spacing
• Working with tabs
• Applying styles
• Modifying styles
• Revealing and clearing formats
• Using the format painter

Designing page layouts

• Exploring page layout options
• Changing margins
• Adding sections and page breaks
• Creating columns
• Adding bullets and numbering
• Applying borders and shading

Mail merge

• Envelopes
• Labels
• Merging letters

Collaborating on documents

• Adding comments
• Tracking document changes
• Reviewing tracked changes
• E-mailing documents for review
• Combining reviewed documents
• Using the document inspector
• Creating folders

Printing and converting documents

• Using print preview
• Printing documents
• Printing envelopes and labels
• Saving documents in different formats
• Saving documents as web pages

Working with graphics

• Inserting pictures
• Resizing and moving pictures
• Inserting shapes
• Adding text boxes
• Creating charts
• Inserting SmartArt

Lists

• Creating ordered and unordered lists
• Multilevel list

Columns

• Using and formatting columns

Creating and formatting tables

• Creating a table
• Converting text to a table
• Formatting a table
• Modifying the table layout
• Using table templates

Refining document content

• Exploring the research task pane
• Using the thesaurus
• How to find and replace text
• Correcting spelling and grammar
• Using word count
• Working with document properties
• Adding a hyperlink

Office workspace basics

• Basic window elements
• Exploring Office backstage
• Working with the ribbon
• Customising the quick access toolbar
• Working with keytips
• Using the status bar

Introduction to Excel

• What is Excel
• Getting to know the Excel window
• Moving the cell selector
• Opening a workbook
• Navigating a workbook
• Selecting cells
• Creating workbooks
• Saving and closing a workbook

Entering and editing data

• Entering text, numbers and dates
• Editing data
• Using autocomplete and autofill
• Copying data
• Moving and clearing data
• Using undo and redo
• Finding and replacing data

Introduction to formulas and functions

• What are formulas and functions
• Entering formulas
• Entering functions
• Using the insert function tool
• Using autosum
• Copying and moving formulas

Working with functions

• Using functions
• Testing conditions with if
• Using date and time functions
• Using linked values in formulas
• Copying formula values
• Controlling automatic calculations
• Conditional formatting
• Vlookup and Hlookup
• Pivot tables and charts

Formatting data

• Introduction to formatting
• Applying number formats
• Applying font formats
• Changing cell alignment
• Applying cell styles
• Copying formats
• Clearing formats
• Finding and replacing formats

Formatting worksheets

• Inserting and deleting rows and columns
• Inserting and deleting cells
• Adjusting column and row sizes
• Hiding worksheet components
• Inserting and deleting worksheets
• Copying and moving worksheets
• Customising sheet tabs
• Adding a worksheet background

Adding charts and graphics

• Creating a chart
• Enhancing a chart
• Modifying chart data
• Changing chart types
• Drawing shapes
• Inserting pictures
• Creating SmartArt

Viewing and printing workbooks

• Changing view options
• Splitting and freezing a worksheet
• Sorting and filtering data
• Customising the page layout
• Adding headers and footers
• Modifying page breaks
• Previewing and printing the worksheet

Managing workbooks

• Arranging multiple workbooks
• Adding hyperlinks
• Working with comments
• Saving workbooks

Office workspace basics

• Basic window elements
• Exploring Office backstage
• Working with the ribbon
• Customising the quick access toolbar
• Working with keytips
• Using the status bar
• Getting help

Introduction to PowerPoint

• What is PowerPoint
• Opening a presentation
• Changing views
• Using grids and guides
• Saving and closing a presentation
• Managing files and folders

Adding and formatting text

• Creating a new presentation
• Entering text on a slide
• Changing text formats
• Using the format painter
• Formatting bullets
• Aligning text
• Working with tabs

Customising presentations

• Using templates
• Adding a slide
• Changing a slide layout
• Adding a picture
• Customising templates
• Using the slide master
• Adding headers and footers
• Adding speaker notes
• Arranging slides

Working with shapes and pictures

• Introduction to drawing tools
• Inserting shapes
• Adding text to shapes
• Formatting shapes
• Inserting and formatting picture files
• Arranging objects
• Adding an action button

Adding objects and effects

• Adding a table
• Adding a chart
• Adding SmartArt
• Adding a hyperlink
• Adding transition effects
• Adding animation effects
• Adding a sound clip
• Adding a video

Useful tools

• Working in outline view
• Importing an outline from Word
• Finding and replacing text
• Using proofing tools
• Using autocorrect
• Printing your presentation

Delivering your presentation

• Creating a custom show
• Rehearsing a slide show
• Collaborating on presentations
• Packaging a presentation
• Running a slide show
• Broadcasting a presentation to the web

Office workspace basics

• Basic window elements
• Exploring Office backstage
• Working with the ribbon
• Customising the quick access toolbar
• Working with keytips
• Using the status bar
• Getting help

Introduction to Access

• What is an Access database
• Opening a database file
• Exploring database objects
• Creating a database
• Changing views
• Printing database objects
• Saving and closing a database file

Working with tables

• What is a table
• Working with datasheets
• Moving among records
• Updating records
• Adding records to a table
• Selecting rows and columns
• Finding records
• Sorting records
• Filtering records

Designing tables

• Adding a table to a database
• Adding fields to a table
• Adding a lookup field
• Setting a primary key
• Saving design changes
• Importing data
• Exporting data
• Performing database maintenance

Creating and running queries

• What is a query
• Creating a query
• Working with queries
• Saving and running a query
• Creating calculated fields
• Understanding query properties
• Creating multi-table select queries
• Joining tables
• Enforcing referential integrity

Using forms

• What is a form
• Using the form tool
• Creating a form with the form wizard
• Working in design view
• Changing the form layout
• Using calculated controls
• Working with records on a form

Generating reports

• What is a report
• What is a report tool
• Previewing and printing a report
• Saving a report
• Designing a report
• Changing a report layout
• Understanding controls
• Using a calculated control
• Analysing dependencies

Completing the desktop application

• Designing the navigation form
• Creating a database password
• Creating a backup of database

Office workspace basics

• Basic window elements
• Exploring Office backstage
• Working with the ribbon
• Customising the quick access toolbar
• Using the status bar
• Getting help

Introduction to Outlook

• What is Outlook
• Using the navigation pane
• Working with folders
• Exploring the inbox
• Reading your e-mail
• Replying to an e-mail message
• Forwarding a message
• Sending a new message
• Adding an attachment
• Viewing sent items

Managing messages

• Flagging messages for follow up
• Using multiple e-mail accounts
• Adding a signature
• Formatting messages
• Setting message priorities
• Setting delivery options
• Using the rules wizard
• Printing your e-mail
• Saving messages

Maintaining contacts

• Adding contacts
• Viewing contact information
• Modifying and deleting contacts
• Creating a contact group
• Sending a message to a contact
• Using Outlook to call a contact
• Printing contact information
• Exporting contact information
• Importing contact information

Coordinating calendars

• Viewing calendar information
• Scheduling appointments
• Adding recurring appointments
• Exploring calendar settings
• Planning a meeting
• Scheduling a meeting
• Responding to meeting requests
• Printing your calendar

Scheduling tasks

• Creating tasks
• Using the task form
• Viewing tasks
• Assigning tasks to others
• Responding to task requests
• Keeping notes

Organising information

• Managing folders
• Copying items among folders
• Locating items
• Creating categories
• Arranging items
• Controlling junk e-mail
• Design custom views

Introduction to OneNote

• What is OneNote
• Using OneNote
• Getting started with OneNote
• Exploring the OneNote user interface
• Working with the ribbon
• Understanding backstage view
• Customising the quick access toolbar
• Getting help

Collecting information

• Creating and configuring notebooks
• Creating pages and subpages
• Taking and saving notes
• Entering content onto a page
• Formatting notes
• Spellchecking notes

Adding and annotating content

• Adding and organising sections and pages
• Copying content to notebooks
• Attaching files
• Adding screen-clippings to notebooks
• Adding pictures
• Introducing penmode
• Converting handwriting
• Adding equations
• Working with audio and video
• Tagging notes

Formatting and sharing notebooks

• Sorking with notebook templates
• Setting default templates to sections
• Changing backgrounds
• Printing notebook content
• Saving and converting notebooks