Customer Relationship Specialist 2009

Code: CRS2009
Price:

Customer Relationship Specialist 2009

Course Description:
Customer relationship specialists excel in bridging the gap between the client and the enterprise through the use of CRM and Microsoft Office software. This course teaches students how to use Microsoft Office in combination with customer relationship management software to deliver robust customer service to the enterprise environment.

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

Lesson 6: Custom

Guaranteed to Run

2019-12-11 09:00 to 2019-12-13 17:00
Attend Online
2019-11-22
09:00 to 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-11-21 09:00 to 2019-11-22 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-11-15
09:00 to 17:00
Attend Online
2019-11-07 09:00 to 2019-11-08 17:00
Attend Online
2019-11-07 09:00 to 2019-11-08 17:00
Attend Online
2019-11-06 09:00 to 2019-11-08 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-11-04 09:00 to 2019-11-08 17:00
Attend Online
2019-11-01
09:00 to 17:00
Palm Beach County Florida (Instructor-Led)
2019-11-01
09:00 to 17:00
Raleigh, North Carolina (Instructor-Led)
2019-10-30 09:00 to 2019-11-01 17:00
Attend Online
2019-10-28 09:00 to 2019-11-01 17:00
Northern New Jersey (Virtual Instructor-Led)
2019-10-24 09:00 to 2019-10-25 17:00
Fort Lauderdale, Florida (Instructor-Led)
2019-10-24 09:00 to 2019-10-25 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2019-10-23 09:00 to 2019-10-25 17:00
Attend Online
2019-10-21 09:00 to 2019-10-25 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2019-10-21 09:00 to 2019-10-25 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review