Course Content

Word Expert

Advanced Formatting:

• Customising Paragraphs
• Control Pagination

Work with large documents

• Create a new master document, create a sub document
• Create a table of contents - Modify and update an existing table of contents
• Create sections in a document; work with columns, insert/delete column breaks

Customising Tables

• Use Excel data in tables, prefrom calculations in word tables
• Creating and modifying graphics, create, modify and position graphics
• Create and modify charts using data from other applications, align text and graphics
• Create, edit and run macros
• Customise menus and toolbars

Workgroup Collaboration

• Track, accept and reject changes to a document
• Create and edit web documents in word, create versions, protect documents
• Mail merge letters and labels with a Word, Excel or Access data source

Excel Expert

Advanced Editing:

• Create, edit, delete a named range, apply automatic formatting
• Create a custom number formats, use conditional formatting options
• Use paste special, import a text file and delimit by comma, space or tab
• Freeze rows/columns, hide/unhide columns, rows or worksheets
• Use sub totals, apply/remove password protection to workbook or worksheet

Data Handling

• Multiple sorting on data. Use advanced filtering options
• Link data within a worksheet and between workbooks
• Link data/chart into a word document
• Use data consolidation using 3D sum function
• Create and edit a template

Charts

• Change angle of pie chart, format chart axes or text; explode segments in a pie chart
• Delete/modify data changes in a chart
• Widen the gap between bars in a chart
• Insert an images in a 2D chart

Advanced Functions

• Date and time functions
• Mathematical functions
• Statistical functions
• Text functions, financial functions
• Use lookup functions
• Logical and Database functions
• Nested functions

Analyse and Audit Data

• Analyse data in different ways
• Create Pivot tables, Pivot charts, and Pivot table/Pivot chart reports
• Create named scenarios from defined cell ranges
• Create a Scenario summary
• Auditing, audit a worksheet; display all formulas in a worksheet

Access Core

Database Design

• Designing and planning a database
• Lookup fields, default values, input masks in designing a table for easier data entry
• Use database wizards

Database Relationships

• Understand the basis for creating relationship
• Create, modify a one-one, one-many relationship between tables
• Modify a many-many relationship between tables
• Apply and use referential integrity in a relationship

Queries

• Extract information based on criteria from the database using the query, select and sort tools available
• Sort and filter data by selection and by form
• Group totals and use functions in a query

Forms and Reports

• Create and modify forms and reports
• Sub-forms and Sub-reports
• Move and add new controls to forms and reports
• Calculated control fields in reports
• Integrate with other Office Applications

Publish on the Web

• Create static Web pages and a data access page
• Publish database pages on the Web

PowerPoint Core

Presentation Creation

• Create, format, modify and prepare presentations using different slide layouts for display and printed distribution
• Duplicate or move text, pictures and chats within the presentation and between presentations

Slide Master

• Use the master slides
• Edit and format slides in a presentation

Slide Objects

• Insert charts, organisational charts, diagrams and tables to slides
• To demonstrate the ability to work with drawn objects, to order and group objects

Using Hyperlinks

• Use action buttons, and hyperlink to other slides and to the Web
• Create and use a summary slide
• Output a presentation electronically or using various printout options

Slide Effects

• Add slide transition
• Add custom animation effects

Set up and run a Slideshow

• Navigate during a slideshow, add annotations to slides
• Rehearse and record timings
• Create a multimedia presentation

Advanced Features

• Publish a presentation on the Web
• Review, add comments, track changes in a presentation
• Broadcast over a network and collaborate in an online meeting

Outlook Core

• Send and receive messages
• Compose a new mail message
• Attach files to a message
• Use housekeeping tasks to organise and manage folders on the E-mail system
• Use the calendar to schedule appointments, and recurring appointments
• Add, edit, view and manage contacts in contacts folder
• Categorise all Outlook folders
• Customise different views, to define a view
• Create, edit and assign tasks and mark as comlete, accept or decline a task
• Organise and manage appointments, contacts, emails, tasks and notes
• Understand and use the journal to track appointments etc, daily
• Insert, edit and delete format notes

For information on future MOS Master courses, check our schedule or call your local office now!