Microsoft Office 2003
Microsoft Office Word 2003 :
Course Content
Lesson 1: Loading the Word 2003 program, keying in text, naming and saving a document, overtype mode, editing text, printing a document, closing a document, accessing Help. closing the program
Lesson 2: Shortcut menus, the spelling and grammar feature, using the thesaurus, using the research pane, changing line and paragraph spacing, changing margins, opening an existing document, using the taskbar, undo and redo, creating a new folder, saving in a different format
Lesson 3: Automatic date and time, modifying field format, envelopes/labels, screen views, page breaks, text enhancement, fonts, size and colour, alignment, applying font effects, highlighting text
Lesson 4: AutoCorrect and AutoText, using a wizard to create a new document, setting tabulation stops in order to display text and figures
Lesson 5:: Cut, copy and paste. the office clipboard, Format painter
Lesson 6: Find and replace, the browse feature, bullets and numbering, headers and footers, page numbering, aligning text vertically
Lesson 7: Inserting a table in a document, inserting and deleting rows, sorting text, merging cells, rotating text, AutoSum, borders and shading, indenting text specifically, page orientation, creating a template from an existing document
Lesson 8: Creating drawing objects, inserting and modifying WordArt, inserting and modifying ClipArt, inserting symbols, formatting text into columns, inserting column breaks
Lesson 9: Applying and modifying styles, working in outline view. using document map, comparing and merging documents, adding, removing and editing comments
Lesson 10: Viewing a document in web page preview, web layout view, saving a document as a web page, using email in Word, inserting a hyperlink, creating and modifying charts and diagrams
Microsoft Office Excel 2003 :
Course Content
Lesson 1: The Excel 2003 screen, creating a worksheet, entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help
Lesson 2: Changing font type and size, text enhancement, selecting cells and ranges, text alignment, merging and splitting cells, modifying column width and row height, printing the active sheet, creating a folder, saving in a different format
Lesson 3: Inserting and deleting rows, switching between multiple workbooks, moving and copying cells, cut, copy and paste, AutoFill, Office clipboard
Lesson 4: AutoComplete, Hide and unhide columns and rows, freezing and unfreezing panes, inserting columns, change text orientation, page break preview, changing to landscape orientation, adjusting margins and scaling, centring between margins, displaying gridlines, inserting headers and footers, setting a print area, selecting non-adjacent data, naming and deleting a worksheet, saving a workbook as a template, creating a workbook from a template
Lesson 5: Applying borders, formatting numbers, defining and applying styles, Auto Calculate, complex formulas, absolute cell references
Lesson 6: Inserting a new worksheet, formatting a worksheet tab, grouping and ungrouping worksheets, 3-D references, applying wrap text formatting, indenting text, printing row and column headings, centring text horizontally and vertically in a range, adding, viewing and editing comments
Lesson 7: Using the SUM and COUNT functions, AVERAGE, MAX and MIN functions, sorting columns, using NOW and IF functions, PMT and FV functions, AutoFilter, find and replace
Lesson 8: Using the Chart Wizard, creating a two series line chart, formatting the plot area, creating a pie chart, saving selected data and a workbook as a web page, inserting a picture, resizing and repositioning, inserting and modifying an object, inserting and using a hyperlink, creating, modifying and positioning a diagram
Microsoft Office Outlook 2003 :
Course Content
Lesson 1: Loading Outlook 2003 and becoming familiar with the opening screen, changing the navigation pane, switching to auto preview, changing the position of the reading pane, altering the message view, deleting a message, viewing the Inbox, calendar, contacts and tasks, using notes and the folder list, closing the Outlook 2003 program
Lesson 2: Creating and replying to e-mail messages, adding signatures, applying send options to messages, attaching a file to a message, attaching an item to a message, opening an attachment, finding a message, flagging messages, search folders, using pre-defined stationery
Lesson 3: Creating a new contact, adding a picture to a contact, creating a category for a contact, deleting a contact, sharing contact details, changing the view of contacts, printing contacts information, creating a distribution list, using Find to locate a contact
Lesson 4: Creating, amending and deleting appointments, assigning a contact to an item, inviting attendees, creating recurring appointments and multi day events, customising calendar settings, printing calendars, planning meetings, inviting attendees, deleting attendees, cancelling a meeting
Lesson 5: Creating and assigning a task to a category, marking a task as completed, editing the task list, deleting a task, assigning tasks to others, accepting or declining tasks, sending status reports, viewing the task pad, placing a task onto the calendar, creating notes and assigning to a category, linking notes to a contact, editing, deleting and changing the colour of notes
Lesson 6: Create folders to manage your email messages, moving messages into folders, colouring messages, using the rules wizard, creating filters, clearing filters
Lesson 7: Customising toolbars and menus, restoring deleted items, permanently deleting items, saving messages in other formats, archiving, creating a personal folders file (.pst), exporting Outlook data, specifying advanced email options
Microsoft Office Access 2003 :
Course Content
Lesson 1: Terminology used in connection with a database, loading the Microsoft Office Access program, opening an existing database, navigating around different objects in a database, using datasheet and design view, entering a new record, finding records, sorting records
Lesson 2: Planning and design of a database, recognising relationships between tables, defining fields, data types and properties using design view, entering data into tables using datasheet view, re-sizing columns, using the Lookup Wizard
Lesson 3: Defining relationships, sing the Table Wizard to create a table, modifying the table design, sing the Input Mask Wizard, sing the Database Wizard to create a new database
Lesson 4: Editing data in form and datasheet views, adding new records, using print preview, changing page orientation, printing a datasheet, enforcing referential integrity in a relationship, using the Form Wizard, working with controls in form design
Lesson 5: Using advanced sort, using filter by form, importing a table from an external database, using a junction table to resolve a many to many relationship, adding a new field to a form, using a calculated control on a form, creating a query, using criteria to retrieve selected data, creating and naming a calculated field in a query
Lesson 6: Adding a field with data validation in a table, creating a form with subform, entering data using a form/subform combination, creating and modifying the design of a report, adding a subreport to an existing report
Lesson 7: Exporting an HTML file, editing an existing web page, creating a data access page, adding a hyperlink, object dependencies, importing an Excel spreadsheet as a table, importing a comma delimited text file as a table, creating a switchboard, backing up a database
|
|
|
| |
Microsoft Office Word 2003 Expert :
Course Content
Lesson 1: Mail merge using existing documents, create a main document and a datasource, set filter options within mail merge, use mail merge to create envelopes and labels
Lesson 2: Merge letters and labels with data sources from other programs, print a datasource,
sort records, update, insert and delete records, manage fields
Lesson 3: Apply paragraph shading, sort paragraphs. sort data in a table, insert calculations in a table, update fields, insert an embedded object, insert a linked object, update links, use paste special, import a file from Excel to create a chart, modify a chart, sort records, update, insert and delete records, manage fields
Lesson 4: AutoSummarise, use Word Count, change file properties, create multiple versions of a document. protect documents, use Find and Replace to locate special characters, attach a digital signature to documents
Lesson 5: Create and modify a table of contents, create and modify an index. create cross-reference in an index, insert a bookmark
Lesson 6: Control the flow of text, create a watermark, modify a document background, create and revise footnotes and endnotes, insert a caption, insert a cross-reference within a document, set up different page numbering within a document, work with master documents and subdocuments
Lesson 7: Create a macro, run a macro, assign a macro to a keystroke, assign a macro to a toolbar button, edit a macro, delete a macro, use a form, create a form, create a drop-down list, create a date format, use calculations in a form
Lesson 8: Insert a movie, modify a web page, apply a theme to a document, save a document in XML format, attach a schema to a Word document, apply XML tags to a document
Mail Merge using Word 2003
Course Content
Lesson 1: Mail merge using existing documents, create a main document and a datasource, set filter options within mail merge, use mail merge to create envelopes and labels
Lesson 2: Merge letters and labels with data sources from other programs, print a datasource,
sort records, update, insert and delete records, manage fields
Microsoft Office Excel 2003 Expert
Course Content
Lesson 1: Creating a template, using an existing template, editing a template, creating custom views, deleting custom views, consolidating data, creating a workspace file, using workspace files, creating and modifying custom number formats, using conditional formatting, deleting conditional formatting
Lesson 2: Printing grouped worksheets and multiple workbooks, naming and modifying cell ranges, moving a named range, using range names to locate data, deleting a named range, using range names in calculations, formatting and resizing graphics, formatting charts and diagrams, finding trends in data
Lesson 3: Setting security levels for macros, creating macros, running macros, editing a macro, creating a toolbar and menu to hold macros, deleting macros, deleting a toolbar button, deleting a custom toolbar and menu
Lesson 4: Applying data validation rules, adding input messages and error alerts, locating invalid data, tracing precedents and dependents, tracing errors, evaluating formulas, using the watch window, using AutoFilter and Advanced Filter, using a data form
Lesson 5: Compiling subtotals and consolidations, summarising data using outlining tools, using the database functions DSUM and DAVERAGE, using the Query Wizard with an external data source, analysing data using pivot tables, creating a pivot table chart, creating a pivot table from external data
Lesson 6: Using data analysis to calculate rank and percentile, solving a problem using goal seek, using solver to calculate a quotation, creating What-If Analyses using the scenario manager
Lesson 7: Protecting worksheets and workbooks, applying and removing passwords, sharing a workbook, merging workbooks, understanding workbook history, track changes, accept or reject changes, using digital signatures
Lesson 8: Inserting an embedded object, inserting a linked object, retrieving data from the web, saving as a web page, publishing worksheets, editing a web page and republish, saving an Excel workbook as an XML document, mapping data in a workbook, importing an XML document into an existing mapping
Microsoft Office PowerPoint 2003 :
Course Content
Lesson 1: Opening an existing PowerPoint presentation, different screen views, different PowerPoint objects, creating a presentation from a blank presentation, running an existing presentation as a slide show, saving and closing a presentation
Lesson 2: AutoContent Wizard, inserting pictures into a presentation, resize and reposition, applying a design template, applying a slide layout, using the Slide Master, deleting one slide and multiple slides, changing slide layout, changing bullet formatting, duplicating a slide, edit and formatting text
Lesson 3: inserting a footer into an existing presentation, modifying a footer using the slide master, repositioning slides in slide sorter view, inserting a media clip, applying background effects, using a picture as a background, inserting a slide from another presentation, using the spellcheck facility, using Format Painter, creating a folder when saving
Lesson 4: Modifying the Handout Master, preparing handouts, adding notes to a presentation, reviewing a presentation prior to printing, applying transition effects, rehearsing timings, applying animation schemes, applying custom animation, inserting a sound, find and replace
Lesson 5: Using a design template to start a new presentation, inserting slides from outline, working with outline text, creating a table in a presentation, customising a table format, creating charts, inserting a text box on a slide, modifying the slide sequence in outline view, inserting a hyperlink, inserting a movie, inserting a diagram
Lesson 6: Creating a template using the Slide Master, inserting ClipArt, exporting a presentation as an outline, inserting an Excel chart as an embedded object, inserting a Word table as a linked object, using WordArt
Lesson 7: Setting up a review cycle, reviewing, accepting and rejecting changes, compare and merge, inserting a comment, saving a presentation in HTML format, publishing a presentation as a web page, setting up an online broadcast, embedding fonts, using Package for CD for remote delivery.
Microsoft Office Publisher 2003:
Course Content
Lesson One: Loading the program, becoming familiar with the opening screen and the various types of publication, opening a blank publication, creating text boxes, resizing and moving an object, entering text and basic formatting, opening and editing a publication design, saving a new publication, printing a publication, closing the program
Lesson Two: Navigating a multi-page publication, deleting pages in publication, selecting objects as a group, deleting grouped objects, resizing text boxes, saving a publication as a template. opening a publication based on a custom template, inserting clip art, inserting text from another program, spellchecking a publication, hiding boundaries and guides
Lesson Three: Checking page setup, using rulers and ruler guides, using layout guides and grids, inserting a page, applying best fit to text boxes, grouping and ungrouping objects. copying and pasting grouped objects, using print preview, knowing about advanced print options
Lesson Four: Inserting headers and footers on master pages, recognising serif and sans serif font styles, changing the vertical alignment of text, changing bullet style and indentation, using format painter to copy formatting, adjusting spacing between lines, using word art, creating text box links, changing the order of objects, creating columns and determining gutter spacing, using tables to display text, understanding proof reading symbols
Lesson Five: applying a design to a blank publication, layering pictures, using drawing tools, changing text wrapping, cropping pictures, cropping pictures, using easy web site builder to create a site, adding a web page, editing navigation bars, creating links/hyperlinks using text, pictures and hotspots, inserting web graphics, inserting graphics/movies and sound files, adding a description and keywords, saving and publishing a website
|
