MS Word Intermediate

Course content

Application Options and File Properties View and change application options • View and change document properties

Column Formatting Create and use newspaper columns • Modify column structure • Balance columns in equal lengths

Inserting and Removing Sections Use different types of section break • Delete section breaks • Copy and paste page layout settings with text

Creating an Envelope or Label Prepare and print envelopes and labels

Formatting a Tabbed List Create a tabbed list • Modify tab stop settings and leader characters

Using Outline View Apply outline levels to styles and paragraphs • Show and hide outline levels • Promote and demote text between outline levels • Change the order of text using outlines • Use the Document Map and thumbnails to navigate in other views • View a document in two window panes • Print a specific range of pages

Find and Replace Formatting Find and replace formatting and special/hidden characters • Find and replace different word forms

Creating a Table Draw or create a table using the Draw Table tool or Insert Table command • Apply Autoformatting to a table • Move the insertion point around in a table • Edit cell contents • Insert and delete columns and rows • Change the height and width of rows and columns • Add borders and shading to a table

AutoText and AutoFormat Set up AutoCorrect to correct errors as you type • Create and apply frequently used AutoText • Use Smart Tags • Use AutoFormat • Apply a theme

Inserting a Chart Insert a new graph using Microsoft Graph • Reposition, resize, and delete a graph object • Modify an embedded graph object • Change data using the datasheet • Change the chart type

Creating a Diagram Create a diagram or organization chart • Modify the layout of a diagram or organization chart • Format a diagram or organization chart • Apply an AutoFormat to a diagram or organization chart

Distributing a Document Save a document as a plain text file • Save a document for a different application or as a Rich Text File • Save a document as a template

Publishing to a Web Page Use Web Page Preview • Save a document as a web page

Creating a Hyperlink Create a hyperlink to a file, place in a document, or place on the web • Create an email hyperlink • Use or modify a hyperlink in a document

Tracking and Reviewing Changes Track changes to a document • Accept or reject changes

Comparing Documents Compare documents side by side • Compare and merge documents

Routing Documents for Review Remove personal information from a document file • Send a document for review by email • Route a document to several reviewers

Character Effects Set character spacing options • Apply special text effects • Format a paragraph with a dropped capital • Insert animated text

Research Tools Translate text to and from different languages • Spell check text in different languages • Research words and phrases using web reference tools 

MS Excel Intermediate

Course content

Data Lists Create a data list • Use a form to view, sort, and enter records • Perform single and multi-level sorts • Filter a list using AutoFilter

Borders and Shading Apply cell borders and shading • Apply AutoFormat

Viewing a Large Worksheet Go To a specific cell or named range • Split a worksheet into different viewing panes • Freeze and unfreeze panes as worksheet titles • View a workbook in multiple windows • Hide and unhide rows and columns • Hide and unhide worksheets and workbooks

Managing Worksheets Switch between worksheets • Enter and edit data on multiple worksheets • Copy data between worksheets and workbooks • Insert and delete worksheets • Move and copy a worksheet • Rename a worksheet • Change the colour of a worksheet tab

Logical and Nested Functions Use the IF, AND, OR, and NOT functions in formulas • Use nested functions

Financial Functions Use financial functions (PMT, FV, PV, NPV, RATE, IRR, SLN)

String, Date, and Time Functions Join strings (CONCATENATE, &) • Extract text from a string (LEFT, RIGHT, MID) • Change case (UPPER, LOWER, PROPER) • Find and replace text within a string (FIND, REPLACE, SUBSTITUTE, TRIM, CLEAN, LEN) • Convert between text and number values (TEXT, VALUE, FIXED, DOLLAR) • Insert specific characters from the Windows character set (CHAR, CODE) • Enter the date and time using functions (TODAY, NOW, DATE, TIME) • Return selected parts of a date or time value (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) • Perform calculations using date/time values • Use other date functions (NETWORKDAYS, WEEKDAYS, WEEKNUM)

Statistical Functions Use counting functions • Use averaging functions • Use other statistical functions (MIN, MAX, MEDIAN, MODE, STDEV)

Creating and Applying Styles Define a style • Apply a style to worksheet cells • Remove a style from cells • Modify an existing style • Copy styles between workbooks

Proofing Tools Use AutoCorrect • Use Find and Replace • Check spelling across the worksheet

Adding Comments Add a comment • Review, edit, and delete comments • Print comments

Formatting a Chart Add, remove, move, resize, and modify chart elements (titles, labels, legend, axes, gridlines) • Format chart elements (borders, patterns, font, values) • Format chart axes (number format, text, line width) • Format data series (scale, shading, spacing, width)

Inserting Pictures and Clip Art Understand Object Linking and Embedding • Insert a Clip Art object • Insert a picture from a file • Insert a Print Screen graphic • Insert an image from a scanner or digital cameravModify a picture using the Picture toolbar • Crop a picture

Distributing a Workbook Save a workbook as a plain text file • Save a workbook for a different application • Save a workbook as a template

Creating a Hyperlink Create a hyperlink to a file, place in a document, or place on the web • Create an email hyperlink • Use or modify a hyperlink in a worksheet

Research Tools Translate text to and from different languages • Spell check text in different languages • Research words and phrases using web reference tools

MS PowerPoint (Level 2)

Course content

Using Master Slides Modify the Slide, Title, Notes, and Handouts Masters • Work with multiple masters • Insert headers and footers and slide numbering • Create and modify a presentation template

Colour Schemes Apply a colour scheme to selected slides • Customise a colour scheme

Background Effects Apply different slide background colours • Apply texture, pattern, and picture fill backgrounds

Margins, Indents, and Tabs Change margin settings in a text box • Change the position of indents • Set the position of tab stops

Arranging Objects Arrange and transform objects • Set options for the drawing grid • Group and ungroup shapes

Inserting a Chart Insert a new graph using Microsoft Graph • Reposition, resize, and delete a graph object • Modify an embedded graph object • Change data using the datasheet • Change the chart type

Creating a Diagram Create a diagram or organisation chart • Modify the layout of a diagram or organisation chart • Format a diagram or organisation chart • Apply an AutoFormat to a diagram or organisation chart

Drawing a Flowchart Draw and modify connecting shapes • Modify points on a line

WordArt Insert and format WordArt text

Using Tables on Slides Create a table in PowerPoint • Modify a PowerPoint table • Add a table from Word

Importing and Exporting Data Understand Object Linking and Embedding • Insert or paste a linked or embedded object • Edit an OLE object • Import text from Word • Export an outline or slides to Word • Create a new presentation from existing slides • Copy a slide from one presentation into another

Action Settings Create a self-running or looping slide show • Set and rehearse automatic slide timings • Use an action button as a hyperlink • Use any text or object as a hyperlink • Use action settings to open or edit an object or application • Use action settings to play a sound

Creating a Custom Show Define and manage custom shows

Distributing a Presentation Save a presentation in a different file format • Save a slide as a graphic • Save a drawing as a picture file

Publishing a Web Presentation Format a presentation for web publishing • Publish a presentation to the web • View a presentation on the web • Save HTML to a specific target browser

Packaging a Presentation Package a presentation for another computer • Save embedded fonts in a presentation • Change the presentation output format • Use Presenter View to deliver a presentation • Export to 35mm slides

Collaborating on a Presentation Send or save a presentation for review • Add and edit comments • Merge changes made by reviewers

Research Tools Translate text to and from different languages • Spell check text in different languages • Research words and phrases using web reference tools