In this course, you will acquire the knowledge and skills required to perform functions common to all Microsoft Windows applications, with an emphasis on the common functionality between the three Microsoft Office applications: Microsoft Word, Excel, and PowerPoint.  Elements include the ability to start and exit either the Word, Excel, or PowerPoint applications, modify the display of toolbars and other on-screen elements, use online help, and perform file management, editing, formatting and printing functions common to most Windows applications.

Prerequisites

IC3 Computer Fundamentals or equivalent knowledge.

---

Objectives

After completing this course, students will be able to:

Using Microsoft Word

• Start Word
• Open a Word file
• Switch between documents
• Change the view of a document
• Change the magnification level of a document
• Close a Word file
• Get help
• Exit from Word
• Enter text into a document
• Save a document
• Print a document
• Use AutoText
• Perform a spelling and grammar check
• Move the insertion point within a document
• Insert text into a document
• Delete text from a document
• Reverse an edit operation
• Find text in a document
• Find and replace text in a document
• Move a text block
• Copy a text block
• Apply attributes to text
• Apply a new font and font size to text
• Indent a paragraph
• Reset line and paragraph spacing in a document
• Reset paragraph alignment in a document
• Use the Format Painter
• Reset the left and right margins of a document
• Reset the page orientation and paper size for a document
• Set and clear tab stops in a document
• Create a bulleted/numbered list
• Apply styles to text
• Create a new style
• Use AutoFormat
• Apply a theme to a document
• Insert a hard page break into a document
• Add borders and shading to text
• Add a header/footer to a document
• Add page numbers to a document
• Insert a section break into a document
• Insert a table into a document
• Format a table
• Insert and delete rows/columns in a table
• Merge and split table cells
• Enter vertical text into a table cell
• Split a table
• Draw a table (using options on the Tables and Borders toolbar)
• Use Table AutoFormat
• Convert tables to text
• Use a Word template to create a document
• Insert a picture into a document
• Create a drawing in a document
• Add special effects to text
• Insert symbols into a document
• Create comments in a document
• Create outlines

Using Microsoft Excel

• Start Excel
• Open an Excel file
• Switch between workbooks
• Change the view of a worksheet
• Change the magnification level of a worksheet
• Close an Excel file
• Get help
• Exit from Excel
• Move the cell pointer in a worksheet
• Enter labels and values into a worksheet
• Enter a formula into a worksheet
• Reverse an edit operation
• Save a workbook
• Adjust column width in a worksheet
• Adjust row height in a worksheet
• Print a worksheet
• Work in Edit mode
• Select ranges in a worksheet
• Use AutoFill
• Copy cell entries
• Move cell entries
• Clear cells
• Use AutoSum
• Insert and delete rows and columns
• Insert and delete a range of cells
• Reset the alignment of cell entries
• Reset font options for cell entries
• Reset the number format of cell entries
• Add borders and shading to a worksheet
• Create a new style
• Apply a style
• Use AutoFormat
• Change the page setup for a worksheet
• Preview a worksheet
• Insert a manual page break into a worksheet
• Include print titles in a printout
• Print selected worksheet entries
• Use the SUM function
• Use the AVERAGE function
• Use the MAX function
• Use the MIN function
• Use the COUNT function
• Use absolute cell references in Excel formulas
• Rename worksheets in a workbook
• Move the cell pointer from one worksheet to another in a workbook
• Insert a new worksheet into a workbook
• Delete a worksheet from a workbook
• Enter a formula to link related worksheets in a workbook
• Format multiple worksheets in one operation
• Preview and print multiple worksheets in one operation
• Plot a chart
• Modify and enhance a chart
• Preview and print a chart
• Sort the records of a list
• Insert a picture into a worksheet
• Create a drawing on a worksheet
• Hide rows and columns in a worksheet
• Create a custom table (using Alignment options in the Format Cells dialog box)

Using Microsoft PowerPoint

• Start PowerPoint
• Open a PowerPoint file
• Switch between slide presentations
• Change the view of a slide presentation
• Change the magnification level of a slide
• Close a PowerPoint file
• Get help
• Exit from PowerPoint
• Save a presentation
• Print a slide
• Create and delete slides
• Add content to a slide
• Insert and modify pictures
• Assign transitions to slides
• Change the order of slides
• Create speaker notes
• Preview a slide show
• Navigate through a slide show

---

Course Materials

The courseware (book) and student data files are included with the class.

[IC3A]  [IC3B]  [IC3C]

Top of Page