Course Description:
Office professionals are recognized among their peers and managers as leaders in the daily use of different software products and as valued members of the office tream. This course is designed to give students the necessary skill sets to demonstrate their ability to multitask using many different software applications and accounting methodologies.
Competencies:
This course maps to all Microsoft Office Specialist certification tracks and is a nationally recognized industry standard.
Prerequisites:
There are no prerequisites for this course.
Course Outline:
Microsoft Word 2007 Level 1
Lesson 1: Creating a Basic Document
- Topic 1A: Explore the User Interface
- Topic 1B: Open and View a Document
- Topic 1C: Customize the Word Environment
- Topic 1D: Obtain Help
- Topic 1E: Enter Text
- Topic 1F: Save a Document
- Topic 1G: Preview and Print a Document
Lesson 2: Editing a Document
- Topic 2A: Navigate and Select Text in a Document
- Topic 2B: Insert, Delete, or Rearrange Text
- Topic 2C: Undo Changes
- Topic 2D: Search and Replace Text
Lesson 3: Formatting Text
- Topic 3A: Change Font Appearance
- Topic 3B: Highlight Text
Lesson 4: Formatting Paragraphs
- Topic 4A: Set Tabs to Align Text
- Topic 4B: Control Paragraph Layout
- Topic 4C: Add Borders and Shading
- Topic 4D: Apply Styles
- Topic 4E: Create Lists
- Topic 4F: Manage Formatting
Lesson 5: Adding Tables
- Topic 5A: Create a Table
- Topic 5B: Modify the Table Structure
- Topic 5C: Format a Table
- Topic 5D: Convert Text to a Table or Tables to Text
Lesson 6: Inserting Graphic Objects
- Topic 6A: Add Visual Effects Using Symbols and Special Characters
- Topic 6B: Insert Illustrations
Lesson 7: Controlling Page Appearance
- Topic 7A: Control Page Layout
- Topic 7B: Apply a Page Border and Color
- Topic 7C: Add Watermarks
- Topic 7D: Add Headers and Footers
Lesson 8: Proofing a Document
- Topic 8A: Check Spelling, Grammar, and Word Count
- Topic 8B: Enhance Textual Meaning Using the Thesaurus
- Topic 8C: Customize AutoCorrect Options
Microsoft Word 2007 Level 2
Lesson 1: Managing Lists
- Topic 1A: Sort a List
- Topic 1B: Renumber a List
- Topic 1C: Customize Lists
Lesson 2: Customizing Tables and Charts
- Topic 2A: Sort Table Data
- Topic 2B: Control Cell Layout
- Topic 2C: Perform Calculations in a Table
- Topic 2D: Create Charts
Lesson 3: Customizing Formatting with Styles and Themes
- Topic 3A: Create or Modify a Text Style
- Topic 3B: Create a Custom List or Table Style
- Topic 3C: Apply Default and Customized Document Themes
Lesson 4: Modifying Pictures
- Topic 4A: Resize a Picture
- Topic 4B: Adjust Picture Appearance Settings
- Topic 4C: Wrap Text Around a Picture
Lesson 5: Creating Customized Graphic Elements
- Topic 5A: Create Text Boxes and Pull Quotes
- Topic 5B: Draw Shapes
- Topic 5C: Add WordArt and Other Special Effects to Text
- Topic 5D: Create Complex Illustrations with SmartArt
Lesson 6: Inserting Content Using Quick Parts
- Topic 6A: Insert Building Blocks
- Topic 6B: Create Building Blocks
- Topic 6C: Modify Building Blocks
- Topic 6D: Insert Fields Using Quick Parts
Lesson 7: Controlling Text Flow
- Topic 7A: Control Paragraph Flow
- Topic 7B: Insert Section Breaks
- Topic 7C: Insert Columns
- Topic 7D: Link Text Boxes to Control Text Flow
Lesson 8: Using Templates to Automate Document Creation
- Topic 8A: Create a Document Based on a Template
- Topic 8B: Create a Template
Lesson 9: Automating Mail Merges
- Topic 9A: Perform a Mail Merge
- Topic 9B: Mail Merge Envelopes and Labels
- Topic 9C: Use Word to Create a Data Source
Lesson 10: Using Macros to Automate Tasks
- Topic 10A: Perform a Task Automatically Using a Macro
- Topic 10B: Create a Macro
Microsoft Excel 2007 Level 1
Lesson 1: Creating a Basic Worksheet
- Topic 1A: Explore the User Interface and the Ribbon
- Topic 1B: Navigate and Select in Excel
- Topic 1C: Obtain Help
- Topic 1D: Enter Data and Save a Workbook
- Topic 1E: Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Topic 2A: Create Basic Formulas
- Topic 2B: Calculate with Functions
- Topic 2C: Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Topic 3A: Manipulate Data
- Topic 3B: Insert and Delete Cells, Columns, and Rows
- Topic 3C: Search for Data in a Worksheet
- Topic 3D: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Topic 4A: Modify Fonts
- Topic 4B: Add Borders and Color to Cells
- Topic 4C: Change Column Width and Row Height
- Topic 4D: Apply Number Formats
- Topic 4E: Position Cell Contents
- Topic 4F: Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Topic 5A: Print Workbook Contents Using Default Print Options
- Topic 5B: Set Print Options
- Topic 5C: Set Page Breaks
Lesson 6: Managing Large Workbooks
- Topic 6A: Format Worksheet Tabs
- Topic 6B: Manage Worksheets in a Workbook
- Topic 6C: Manage the View of Large Worksheets
Microsoft Excel 2007 Level 2
Lesson 1: Calculating Data with Advanced Formulas
- Topic 1A: Manage Cell and Range Names
- Topic 1B: Calculate Data Across Worksheets
- Topic 1C: Use Specialized Functions
- Topic 1D: Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
- Topic 2A: Create and Modify Tables
- Topic 2B: Format Tables
- Topic 2C: Sort or Filter Worksheet or Table Data
- Topic 2D: Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
- Topic 3A: Create a Chart
- Topic 3B: Modify Charts
- Topic 3C: Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
- Topic 4A: Create a PivotTable Report
- Topic 4B: Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
- Topic 5A: Insert and Modify Pictures and ClipArt
- Topic 5B: Draw and Modify Shapes
- Topic 5C: Illustrate Workflow Using SmartArt Graphics
- Topic 5D: Layer and Group Graphic Objects