|
|
|
ic3-002-ver7.7-sg
IC3 Key Applications - Using Windows XP, Microsoft Word, Excel, PPT 2003 (8 days)
Description
The skills and knowledge acquired in IC3 Key Applications Using Windows XP, Word, Excel and PowerPoint 2003 are sufficient to be able to perform various functions to open, create and work efficiently using Microsoft Word, Excel, PowerPoint 2003.
Audience
IC3 Key Applications Using Windows XP, Word, Excel and PowerPoint 2003 is designed for users who are keen to extend their understanding and knowledge of the software.
Prerequisites
IC3 Key Applications Using Windows XP, Word, Excel and PowerPoint 2003 assume little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Course Disk
Many of the topics in IC3 Key Applications Using Windows XP, Word, Excel and PowerPoint 2003 require you to open an existing file with data in it.
Methodology
The In Focus series of publications have been written with one topic per page. Topic sheets either contain relevant reference information, or detailed step-by-step instructions designed on a real-world case study scenario.
Objectives
At the completion of IC3 Key Applications Using Windows XP, Word, Excel and PowerPoint 2003 you should be able to:
• use application programs in Windows
• find your way around the Microsoft Word 2003 screen
• access and use the help system and work safely with your computer
• open, save and close documents and understand how documents are presented on the screen
• create a new document
• select and work with text in a document
• use the print facilities in Windows
• format text in a document
• work with fonts
• create and modify a style, and apply a style to text in a document
• use the various page settings in Word
• create tables of figures and text
• print a document
• start Microsoft Excel, navigate workbooks, and exit correctly
• create, modify, save, and close a simple workbook
• select ranges of cells in a workbook
• copy and fill data in a workbook
• format cells in a workbook
• apply a range of formatting options to numbers
• format cells and ranges to improve the appearance of worksheet
• print data in a workbook
• create formulas that perform calculations in a workbook
• understand and use absolute referencing in a workbook
• sort data in lists in a workbook
• create a variety of charts (graphs) in Excel
• start and navigate around PowerPoint
• start and navigate around PowerPoint
• create a presentation
• work with slides, slide layouts and background colours
• work with text in PowerPoint
• create tables, charts and diagrams in a presentation
• modify charts in a presentation
• insert and work with pictures and images
• use various drawing objects to create simple drawings
• create slide masters for use in presentations
• use a range of printing techniques and view your presentation as web pages
Course Outline
Using Applications • Starting An Application From The Start Menu • Starting An Application From A Folder • Opening Multiple Applications • Managing Multiple Applications • Minimising And Restoring Applications • Closing Applications • Accessing Recently Used Applications • Dealing With Non-Responding Applications • Viewing Installed Applications • Installing A New Application • What Happens During Installation • Uninstalling An Application • Capturing A Screen Image
Word 2003 Orientation • Starting Word • The Word 2003 Screen • Using The Ruler • The Status Bar • Exiting Word • Understanding Toolbars In Word 2003
General Computer Usage • Printed Help Sources • The Help Task Pane • Searching For General Help • Searching For Specific Help • Understanding A Help Window
Working With A Document • Opening A Document • Document Views • Page Zooming • Simple Editing • Formatting Marks • Saving A Document • Print Preview • Printing A Document • Closing A Document • Creating A Document
Creating A Blank Document • Typing Text • Typing Numbers • Inserting A Date • Spelling And Grammar Checking • Saving A New Document • Creating A Document Based On A Template
Working With Text • Techniques For Selecting Text • Selecting Text Using The Mouse • Selecting Text Using The Keyboard • Insert And Overtype Modes • Deleting Text • Cutting And Pasting • Copying And Pasting • Find And Replace • Using Undo • Click And Type • Using Redo • Drag & Drop Cutting • Drag & Drop Copying • Using Repeat • Inserting Symbols • Searching For Words And Phrases • Replacing Words And Phrases
Printing • How Printing Works • Checking Available Printers • Adding A Local Printer • Changing The Default Printer • Sharing A Printer • Adding A Network Printer • Printing A Document • Printing Multiple Documents • Pausing A Printer • Viewing The Print Queue • Changing Priorities In The Print Queue • Purging A Print Job • Printing From The Queue • Printing From A Text Editor
Formatting Text • Formatting Essentials • Toolbar Formatting • Quick Alignment • Instant Bullets • Instant Numbers • Increase Indent • Decrease Indent • Quick Fonts • Changing The Text Colour • Using The Format Painter • Paragraph Spacing • Line Spacing • Revealing Text Formatting • Inserting And Removing Paragraph Marks • Inserting And Removing Line Breaks
Working With Fonts • Changing Fonts • Changing Font Styles • Changing Font Size • Strikethrough • Superscript And Subscript • Changing Case • Drop Capitals
Using Styles • Styles • Applying Existing Styles • Applying Styles To Text
Working With The Page • Page Margins • Selecting Paper Size • Page Orientation • Hyphenation • Headers And Footers • Formatting Headers And Footers • Inserting Page Numbers • Inserting Page Breaks • Finding And Removing Page Breaks
Creating Tables • Creating A Table • Selecting In Tables • Adding Data To A Table • Inserting Columns And Rows • Deleting Columns And Rows • Changing Column Widths • Shading And Colouring Cells • Modifying Borders • Modifying Border Styles • Changing Row Height
Printing Options • Previewing Larger Documents • Printing Larger Documents • Printing And Collating Multiple Copies • Printing Specific Pages • Printing To A File • Foreground And Draft Printing
Excel 2003 Orientation • Starting Excel 2003 • The Excel 2003 Screen • Understanding The Workbook • Moving The Cell Pointer • Moving About The Workbook • Using Go To • Exiting Excel 2003
A Simple Workbook • Creating A New Workbook • Entering Data In A Workbook • Saving A New Workbook • Typing Text • Typing Numbers • Typing Dates • Typing Simple Formulas
Selecting Ranges • Selecting Contiguous Ranges • Selecting Non-Contiguous Ranges • Selecting Larger Ranges • Selecting A Row • Selecting Adjacent Rows • Selecting A Column • Selecting Adjacent Columns
Copying And Filling • Understanding Copying In Excel • Using Fill For Quick Copying • Copying From One Cell To Another • Copying From One Cell To Multiple Cells • Copying From Many Cells To Many Cells • Copying Relative Formulas • Copying To A Non-Contiguous Range • Copying Between Worksheets • Copying Between Open Workbooks • Filling A Series • Filling A Growth Series
Formatting Cells • Using The Font Tools • Using The Alignment Tools • The Format Cells Dialog Box • Formatting Fonts Using The Menu • Wrapping Text
Formatting Numbers • Formatting To A Specific Number Of Decimals • Indicating Thousands • Formatting Using Various Date Styles • Formatting Using Various Currency Symbols • Formatting Numbers As Percentages
Formatting For Effect • Applying Bolding • Applying Italics • Applying Underlining • Applying Double Underlining • Changing Cell Contents Colours • Changing Cell Background Colours • Copying Formats From One Range To Another • Aligning Cells And Ranges Left • Aligning Cells And Ranges Right • Aligning Cells And Ranges Centre • Aligning Cells And Ranges Top • Aligning Cells And Ranges Bottom • Centering A Title Over A Range • Changing Cell Content Orientation • Adding Borders To Cells And Ranges
Printing • Print Preview • Simple Printing • Previewing Large Worksheets • Page Orientation • Scaling To Fit • Printing To Multiple Pages • Scale To A Specific Number Of Pages • Specifying Number Of Copies • Printing An Entire Workbook • Specifying Paper Size • Understanding Paper Sizes
Formulas • Understanding Formulas • Formulas That Add • Formulas That Subtract • Formulas That Multiply And Divide • Referential Formulas • Formula Error Checking • Common Error Messages • Absolute Referencing
Absolute And Relative Referencing • Problems With Relative Formulas • Creating Absolute References • Creating Mixed References • Circular References
Sorting • Performing A Simple Sort • Sorting In Ascending Alphabetic Order • Sorting In Descending Alphabetic Order • Sorting In Ascending Numeric Order • Sorting In Descending Numeric Order
Charting • Using The Chart Wizard • Changing The Chart Type • Printing A Chart • Creating A Pie Chart • Creating A Bar Chart • Deleting A Chart • Creating A Column Chart • Creating A Line Chart • Moving A Chart To Another Workbook • Copying A Chart Within A Worksheet • Copying A Chart To Another Workbook • Resizing A Chart • Adding A Title To A Chart • Adding A Label To A Chart • Removing A Title From A Chart • Removing A Label From A Chart • Changing Background Colour In A Chart • Changing Line And Column Colours • Changing Pie Slice Colours • Changing Bar Colours
PowerPoint 2003 Orientation • Starting PowerPoint • The PowerPoint Screen • Using The Toolbars • Understanding Settings • Modifying Basic Options • Exiting PowerPoint
Working With Presentations • Opening An Existing Presentation • Opening Several Presentations • Switching Between Open Presentations • Using The Zoom Tool • Understanding PowerPoint Views • Switching Between Views • Closing A Presentation
Creating A Presentation • New Presentations • Creating A New Presentation • Adding Text Using The Outline Pane • Saving A Presentation • Adding Slides And Text • Previewing A Slide Show
Working With Slides • Changing Built-in Slide Layouts • Adding A Title Slide • Adding A Chart And Text Slide • Adding A Bulleted List Slide • Adding A Table Slide • Changing Background Colour Of Slides
Text Techniques • Text Pointers • Text Layouts • Adding Text Directly To A Slide • Formatting Text • Deleting A Text Placeholder • Editing Text • Changing Text Appearance • Changing Text Formatting • Changing Text Case • Changing Text Colour • Applying Shadows To Text • Changing Text Alignment • Adjusting Line Spacing • Changing Bullet And Number Styles • Using Undo And Redo
Tables Charts & Diagrams • Create A Table • Charts • Creating A Chart • Creating A Bar Chart • Creating A Line Chart • Creating A Pie Chart • Modifying Charts
Modifying Charts • Modifying Chart Colour • Modifying Column Colour • Modifying Bar Colour • Modifying Line Colour • Modifying Chart Backgrounds • Resizing Charts • Duplicating Charts • Moving Charts • Deleting Charts
Pictures And Images • Inserting A Picture From A Gallery • Inserting Images From A File • Duplicating Text, Pictures And Images • Moving Text, Pictures And Images • Resizing Pictures And Images • Deleting Text, Pictures And Images
Drawing Objects • Drawing Tools • Arrows And Lines • AutoShapes • Layering Objects • Drawing Various Shapes • Changing Fill And Line Formatting • Changing Arrow Formatting • Applying Shadows To Drawn Objects • Rotating And Flipping Drawn Objects • Aligning Drawn Objects • Resizing Drawn Objects • Bringing Drawn Objects Forward • Duplicating Drawn Objects • Moving Drawn Objects • Deleting Drawn Objects
Slide Masters • Using Master Slides • Viewing The Slide Masters • Adding A Logo Image • Adding Automatic Slide Numbers • Inserting Pictures And Drawn Objects • Deleting Pictures, Images And Drawn Objects • Adding Footer Text • Adding Footer Dates
Printing & Publishing • Printing & Publishing Options • Previewing & Printing Slides • Printing Handouts • Adding Speaker Notes • Printing Notes Pages • Printing The Outline • Printing For Overhead Transparencies • Printing Slides • Printing Specific Slides
Concluding Remarks
|
|
|
|
|
