Microsoft Office 2007 Applications

Programme Content

MS Word (7 weeks)
This module is suited to existing users of MS Word. Good keyboarding skills are required. The programme starts by refreshing users on the fundamental features of Word such as the following to include 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 & merge document versions, Manage tracked changes, Insert, modify & delete comments. Sharing and Securing Content – Prepare documents for sharing, Control document access, Attach digital signatures.
 

MS Excel (7 weeks)
This module is suited to existing users of MS Excel. The programme starts by refreshing users on the fundamental features of Excel such as the following to include Creating and Manipulating Data – Insert data by using AutoFill, Ensure data integrity, Modify cell contents and formats, Change Worksheet Views, Manage worksheets. 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, Display and print formulas. Presenting Data Visually – Create and format charts, Modify charts, Apply conditional formatting, Insert and modify illustrations, Outline data, Sort and filter data. Collaborating and Securing Data – Manage changes to workbooks, Protect and share workbooks, Prepare workbooks for distribution, Save workbooks, Set print options for printing data, worksheets, and workbooks.
 

MS PowerPoint (5 weeks)
This module is suited to users of applications like Word or Excel who wish to learn presentation skills using the features of PowerPoint to create and deliver effective professional presentations. The programme starts by refreshing users on the fundamental features of PowerPoint but advances quickly to include detailed coverage of features of MS PowerPoint such as: 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 and 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.

 
MS Outlook (5 weeks)
This module will provide you with the skills you need to start sending and responding to email, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes. In this module, you will cover the following areas: Managing Messaging – Create and send an e-mail message, Create and manage your signature and automated messages, Manage e-mail message attachments, Configure e-mail message sensitivity and importance settings, Configure e-mail message security settings, Configure e-mail message delivery options, 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, modify, and mark tasks as complete, Accept, decline, assign, update, and respond to tasks. Managing Contacts and Personal Contact Information – Create and modify contacts, Edit and use an electronic business card, Create and modify distribution lists, Create a secondary address book. Organising Information – Categorise Office Outlook 2007 items by colour, Create and manage Office Outlook 2007 data files, Organise mail folders, Locate Office Outlook 2007 items by using the search feature, Create, modify and remove rules to manage e-mail messages, Customise your Office Outlook 2007.