We are here to give you exceptional satisfaction
Microsoft Office Training Solutions Contents
Information Communication Technology, Project Management, Management Consultancy 5,Mango Street, AirPort Road, Rukpokwu, Port Harcourt Website: www.icthomeservices.com, E-mail:
[email protected], Phone: 08132981011 RC130897
Computer Training Microsoft office 2007
Table of Contents Module 1 Word 2007 Foundation …………………………………………………..3-5 Excel 2007 Foundation…………………………………………………...7-9 PowerPoint 2007 Foundation…………………………………………….10-13 Module 2 Word 2007 Intermediate………………………………………………….14-15 PowerPoint 2007 Intermediate……………………………………………16-17 Excel 2007 Intermediate………………………………………………….18-20 Module 3 Word 2007 Advanced…………………………………………………….21-22 Excel 2007 Advanced…………………………………………………….23-24 PowerPoint 2007 Advanced………………………………………………25-28 Module 4 Access 2007 Foundation…………………………………………………29-30 Access 2007 Intermediate………………………………………………..31-32 Access 2007 Advanced…………………………………………………..33-34 Others Project 2007 Foundation………………………………………………….35-36 Publisher 2007 Foundation……………………………………………….37-40 Visio 2007 Foundation……………………………………………………41-44 Outlook 2007 Foundation…………………………………………………45-47
ICT Home Services Ltd
we are here to give you exceptional satisfaction
2
Computer Training Microsoft office 2007
Microsoft Word 2007 Foundation Level Training course contents: THE MICROSOFT WORD 2007 SCREEN · ·
The Microsoft Word 2007 screen The Office Button, Tabs, Groups & Dialog box launcher
WORD 2007 – STARTING TO USE MICROSOFT WORD 2007 · · · ·
Opening and closing documents Saving your file Creating a new document Using Help within Microsoft Word 2007
WORD 2007 – TEXT FORMATTING · · · · · · · ·
Font type and font size Bold, italic or underline Subscript and superscript Case changing Highlighting Font color Copying text formatting Removing formatting
WORD 2007 – MANIPULATING TEXT · · · ·
Selecting text Inserting, deleting, undo and redo Copying text within a document Moving (cutting) text within a document
WORD 2007 – THE CLIPBOARD ·
Using the Clipboard
WORD 2007 – PARAGRAPH FORMATTING · · · ·
Paragraph marks Soft paragraph (line break) marks Aligning text Indenting paragraphs ICT Home Services Ltd
we are here to give you exceptional satisfaction
3
Computer Training Microsoft office 2007 · Applying single or double line spacing · Applying spacing above or below paragraphs · Applying bullets and numbering
WORD 2007 – ADDING BORDERS AND SHADING · ·
Adding a border Adding shading
WORD 2007 – FINDING AND REPLACING TEXT · ·
Finding text Replacing text
WORD 2007 – TABS · ·
Tab stops Setting and removing tabs
WORD 2007 – STYLES ·
Applying styles to a word, line or a paragraph
WORD 2007 – PAGE FORMATTING · · · · · · ·
Page orientation and paper size Page margins Page breaks Headers and footers Page numbering Header and footer fields Cover pages
WORD 2007 – TABLES · · · · · · · · ·
Inserting a table Navigating within a table Selecting and editing text within a table Selecting cells, rows, columns or the entire table Inserting and deleting rows and columns Modifying column width or row height Modifying cell borders Adding shading to cells Modifying cell border width, colour and style
WORD 2007 – GRAPHICS · · · · ·
Inserting Pictures Inserting Clip Art Inserting Shapes Inserting SmartArt Selecting, resizing and deleting graphics
ICT Home Services Ltd
we are here to give you exceptional satisfaction
4
Computer Training Microsoft office 2007 · Copying or moving graphics
WORD 2007 – MULTIPLE DOCUMENTS · · · ·
Switching between open documents Tiling or cascading documents on your screen Comparing documents side by side Copying or moving between documents
WORD 2007 – PROOFING AND PRINTING · · · ·
Spell checking a document Using built-in custom dictionaries Printing options Previewing and printing a document
ICT Home Services Ltd
we are here to give you exceptional satisfaction
5
Computer Training Microsoft office 2007
Microsoft Excel 2007 Foundation Level Training Course Contents: A FIRST LOOK AT EXCEL 2007 · · · · · · · · · · · · · ·
Starting the Excel program What is the Active Cell? The Excel cell referencing system Entering numbers and text Default text and number alignment Adding a column of numbers Worksheets and Workbooks Saving a workbook Closing a workbook Creating a new workbook Opening a workbook Switching between workbooks Saving a workbook using another name Saving a workbook using a different file type
EXCEL 2007 HELP · · · · ·
Getting help Searching for Help The Help ‘Table of Contents’ Printing a Help topic Alt key help
EXCEL 2007 – SELECTION TECHNIQUES · · · · · · · · · · ·
Why are selection techniques important? Selecting a cell within Excel 2007 Selecting a range of connecting cells Selecting a range of non-connecting cells Selecting the entire worksheet Selecting a row Selecting a range of connecting rows Selecting a range of non-connected rows Selecting a column Selecting a range of connecting columns Selecting a range of non-connecting columns
EXCEL 2007 – MANIPULATING ROWS AND COLUMNS · · ·
Inserting rows into a worksheet Inserting columns into a worksheet Deleting rows within a worksheet
ICT Home Services Ltd
we are here to give you exceptional satisfaction
6
Computer Training Microsoft office 2007 · Deleting columns within a worksheet · Modifying column widths · Modifying column widths using ‘drag and drop’ · Automatically resizing the column width to fit contents · Modifying row heights
EXCEL 2007 – COPYING, MOVING AND DELETING · · · · · · · ·
Copying the cell or range contents Deleting cell contents Moving the contents of a cell or range Editing cell content Undo and Redo AutoFill Sorting a cell range Searching and replacing data in Excel 2007
EXCEL 2007 – MANIPULATING WORKSHEETS · · · · · · ·
Switching between worksheets Renaming a worksheet Inserting a new worksheet Deleting a worksheet Copying a worksheet within a workbook Moving a worksheet within a workbook Copying or moving worksheets between workbooks
EXCEL 2007 – FONT FORMATTING · · · · · ·
Font type Font size Bold, italic, underline formatting Cell border formatting Formatting the background colour Formatting the font colour
EXCEL 2007 – ALIGNMENT FORMATTING · · · · ·
Aligning contents in a cell range Centring a title over a cell range Cell orientation Text wrapping Format painter
EXCEL 2007 – NUMBER FORMATTING · · · · · ·
Number formatting Decimal point display Comma formatting Currency symbol Date styles Percentages
ICT Home Services Ltd
we are here to give you exceptional satisfaction
7
Computer Training Microsoft office 2007
EXCEL 2007 – FREEZING ROW AND COLUMN TITLES ·
Freezing row and column titles
EXCEL 2007 – FORMULAS · · · · ·
Creating formulas Easy way to create formulas Copying formulas Operators Formula error messages
EXCEL 2007 – CELL REFERENCING · ·
Relative cell referencing within in formulas Absolute cell referencing within formulas
EXCEL 2007 – FUNCTIONS · · · · · · · · ·
What is a function? Common functions Sum function Average function Max function Min function Count function What are ‘IF functions’? Using the IF function
EXCEL 2007 – USING CHARTS · · · · · · · · · · · · · ·
Inserting a column chart Inserting a line chart Inserting a bar chart Inserting a pie chart Resizing a chart Deleting a chart Chart title or labels Chart background colour Changing a column, bar, line or pie slice colours Changing the chart type Modifying Charts using the Layout tab Copying and moving charts within a worksheet Copying and moving charts between worksheets Copying and moving charts between workbooks
CUSTOMIZING EXCEL 2007 · · ·
Modifying basic options Minimising the Ribbon AutoCorrect options
ICT Home Services Ltd
we are here to give you exceptional satisfaction
8
Computer Training Microsoft office 2007
EXCEL 2007 – WORKSHEET SETUP · · · · · ·
Worksheet margins Worksheet orientation Worksheet page size Headers and Footers Header and footer fields Scaling your worksheet to fit a page(s)
EXCEL 2007 – PREPARING TO PRINT A WORKSHEET · · · · · · · · ·
Visually check your calculations Gridline display when printing Printing titles on every page when printing Printing the Excel row and column headings Spell checking Previewing a worksheet Comparing Workbooks side by side Zooming the view Printing option
ICT Home Services Ltd
we are here to give you exceptional satisfaction
9
Computer Training Microsoft office 2007
Microsoft PowerPoint 2007 Foundation Level Training course contents: POWERPOINT 2007 – FIRST STEPS WITH PRESENTATIONS · · · · · · · · · · ·
Opening PowerPoint 2007 Opening a presentation Navigating between slides Using the Zoom tool Changing PowerPoint 2007 views Using Help Saving a presentation Closing a presentation Closing PowerPoint 2007 Opening multiple presentations Switching between multiple presentations
POWERPOINT 2007 – CREATING A PRESENTATION · · · · ·
Creating a new presentation Inserting a new slide Undo and Redo Saving a presentation Saving a presentation using a different name
POWERPOINT 2007 – MANIPULATING SLIDES · · · ·
Inserting slides with a particular slide layout Modifying the slide layout Changing the background colour on the active slide Changing background colour on all the slides within a presentation
POWERPOINT 2007 – THEMES ·
Applying a theme to a presentation
POWERPOINT 2007 – TEXT BOXES (PLACEHOLDERS) · · · ·
What are Text Boxes (Placeholders)? Resizing a Text Box (Placeholder) Moving a Text Box (Placeholder) Compatibility issues when saving a presentation
ICT Home Services Ltd
we are here to give you exceptional satisfaction 10
Computer Training Microsoft office 2007
SELECTING, COPYING MOVING, RESIZING & DELETING · · · · · ·
Selecting text Moving text within a slide Moving text between slides within a presentation or between presentations Copying text within a slide Copying text between slides within a presentation or between presentations Deleting text
POWERPOINT 2007 – SEARCHING YOUR PRESENTATION · ·
Using Find Using Replace
POWERPOINT 2007 – FONT FORMATTING · · · · · · · · · · ·
Font formatting options Changing the font type Changing font size Increasing or decreasing the font size Bold, Italic or Underline formatting Strikethrough effects Shadow effects Character spacing Changing case Font colour Clearing all text formatting
POWERPOINT 2007 – PARAGRAPH FORMATTING · · · · · · · · · · · ·
Text alignment Columns Modifying bullet point formatting Using numbering instead of bullet points Changing the list level Line spacing Using Outline view PowerPoint Notes Text direction Text alignment within a Text Box (placeholder) Text Autofit Using the Format Painter
SELECTING, COPYING MOVING, & RESIZING ILLUSTRATIONS · · · · · ·
Selecting an illustration Moving an illustration Copying an illustration Deleting an illustration Resizing an illustration Stretching an illustration
ICT Home Services Ltd
we are here to give you exceptional satisfaction 11
Computer Training Microsoft office 2007 · Copying illustrations between presentations · Moving illustrations between presentations
POWERPOINT 2007 – INSERTING ILLUSTRATIONS · · · · · · · ·
Inserting Illustrations within PowerPoint Inserting pictures Inserting Clip Art Inserting Shapes Inserting text into a shape Inserting perfect circles or perfect squares Inserting SmartArt Inserting Charts
POWERPOINT 2007 – FORMATTING SHAPES · · · · · · · · · ·
Formatting the shape background fill colour style Formatting the shape line weight and style Formatting the shape line colour Applying a shadow to an illustration Modifying arrow line shapes and size Rotating or flipping an illustration Rotating illustrations by dragging with the mouse Layering illustrations to the front or back Aligning illustrations vertically Aligning illustrations horizontally
POWERPOINT 2007 – FORMATTING CHARTS · · ·
Changing the chart type Changing the background colour in the chart Changing the column, bar, line or pie slice colours in the chart
POWERPOINT 2007 – ORGANISATION CHARTS · · · · · · ·
What is an organisation chart? Creating an organisation chart Adding labels to items within an organisation chart Adding a co-worker to an organisation chart Adding a subordinates within an organisation chart Adding a manager within an organisation chart Removing an item from an organisation chart
POWERPOINT 2007 – MOVING, COPYING AND DELETING SLIDES · · · · ·
Moving slides within a presentation or between presentations Copying slides within a presentation Deleting a slide or slides Copying slides between presentations Moving slides between presentations
ICT Home Services Ltd
we are here to give you exceptional satisfaction 12
Computer Training Microsoft office 2007
POWERPOINT 2007 – SLIDE SHOWS · · ·
Running a slide show Slide show transition effects Slide show animation effects
POWERPOINT 2007 – PRINTING · · · · ·
Spell-checking Using Portrait or Landscape slide orientation Selecting your output format Visually inspect each slide before printing Printing a presentation
CUSTOMISING POWERPOINT 2007 ·
Modifying PowerPoint options
ICT Home Services Ltd
we are here to give you exceptional satisfaction 13
Computer Training Microsoft office 2007
Microsoft Word 2007 Intermediate Level Training Course Contents: WORD 2007 – CUSTOMISING MICROSOFT WORD · · · · · · · · · · ·
Microsoft Word 2007 templates Saving documents to a specific location Saving document using different formats Using the Zoom Page views Controlling the display of items within Microsoft Word Screen display options Modifying Word options Hyphenation Setting automatic hyphenation Hyphenation options
WORD 2007 – TEXT EDITING · · · · · · ·
Inserting special characters and symbols Word 2007 AutoCorrect options AutoFormat as you type Animated text effects Text wrapping options Text orientation formatting options WordArt
WORD 2007 – PARAGRAPH EDITING · · · ·
Paragraph shading options Paragraph border options Reversing the colour of a paragraph Widow paragraphs and orphan paragraphs
WORD 2007 – STYLES · · · · · ·
Applying styles Modifying styles Creating styles Using Outline View with header styles Viewing a document in Outline View Creating a document in Outline view
WORD 2007 – TEMPLATES · · ·
Creating a new template based on an existing document or template Customising Normal.dotm Recreating a default Normal.dotm file
ICT Home Services Ltd
we are here to give you exceptional satisfaction 14
Computer Training Microsoft office 2007
WORD 2007 – SECTION BREAKS · ·
Creating sections within a document Viewing and deleting section breaks within a document
WORD 2007 – COLUMNS · · ·
Creating multiple column layouts Additional column formatting options, width and spacing Applying and deleting column breaks
WORD 2007 – TABLES · · · · · ·
Creating a table Sorting data within a table Formulas and tables Merging and splitting cells within a table Merging cells Splitting cells
WORD 2007 – GRAPHICS · · · · · ·
Inserting Shapes in Microsoft Word 2007 Reordering graphics Placing a graphic in front or behind text Modifying image colours and borders Grouping or ungrouping shapes Inserting a watermark
WORD 2007 – TEXT BOXES · · · · ·
Inserting a Text Box Resizing, moving and deleting a Text Box Inserting text or a graphic into a Text Box Formatting Text Boxes Linking Text Boxes
WORD 2007 – MAIL MERGE · · · ·
Starting the Mail Merge Wizard Using the Mail Merge Wizard Creating a mailing list to be used within a mail merge Merging a mailing list to produce labels
ICT Home Services Ltd
we are here to give you exceptional satisfaction 15
Computer Training Microsoft office 2007
Microsoft Excel 2007 Intermediate Level Training Course Contents: MANIPULATING EXCEL 2007 DATA, & NAMED RANGES · · · · · · · · · · · ·
Paste Special Transposing data Importing text and delimiting by space, comma or tab What does naming a cell range mean? Rules for naming cells and ranges Naming cell range(s) in a worksheet Named ranges within formulas Navigating through workbooks using named ranges Creating named ranges automatically based on cell values Deleting named cells/ranges Creating subtotals Removing subtotals in Excel 2007
EXCEL 2007 TEMPLATES · · ·
Using templates Creating templates Opening and editing templates
FORMATTING & DISPLAY TECHNIQUES · · · · · · · · · ·
Formatting tables Formatting tables using table styles Formatting cell ranges using conditional formatting Creating custom number formats Freezing the top row Freezing the first column Freezing the top row and the first column at the same time Hiding and un-hiding rows Hiding and un-hiding columns Hiding and un-hiding worksheets
SORTING AND QUERYING DATA · · · · ·
Sorting internal Excel databases Custom sort options Using AutoFilter to query data Multiple queries Removing filters
ICT Home Services Ltd
we are here to give you exceptional satisfaction 16
Computer Training Microsoft office 2007 · Top 10 AutoFilter · Filtering unique records · Advanced Filter
LINKING & CONSOLIDATING DATA · · · · · · · · · · ·
Linking individual cells within a worksheet Linking charts to data within a worksheet Linking a cell range on one worksheet to another worksheet (within the same workbook) Linking data on one worksheet to a chart in another worksheet (within the same workbook) Linking data from one workbook to another Linking a chart from one workbook to another Copying data from Excel into a Word document Linking data from Excel into a Word document Copying a chart from Excel into a Word document Linking a chart from Excel into a Word document Consolidating data over several worksheets or worksheet pages
EXCEL 2007 CHARTS FORMATTING TECHNIQUES · · · · · · · · · · · · · ·
Changing the angle of pie chart slices Formatting the chart axis fonts Formatting the chart axis scales Formatting the chart axis text orientation Creating and positioning a chart title Re-positioning a chart legend Re-positioning chart data labels Exploding the segments within a pie chart Deleting a data series within a chart Adding a data series to a chart Modifying the chart type for a defined data series Widening the gap between columns / bars within a 2-D chart Inserting an image into a 2D chart (as a background) Inserting an image into a 2D chart (to format a column or bar of data)
PROTECTION AND SECURITY · · · · · ·
Specifying a password for opening a workbook Using the “read-only recommended” option Removing a password from an Excel workbook Protecting a worksheet or worksheet elements Removing workbook protection Allowing selective editing of a protected worksheet within Excel 2007
ICT Home Services Ltd
we are here to give you exceptional satisfaction 17
Computer Training Microsoft office 2007
Microsoft PowerPoint 2007 Intermediate Level Training Course Contents: POWERPOINT 2007 – PHOTO ALBUMS · · · · · · · · · ·
What is a PowerPoint Photo Album? Creating a Photo Album Reordering the picture sequence Rotating images within the Photo Album Modifying the picture layout Modify the frame shape Applying a theme to the Photo Album. Displaying your pictures in Black and White Adding captions to each picture Adjusting picture contrast and brightness
POWERPOINT 2007 – MEDIA CLIPS · · · · · · · ·
Supported media file formats Inserting a sound clip Modifying the sound clip volume level Controlling when the sound is played within a media clip Hiding a the sound clip icon Using a picture instead of the sound icon within a slide Inserting a movie clip Playing the movie full screen
POWERPOINT 2007 – TABLES · · · · · · · ·
Inserting a table into PowerPoint 2007 Applying a style to a table Cell background shading Adding table effects Adding ‘Quick Styles’ to selected text Applying borders to cells Deleting rows or columns Inserting rows or columns
POWERPOINT 2007 – SLIDE SHOW ANIMATION EFFECTS · · · · ·
What are animation effects? Applying animation effects to text Applying animation effects to illustrations Custom animation Changing the sequence of animation within a slide
ICT Home Services Ltd
we are here to give you exceptional satisfaction 18
Computer Training Microsoft office 2007
POWERPOINT 2007 – SLIDE SHOW MANIPULATION · · · · · · · · · · ·
Inserting Action Buttons Setting Mouse over properties Practicing slide timings Using slide timings Slide show looping options Hiding slides Displaying hidden slides Annotating slide shows Creating a custom slide show Editing a custom slide show Running custom slide shows
POWERPOINT 2007 – TEMPLATES AND SLIDE MASTERS · · · · · · ·
Templates, Slide Masters and Themes Creating and saving a template Modifying a Slide Master Creating footers and inserting the date Handout and Notes Masters Modifying the Handout Master Modifying the Notes Master
POWERPOINT 2007 – SLIDE MANIPULATION · · · ·
Merging slides or complete presentations Merging a word-processed outline into a presentation Applying graduated background fill colours, texture & patterns Saving a slide in gif, jpeg or bmp format
POWERPOINT 2007 – MANIPULATING ILLUSTRATIONS · · · · · ·
Moving a graphic backwards or forwards Grouping and ungrouping objects Positioning a graphic relative to the slide Distributing selected graphics horizontally, vertically relative to a slide Converting a picture to a drawn object Controlling the display of background pictures on a slide
POWERPOINT 2007 – SHAPE FORMATTING · · · · · · ·
Applying shape effects Applying (& repositioning) a shadow (of a specified colour) to a graphic Applying graduated background effects to a drawn object Applying a semi-transparent effect to a graphic Applying 3-D effects to a drawn object Further Shape style formatting options Using the Format Painter to apply styles to objects
POWERPOINT 2007 – PICTURE FORMATTING ·
Applying picture styles ICT Home Services Ltd
we are here to give you exceptional satisfaction 19
Computer Training Microsoft office 2007 · Modifying contrast and brightness · Re-colouring pictures · Cropping a picture · Re-scaling and rotating a picture · Resetting the image size · Rotating and flipping pictures · Setting picture shape · Converting a picture to a greyscale format · Saving a picture using a specific file format · Changing the colour depth of a picture
POWERPOINT 2007 – CHARTS AND FLOW CHARTS · · · · · · · ·
Creating a chart Changing the chart type Applying chart styles and layouts Creating a line-column on two axes / mixed chart Formatting the vertical axis Drawing a flowchart using built-in flowchart options Changing or deleting flowchart shapes within a flowchart Changing connector types between flowchart shapes
POWERPOINT – LINKING OBJECTS · · · · ·
Linking an Excel chart into a PowerPoint presentation Updating a linked object Editing linked data within a presentation Converting a linked object within a slide to an embedded object Linking a picture from a file
POWERPOINT 2007 – PRESENTATION PLANNING AND DESIGN CONCEPTS · · · · · ·
Planning the right presentation for the right environment Physical issues leading to a successful presentation Design considerations Matching the presentation to an audience Colour issues within a presentation Using a storyboard and time-line
ICT Home Services Ltd
we are here to give you exceptional satisfaction 20
Computer Training Microsoft office 2007
Microsoft Word 2007 Advanced Level Training Course Contents: WORD 2007 – FIELD CODES & FILL-IN FORMS · · · · · ·
Inserting a field code Updating fields Editing and deleting fields Locking or unlocking fields Displaying field codes Converting fields to text
WORD 2007 – FORMS · · · · ·
What are Word 2007 fill-in forms? Creating and editing a form Editing and formatting fill-in form fields Deleting fields within a fill-in form Protecting a fill-in form
WORD 2007 – LINKING AND EMBEDDING · · · · · ·
Linking and embedding objects Embedding an Excel chart Formatting an embedded worksheet within a document Editing an embedded object Linking an Excel chart to a Word document. Using the ‘Insert Chart’ command
WORD 2007 – REFERENCES OPTIONS · · · · · · · · · · · · · ·
Creating a Table of Contents Updating and modifying an existing Table of Contents Adding a bookmark Deleting a bookmark Going to a bookmark Cross-references Creating or editing an index Creating Footnotes Formatting Footnotes Deleting Footnotes Creating Endnotes Formatting Endnotes Deleting Endnotes Adding or updating a caption to an image, table or worksheet
ICT Home Services Ltd
we are here to give you exceptional satisfaction 21
Computer Training Microsoft office 2007
WORD 2007 – COLLABORATIVE EDITING AND SECURITY · · · ·
To password protect documents Inserting comments Checking documents for sensitive ‘hidden’ information Tracking changes within a document
WORD 2007 – MASTER DOCUMENTS · · · ·
Creating a Master Document Inserting a table of contents into a master document Editing subdocuments Removing subdocuments
WORD 2007 -CONDITIONAL MAIL MERGING ·
Using conditional mail merging
WORD 2007 – MACROS · · ·
What are macros? Recording a macro Assigning a macro to a button
WORD 2007 – WEB PAGES AND HYPERLINKS · · · · · · · ·
Microsoft Word 2007 and the Internet Save a document as a Web page Previewing a Web formatted page Saving a Web page from the Internet Saving documents from a Web page Creating Internet Hyperlinks Editing Internet Hyperlinks Removing a hyperlink
WORD 2007 – THEMES ·
Using Themes
ICT Home Services Ltd
we are here to give you exceptional satisfaction 22
Computer Training Microsoft office 2007
Microsoft Excel 2007 Advanced Level Training Course Contents: EXCEL 2007 FUNCTIONS · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · ·
Excel 2007 Functions Getting help about using a particular function TODAY DAY MONTH YEAR SUMIF ROUND COUNT COUNTA COUNTIF PROPER UPPER LOWER CONCATENATE FV NPV PMT PV RATE HLOOKUP VLOOKUP IF AND OR ISERROR DSUM DMIN DMAX DCOUNT Nested functions
USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES · ·
Using a one input Data Table command Using a two input data table command
A FIRST LOOK AT EXCEL2007 PIVOT TABLES · ·
Creating a PivotTable Dropping data into the Pivot Table ICT Home Services Ltd we are here to give you exceptional satisfaction 23
Computer Training Microsoft office 2007 · Modifying data and refreshing the Pivot Table · Grouping data within a Pivot table
SCENARIOS · · · ·
Scenario Manager – an example Showing a scenario Viewing an alternative scenario Create a scenario summary
AUDITING · · · · · · ·
Tracing precedent cells Tracing the dependants of a cell Displaying all formulas within a worksheet Adding comments Displaying comments Removing comments Editing comments
MACROS · · · · · · ·
Displaying the Developer tab Recording and running macros Lowering your macro security level Customizing the Quick Access Toolbar Changing the Quick Toolbar Macro icon Removing a macro icon from the quick access toolbar Raising your macro security level
ICT Home Services Ltd
we are here to give you exceptional satisfaction 24
Computer Training Microsoft office 2007
Microsoft PowerPoint 2007 Advanced Level Training Course Contents: CUSTOMISING POWERPOINT 2007 OPTIONS · ·
Displaying the PowerPoint Options Getting help about PowerPoint Options
POPULAR OPTIONS · · · · · · · ·
Show the Mini Toolbar on selection Enabling Live Preview Showing the Developer tab on Ribbon Always use ClearType Colour Scheme Customising the ScreenTip Style Personalising your copy of Microsoft Office Language Settings
PROOFING OPTIONS · · · · ·
AutoCorrect options Replace With Exceptions Setting Microsoft Office spelling options Setting PowerPoint specific spelling options
SAVE OPTIONS · · ·
Setting the default file format for saving presentation Setting the AutoRecovery interval Setting the default file location
ADVANCED OPTIONS · · · ·
Setting the number of undo levels Setting the number of recently used documents displayed Setting the opening view Background printing
CUSTOMIZE OPTIONS · · ·
Adding a command to the Quick Access Toolbar Removing a command from the Quick Access toolbar Easy way of modifying the Quick Access toolbar
ICT Home Services Ltd
we are here to give you exceptional satisfaction 25
Computer Training Microsoft office 2007
ADD-INS OPTIONS ·
What are Add-Ins?
TRUST CENTER OPTIONS · · ·
Trust Center Settings Setting trusted locations Setting trusted locations
RESOURCES OPTIONS · · · · · ·
Updates Microsoft Office Diagnostics Contact Microsoft Microsoft Office Activation Microsoft Office Online About Microsoft PowerPoint 2007
PROPERTIES · ·
Viewing properties within a Presentation Editing properties
DOCUMENT INSPECTOR · ·
What is the Document Inspector? Using the Document Inspector
ENCRYPTION · · ·
Encrypting a presentation Opening an encrypted presentation Removing encryption from your presentation
DIGITAL SIGNATURES · · · ·
What is a digital signature? Creating a digital signature Viewing a digital signature Digital signature gives protection from changes
FINAL VERSIONS OF A PRESENTATION ·
Marking a presentation as the final version
COMPATIBILITY CHECKER ·
Checking compatibility with earlier versions of PowerPoint
CREATING HANDOUTS IN A MICROSOFT WORD DOCUMENT ·
Creating Microsoft Word formatted handouts
ICT Home Services Ltd
we are here to give you exceptional satisfaction 26
Computer Training Microsoft office 2007
PACKAGING A PRESENTATION FOR A CD · ·
Packaging a presentation for a CD Running a presentation packaged for a CD
USING THE POWERPOINT VIEWER · ·
What is the PowerPoint Viewer? Downloading the PowerPoint Viewer
PUBLISHING TO THE WEB · · · · · · ·
Saving a presentation in HTML format Publishing a presentation to the web Changing the web page title Setting Web options Customising colours Setting browser compatibility options Setting the screen resolution
WORDART · · · ·
Inserting a WordArt object Modifying the WordArt Text Fill Modifying the Text Outline Applying Text Effects
SYMBOLS ·
Inserting a symbol
COMMENTS · · · · ·
Adding comments Navigating between comments Editing comments Deleting comments Hiding comments
NARRATIONS · · · · · ·
Using a microphone Setting microphone levels for your narration Recording narrations Turing off narrations Deleting narrations Modifying narration quality
POWERPOINT DESKTOP SHORTCUT ·
Creating a PowerPoint Desktop shortcut
ICT Home Services Ltd
we are here to give you exceptional satisfaction 27
Computer Training Microsoft office 2007
HYPERLINKS · · · · ·
Inserting hyperlinks Using Hyperlinks Adding a ‘Home’ link Inserting a hyperlink pointing to a web site Removing hyperlinks
ICT Home Services Ltd
we are here to give you exceptional satisfaction 28
Computer Training Microsoft office 2007
Microsoft Access 2007 Foundation Level Training Course Contents: A FIRST LOOK AT ACCESS 2007 · · · ·
Creating and opening an Access database. Using views. Modifying settings within Access Using the Access Help facility
ACCESS 2007 DATABASE CONCEPTS · · · · · · · · · · ·
What is a database? What is a relational database? Tables Records Fields Field data types Field properties Primary key Index Table relationships Setting rules to ensure valid relationships
ACCESS 2007 TABLES · · · · · · · · · · · · · · ·
Creating and saving a table Specifying field data types. Adding and deleting records Adding fields Modifying data within a record. Navigating within a table Deleting a table. Defining Keys Defining a Primary key. Indexing a field with or without duplicates allowed. Changing field format attributes Simple validation rules Creating a one-to-one and a one-to-many relationship Deleting relationships Applying rules to relationships
ACCESS 2007 FORMS ·
Creating, opening, saving deleting and closing forms.
ICT Home Services Ltd
we are here to give you exceptional satisfaction 29
Computer Training Microsoft office 2007 · Navigating through records · Form headers and footers.
ACCESS 2007 QUERIES · · · · · · · ·
Finding data within a field. Applying a filters Creating and saving a single table query Use two table querys Using operators within queries Editing, running and deleting a query. Saving and closing a query. Sorting records
ACCESS 2007 REPORTS · · · ·
Creating and saving a report Grouping data under a specific field Displaying fields in a grouped report Headers, Footers
ACCESS 2007 PRINTING ISSUES · · ·
Previewing a table, form or report Changing orientation and paper size Printing options within Access
ICT Home Services Ltd
we are here to give you exceptional satisfaction 30
Computer Training Microsoft office 2007
Microsoft Access 2007 Intermediate Level Training Course Contents: WHAT’S NEW IN ACCESS 2007 · · · · · · ·
New features in Access 2007 Database Templates Local templates Downloading templates Enhanced Datasheet View New Layout View Improved Interface
ACCESS 2007 – TABLE DESIGN · · · · · ·
Modifying Fields Lookup Fields Validation Rules Input Masks Default Values Mandatory Fields
ACCESS 2007 – RELATIONSHIPS · · · · · · · ·
Basics of Relationships What are relationships? Understanding the basis for creating relationships Types of joins in a relationship Creating and modifying one-to-one, or one-to-many relationships Applying inner, outer, and self joins Applying and using referential integrity Applying automatic deletion of related records
ACCESS 2007 – QUERY TYPES · · · ·
Creating and using a query to update data in a table Creating and using a query to delete data in a table Creating and using a query to save the selected information as a table Appending records to a table using query
ACCESS 2007 – QUERY FORMULAS · · · ·
Grouping information in a query Using functions in a query Using Aggregate Functions COUNT function ICT Home Services Ltd
we are here to give you exceptional satisfaction 31
Computer Training Microsoft office 2007 · SUM function · AVG function · MIN function · MAX function · Using a crosstab query
ACCESS 2007 – FORMS · · · · · · · · ·
What are bound and unbound controls? Creating bound and unbound controls. Creating and editing a combo box, list box, check box and option groups. Creating arithmetic and logical expression controls on a form. Setting sequential order of controls on a form. Inserting data fields to appear within form header or footers What are sub forms? Creating a sub form and linking to parent. Modifying the sub form to change records.
ACCESS 2007 – REPORTS · · · · · ·
Creating arithmetic and logical calculation controls within a report. Calculating percentage calculation control within a report. Using formulas and expressions within a report. Creating running summaries within a report. Inserting a data field to appear within report header or footers Forcing page breaks for groups on reports.
ACCESS 2007 – MACROS · · ·
Recording & assigning macros Running macros. Assigning macros to a form, report or control.
ACCESS 2007 – IMPORTING, EXPORTING AND LINKING DATA · · ·
Importing files into a database. Exporting data as different formats. Linking external data to a database.
ICT Home Services Ltd
we are here to give you exceptional satisfaction 32
Computer Training Microsoft office 2007
Microsoft Access 2007 Advanced Level Training Course Contents: ACCESS 2007 FORM CUSTOMISATION · · · · · · · · · · · ·
Linking a form to a table Placing controls on the form Aligning controls on a form Sizing to fit controls on a form Special effects Setting tab order Placing a bound control on the form Placing a check box on the form Placing a command button on the form Placing a group box on the form Placing a combo box on the form Placing a list box on the form
TYPES OF FORMS · · ·
Popup forms Modal forms Split forms
LIMITING USER ACCESS · · ·
Limiting users from adding new records Limiting users from deleting existing records Limiting users from editing a records
EXPORTING FORM TO XML ·
Exporting to XML
REPORTS · · · · · · ·
Creating a report Creating an AutoFormat template Applying an AutoFormat to a report using the Report Wizard Applying an AutoFormat to an existing report Conditional formatting Subreports Formatting reports
ACCESS 2007 SWITCHBOARDS · · ·
What is an Access 2007 switchboard? Creating a Switchboard Adding a switchboard ICT Home Services Ltd we are here to give you exceptional satisfaction 33
Computer Training Microsoft office 2007 · Deleting a switchboard · Adding items to a Switchboard · Editing a Switchboard · Deleting items within a Switchboard · Editing items within a Switchboard · Making a Switchboard the default Switchboard · Displaying Switchboards automatically when opening a database
CUSTOMISING ACCESS · · · · · · ·
Customisation options within Microsoft Access 2007 Current Database options Datasheet options Object Designers options Proofing options Customize options Add-ins options
ICT Home Services Ltd
we are here to give you exceptional satisfaction 34
Computer Training Microsoft office 2007
Microsoft Project 2007 Foundation Level Training Course Contents: INTRODUCING PROJECT 2007 · · · · · · · · · ·
The Project 2007 Screen Using the Ask a Question Box Standard & Formatting Toolbar Task Panes Closing Microsoft Project Opening an existing Microsoft Project View Bar Project Guide Creating a new project Using templates
SETTING UP A PROJECT · · · · · · ·
File Properties Inputting Start and Finish Dates Setting up a Project Calendar Making a New Calendar Applying a new Calendar Saving a project Setting Currency and Language
TASKS, NOTES & MILESTONES · · · · · · ·
Entering Tasks Entering Subtasks Entering Task Durations Creating a Summary Task Recurring Tasks Task Notes Milestones
MANIPULATING TASKS & CONSTRAINTS · ·
Adding Constraints Editing & deleting & moving Tasks
DEPENDENCIES · · ·
Finish-to-Start (FS) Dependencies Start-to-Start (SS) Dependencies Start-to-Finish (SF) Dependencies
ICT Home Services Ltd
we are here to give you exceptional satisfaction 35
Computer Training Microsoft office 2007
RESOURCES · · · · ·
Creating a Resource List Working Time Rates Resource Notes Assigning Resources
VIEWS & SPLIT WINDOWS · · · · · · · ·
Gantt Chart View Calendar View Network Diagram View Task Usage View Resource Graph View Resource Sheet View Resource Usage View Splitting the Window
PRINTING & REPORTS · · · · · · · ·
Print Preview & Page Setup Print Dialog Box Overview Reports Current Activity Reports Cost Reports Assignments Reports Workload Reports Visual Reports
HELP DEMOS ·
Microsoft Project Help Demos
WHAT’S NEW IN PROJECT 2007? · · · · · ·
Multiple Level Undo Task Drivers Pane Change Highlighting Visual Reports Cost Resources Office Assistant
ICT Home Services Ltd
we are here to give you exceptional satisfaction 36
Computer Training Microsoft office 2007
Microsoft Publisher 2007 Foundation Level Training Course Contents: MICROSOFT PUBLISHER 2007 · · ·
Using Publisher 2007 Using File Types Using the Microsoft Web Site
CREATING A PUBLICATION GETTING STARTED · Selecting a publication type and template · Using page options · Using colour schemes · Using font schemes · Using quick publication options TEXT & PAGES · Entering text · Selecting text · Modifying font colour · Modifying the font size · Modifying the font type · Modifying line spacing · Modifying text alignment · Inserting drop caps · Inserting symbols · Inserting the date and time · Using the Format Painter · Using Undo and Redo · Using kerning · Using tracking · Using scaling PARAGRAPH MANIPULATION WITHIN PUBLISHER 2007 · Inserting bullets · Inserting numbers · AutoFit options PAGE MANIPULATION · Inserting pages into Publisher 2007 · Moving pages ICT Home Services Ltd
we are here to give you exceptional satisfaction 37
Computer Training Microsoft office 2007 · Deleting pages · Inserting page numbers · Inserting sections · Inserting headers and footers
GRAPHICS CLIPART & PICTURES · Inserting clipart · Inserting a graphic from a file · Inserting a graphic from a scanner or camera · The Picture Toolbar AUTOSHAPES · Inserting AutoShapes · Modifying AutoShape properties · Grouping and ungrouping AutoShapes · Rotating and flipping AutoShapes WORDART · Inserting a WordArt object · Modifying WordArt properties ARRANGING OBJECTS · The horizontal and vertical guides · The Ruler · The Layout guides dialog box · Baseline guides · Grid guides · Margin guides · Align commands · Distribute commands · Nudge commands · Snap commands
PERSONALISING THE PUBLICATION CUSTOMISING YOUR PUBLICATION · Applying backgrounds COLOUR SCHEMES · Applying a colour scheme · Creating a colour scheme · Editing a colour scheme · Deleting a colour scheme FONT SCHEMES · Applying a font scheme ICT Home Services Ltd
we are here to give you exceptional satisfaction 38
Computer Training Microsoft office 2007 · Creating a font scheme · Editing a font scheme · Deleting a font scheme INSERTING BUSINESS INFORMATION · Inserting information to a publication · Creating a new Business Information · Editing your information
TABLES AND TEXT BOXES TABLES · Inserting tables · Selecting tables · Merging cells · Splitting cells · Deleting tables · Using Table AutoFormat · Using the Format Table dialog TEXT BOXES · Inserting a text box · Moving a text box · Modifying text box direction · Resizing a text box · AutoFit · Deleting a text box
MASTER PAGES AND STYLES MASTER PAGES · Creating master pages · Editing master pages · Applying a master page STYLES · Creating a style · Modifying a style · Applying a style · Deleting a style CUSTOMISATION OPTIONS · Auto Recover options · AutoCorrect options · Spelling options · Toolbar options PROOFING, SAVING & PRINTING ISSUES ICT Home Services Ltd
we are here to give you exceptional satisfaction 39
Computer Training Microsoft office 2007 · Spell checking a publication · Print Preview & Zoom · The Design Checker · Printing options · Packing a publication options PUBLISHING TO THE WEB · Inserting a mailto link · Inserting hyperlinks · Publishing your site
ICT Home Services Ltd
we are here to give you exceptional satisfaction 40
Computer Training Microsoft office 2007
Microsoft Visio 2007 Foundation Level Training Course Contents: A FIRST LOOK AT VISIO · Microsoft Visio 2007 · Getting Started · Opening a sample file · Zooming · Pan and zoom · Closing a diagram · The Shapes Pane · The Drawing Page · The Task Pane · To switch Task panes · The Visio Toolbars · The Standard Toolbar · The Formatting Toolbar · Adding or removing Toolbars GETTING HELP · Typing a question to ask for help · Microsoft Office Visio Help · Help Table of Contents · Printing Help topics · Help Demos · Using the Microsoft Web Site
WORKING WITH DRAWINGS USING TEMPLATES · Types of templates available · Creating a new diagram based on a template USING SHAPES · About Stencils shapes · Adding a shape to the drawing area · Adding more shapes and connecting them to existing shapes · Adding text to the shape · Manually connecting shapes · Adding text to a Connector · Deleting a Connector · Saving your diagram · Opening a diagram file ICT Home Services Ltd
we are here to give you exceptional satisfaction 41
Computer Training Microsoft office 2007 MANIPULATING SHAPES · Moving shapes · Resizing shapes · Deleting shapes ADDING BACKGROUNDS, BORDERS AND TITLES · Opening the background stencil and assigning a background · Using the Border and Title Stencil MANAGING STENCILS · Displaying the Stencil Toolbar · Displaying / Hiding the Stencil Shapes Pane · Creating a new Stencil · Renaming a Stencil · Saving the Stencil · Adding Shapes to a Stencil · Adding Custom Shapes to a Stencil · Closing a Floating Stencil · Opening the Stencil
FORMATTING TEXT & SHAPES FORMATTING TEXT · Format Text Toolbar · Changing the Font Type · Font Size · Font Style, Bold, Italic and Underline · Font Color · Font Case · Horizontally Text Alignment · Vertical Text Alignment · Changing the Line Indention · Changing the Text Margins · Text Background Shading · Bullets FORMATTING SHAPES · Format Shape toolbar · Shape Fill Color · Shape Fill Pattern & Transparency · Shape Shadow Effects · Shape Line Color · Shape Line Weight · Shape Line Pattern · Shape Line Ends · Rounding Shape Corners · Themes ICT Home Services Ltd
we are here to give you exceptional satisfaction 42
Computer Training Microsoft office 2007
MANAGING SHAPES
POSITIONING AND ALIGNING SHAPES · Action Toolbar · Grouping shapes · Ungrouping shapes · Ordering shapes · Bringing a shape to the front · Sending a shape to the back · Sending shapes forwards or backwards · Rotating a shape to the right · Rotating a shape to the left · Free rotating a shape · Rotating text within the shape · Flipping a shape horizontally · Flipping a shape vertically · Aligning shapes · Distributing shapes · Adjusting shape layout · Centring a drawing FORMATTING CONNECTORS · Layout and Routing Toolbar · Connector routing options · Using curved connectors · Using straight connectors · Setting line jump options USING SNAP AND GLUE · Using the Snap and Glue Toolbar · Snapping and gluing · Viewing active snap and glue elements · Manually connecting shapes using Dynamic Glue · Manually connecting shapes using Static Glue · Manually connecting a series of shapes USING LAYERS · Layers · Assigning a shape to a layer · Showing and hiding layers INSERTING CLIPART · Clip Art
ICT Home Services Ltd
we are here to give you exceptional satisfaction 43
Computer Training Microsoft office 2007
SETTING UP AND EDITING PAGES MANAGING PAGES · Moving between pages · Inserting a new page · Renaming a page · Reordering pages · Deleting a page · Creating a background page · Assigning a background page USING PAGE VIEW TOOLS · View Toolbar · Showing and hiding the rulers · Showing and hiding the grid · Adding Guides · Showing and hiding the guides · Using the Size and Position window · Using the Drawing Explorer window · Setting a drawing scale
PRINTING AND SHARING DRAWINGS GETTING READY TO PRINT · Spell Check · Paper size and orientation · Print Preview PRINTING THE DRAWING · Selecting a printer · Printer Properties · Print Range · Number of Print Copies CUSTOMISING VISIO 2007 · Options Dialo
ICT Home Services Ltd
we are here to give you exceptional satisfaction 44
Computer Training Microsoft office 2007
Microsoft Outlook 2007 Foundation Level Training Course Contents: WHAT’S NEW IN OUTLOOK 2007 · · · ·
The Outlook 2007 Ribbon Message Flagging Navigation Pane Instant Search
A FIRST LOOK AT OUTLOOK 2007 · · · · · ·
The Microsoft Outlook Screen Help and Outlook demos Printing help sheets Navigation Pane Standard Toolbar Displaying or hiding toolbars
OUTLOOK 2007 – EMAIL CONCEPTS · · · · · ·
The structure of an email address The advantages of using email Spam or Unsolicited Email Viruses Phishing Digital signatures
OUTLOOK 2007 – SENDING MESSAGES · · · · · · · · ·
Creating and sending your first email Sending emails to multiple addresses Receiving emails Using blind carbon copy Setting message subject Spell checking your message Inserting a file into a message Setting message importance Setting message sensitivity
OUTLOOK 2007 – MANIPULATING MESSAGES · · · · · ·
The Inbox Folder The Inbox Screen Selecting a message Message Status icons Reading a message Forwarding a message
ICT Home Services Ltd
we are here to give you exceptional satisfaction 45
Computer Training Microsoft office 2007 · Opening or saving an attached file · Replying to the sender of a message · Replying to the sender and all recipients of a message · Printing a message · Previewing a message before printing · Printing Options
OUTLOOK 2007 – MANIPULATING TEXT AND FILES · · · · · · · · · · ·
Selection techniques Copying text to the Clipboard from a message Pasting text from the Clipboard into a message Copying text from one message to another Cutting text to the Clipboard from a message Moving text from one message to another Copying text from another application into a message Deleting text in a message Deleting text to the left of the insertion point Deleting text to the right of the insertion point Deleting an attached file from a message
OUTLOOK 2007 – CONTACTS · · · · · · · · ·
What are contacts? Creating a contact Adding the sender of a message to contacts Addressing an email to a contact Deleting a contact Creating a new distribution list Adding an email address to a distribution list Removing an email address from a distribution list Sending an email to a distribution list
OUTLOOK 2007 – ORGANISING MAIL · · · · · · · · · · · · · ·
Searching for a message Searching for messages Creating a new mail folder Moving a message to a different folder Deleting a mail folder Sorting the contents of the Inbox Deleting a message Opening the Deleted Items Folder Restoring a message from the Deleted Items Folder Emptying the Deleted Items Folder Flagging a message Removing a flag mark from a mail message Marking a message as unread Marking a message as read
ICT Home Services Ltd
we are here to give you exceptional satisfaction 46
Computer Training Microsoft office 2007
OUTLOOK 2007 – CUSTOMISING SETTINGS · · ·
Adding an Inbox heading Removing an Inbox heading Resetting the Inbox headings
ICT Home Services Ltd
we are here to give you exceptional satisfaction 47
