MICROSOFT^® OFFICE SPECIALIST

KeyNet offers various training options for the Microsoft^® Office Specialist Certification.  This enables you to prove your expertise in

Word
Excel
Access
PowerPoint
Outlook

Other Microsoft^® Office Specialist courses

Diploma
Master

Passing any single subject qualifies you as a Microsoft^® Office Specialist in that subject.  This qualification was formerly called the Microsoft^® Office User Specialist (MOUS).

Pass all FIVE required exams and you are CERTIFIED as a MASTER

MASTER certification is available for those wishing to demonstrate their overall expertise.  Passing the 2 EXPERT levels in Word and Excel and the 3 core levels in PowerPoint, Access and Outlook leads to a MASTER Certificate.   Please E-mail or telephone for details.  Email the course tutor Jacky or telephone 0116 232 5166.

EXCEL -  Microsoft Office Specialist

Excel Microsoft Office Specialist: 
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft Excel: Beginners or equivalent knowledge and experience.
Course Contents are comprehensive and include: 
Creating workbooks and modifying workbooks.  Deleting worksheets.  Rotating text and using absolute references.  Printing workbooks, areas, ranges and headers and footers.  Formatting worksheets, modifying cell sizes and outlines.  Creating, applying and naming ranges.  Using functions, draw and charts.  Saving spreadsheets as other file formats. FULL COURSE DETAILS AVAILABLE ON REQUEST.

Excel EXPERT Microsoft   Office Specialist:
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft Excel: Beginner and Intermediate or equivalent knowledge and experience.
Course Contents are comprehensive and include: 
Formatting worksheets, using autoformat, custom formats and styles.  Using, sorting and querying lists.  Printing workbooks.  Auditing a worksheet.  Using filters, data analysis, pivot tables, data map and multi-level sorts.  Using, creating and editing macros.  Importing and exporting data.  Using, creating and editing templates.  Using and linking multiple workbooks.  Using workgroup functions, sharing lists and merging workbooks. FULL COURSE DETAILS AVAILABLE ON REQUEST. Also available as a distance learning / home study course.  

WORD -  Microsoft Office Specialist

Word Microsoft Office Specialist:
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft Word Beginner course or equivalent knowledge and experience.
Course Contents are comprehensive and include: 
Applying character effects and font styles. Using hyphenation, inserting date and time.  Setting tab leaders., Using sections.  Using styles and templates. Using find and replace, navigating, using AutoCorrect and AutoText.  Generating an outline.  Creating documents for use on Internet/Intranet. Using grammar and thesaurus.  Using columns.  Creating tables, adding borders and shading, merging cells and rotating text.  Managing files, using save as and creating a folder.  Using draw.  Printing envelopes and labels. FULL COURSE DETAILS AVAILABLE ON REQUEST.  Also available as a distance learning / home study course.  

Word EXPERT Microsoft Office Specialist:
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft Word Beginner and Intermediate courses or equivalent knowledge and experience.
Course Contents are comprehensive and include: 
Using advanced formatting and text flow options.  Creating watermarks.  Using footnotes and endnotes.  Workgroup editing, inserting comments and creating master documents.  Using columns.  Calculating tabular information.  Using charts and forms. Inserting graphics, fields and special characters.  Using and editing macros and creating templates.  Generating a mail merge and sorting records to be merged.  Generating reference documents, creating tables of contents and using bookmarks.  Managing files and protecting documents. FULL COURSE DETAILS AVAILABLE ON REQUEST.  Also available as a distance learning / home study course.  

POWERPOINT -  Microsoft Office Specialist

PowerPoint Microsoft Office Specialist:
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft PowerPoint Beginner course or equivalent knowledge and experience.
Course Contents are comprehensive and include: 
Entering text in outline view.  Building graphs, drawing objects, rotating and scaling objects. Adding shapes, tables and organizational charts.  Adding data from other sources, a chart, imported text, scanned images, movies and sound.  Modifying the slide master, changing tabs and fonts.  Preparing for distribution and adding speaker notes.  Creating a custom background, colour scheme and clip art. Adding links to other slides and hiding slides.  Using on screen navigation tools, exporting to overhead and slides. Saving for use on another computer or for the Internet. FULL COURSE DETAILS AVAILABLE ON REQUEST.  Also available as a distance learning / home study course.  

ACCESS -  Microsoft Office Specialist

Access Microsoft Office Specialist:
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft Access Beginner course or equivalent knowledge and experience.
Course Contents are comprehensive and include: Understanding database terminology and relational databases including one-to-one and many-to-many relationships. Enforcing referential integrity in a relationship. Learning about database objects; tables, queries, reports, forms and macros. Using the different views. Using different wizards; table wizard, form wizard, report wizard and lookup wizard. Creating tables. Defining and modifying field definitions, data types and properties. Changing a field name. Indexes. Changing field sizes. Creating an input mask. Number data type. Copying field properties. Adding fields. Date fields. Number formats and decimal places. Date/time formats. Adding data validation fields. Using primary keys and AutoNumber. Navigating a database. Using Find. Sorting and filtering. Creating forms and using AutoForm. Adding data using the main form and the sub form. Changing the design of forms. Adding controls to a form. Adding calculated controls to forms. Adding new fields to forms and changing the tab order. Adding a notes field and text box. Form properties. Deleting controls. Moving fields. Checking the form view. Adding combo boxes and their properties. Changing colours. Switching to form view. Saving. Changing the form width and length. Selecting and changing several controls at once. Changing and moving controls and labels. Selecting a compound control. Planning and designing switchboards. Displaying a switchboard at startup. Changing a switchboard design, adding a picture and changing the colour scheme. Creating different types of queries. Printing queries. Creating calculated fields in queries. Creating mailing labels through a report or a query. Importing data from external sources. Entering and importing data and where to store it. Choosing the data source. Text file formats. Viewing the imported data. Saving a table as a Web page. Adding hyperlinks to an existing Web page. Backing up a database. Compacting and deleting a database.  Also available as a distance learning / home study course.  

OUTLOOK -  Microsoft Office Specialist

Outlook Microsoft Office Specialist:
Course length: 2 Days or up to 20 hours at times to suit.  Prerequisites: Microsoft Outlook Beginner course or equivalent knowledge and experience.
Course Contents are comprehensive and include: 
Using Outlook Help and Office Assistant; Reading and sending mail; Composing new mail; Using Forward, Reply and Recall; Using the address book; Flagging messages; Navigation ; Finding messages; Attachments; Adding signatures; Customisation; Using templates; Creating folders; Sorting mail; Setting the view options; Archiving messages; Filtering views; Navigating within the calendar; Scheduling appointments and events and multi-day events; Setting reminders; Scheduling recurring appointments ; Create, edit and delete contacts; Send contact information vi e-mail; Record activities in the Journal; Link activities to a contact; Sort contacts; Create and update tasks; Accept and decline tasks; Organise tasks; Assign tasks; Organise view and customise notes; Create and use Office documents inside Outlook; Using the Office Clipboard; Integration of the Outlook components; Printing and print options; Customising menu and task bars. FULL COURSE DETAILS AVAILABLE ON REQUEST. Also available as a distance learning / home study course.  

MICROSOFT^® OFFICE SPECIALIST
50 HOUR DIPLOMA COURSE
Suitable for complete beginners

Course Outline
This course is suitable for complete beginners who have little or no previous knowledge of Word, Excel, PowerPoint or Access.  Also available as a distance learning / home study course.  The course consists of 50 hours of training at times to suit leading to internationally recognised qualifications and covering the following topics:

Microsoft^® Word to Microsoft Office Specialist Level
Microsoft^® Excel to Microsoft Office Specialist Level
Microsoft^® PowerPoint Introduction
Microsoft^® Access Introduction

Microsoft^® Word Microsoft Office Specialist

Introduction. Getting Started. Create Letters, Memos and Reports. Use Views, Toolbars & Options. Use general Editing and Selection Techniques. Apply Font Styles (Bold and Italic). Use All Underline Options. Apply Character Effects (Superscript, Subscript, Strikethrough, Small Caps and Outline) . Select and Change Fonts and Font Size (Automatically and Manually). Use Hyphenation. Apply Paragraph Formatting. Align Text Horizontally and Vertically. Use Page Layout Options and Set Margins. Insert Page Breaks. Set Line Spacing Options. Insert the Date and Time. Use Undo & Repeat. Use Cut, Copy, Move, Insert and Overtype. Set all types of Tabs and Use all Indentation options. Add Bullets & Numbering. Create and Modify Headers, Footers and Page Numbers. Create Sections. Create, Apply and Edit Styles. Use Templates. Use Find, Replace and Go To. Navigate through a Document. Set AutoCorrect Exceptions. Create and Apply Frequently Used Text. Create and Modify an Outline. Create Hyperlinks and Save As HTML. Use the Spelling, Grammar and Thesaurus. Key and Edit Text in Columns and Revise Column Structure. Create, Format and Modify Tables, Add Borders and Shading and Rotate Text. Locate and Open Documents. Save and Close Documents. Create A New Folder. Create and Modify Drawing Objects. Preview and Print Documents. Prepare and Print Envelopes and Labels.

Microsoft^® Excel Microsoft Office Specialist

Introduction. Getting Started. Using Open, Close, New & Save As. Using Views, Toolbars & Options. Spreadsheet Mathematics. Building Formulae. Formatting Cells. Using Borders & Shading. Working with Workbooks. Filling Cells & Number Series. Page Setup, Find & Replace. Delete Cell Contents. Delete Worksheets. Edit Text and Numbers. Rotate and Indent Text. Edit Formulas. Copy and Move Data. Insert, Modify, and Delete Rows and Columns. Use References (Absolute, Relative, and Mixed). Sort Data. Preview and Print Worksheets. Print Areas and Ranges. Print Headers and Footers. Modify Cell Size and Alignment. Apply General Number Formats. Apply Font Formats. Apply Outlines. Create and Name Ranges. Clear and Format Ranges. Copy and Move Ranges. Use the AVERAGE, MIN, and MAX Functions. Use Worksheet Functions. Create and Modify Lines and Objects. Create and Modify 3D Shapes. Create, Format, and Modify Charts. Preview and Print Charts. Save Spreadsheets as HTML Documents.

Microsoft^® PowerPoint Introduction

Introduction. Getting Started. Your First Presentation. Open, Close, New & Save As. Views, Toolbars & Options. Text Formatting. Editing Your Presentation. Picking Looks for Slides. Creating Slides. Transition Effects & Builds. Objects. Copying & Moving Objects. Adding Text & Drawing Shapes. May also include editing Masters, using WordArt and Printing Audience Handouts.

Microsoft^® Access Introduction

Introduction. Getting Started. Navigating the Database. Changing & Adding Records. Filtering Records. Understanding the Database. Creating Tables. Changing the Table Design. Entering Data. Querying the Database. Managing a Database. Database Wizards. May also include creating Forms and Reports; changing the Form Design; changing the Report Design.

Home | About KeyNet | Courses | Information | Enrolment | Form

Copyright © 1999 KeyNet - Website built by Keynet Internet Services