MS Office Course Training
Microsoft Office 2003 Proficiency Suite
"Made the subject matter fun and was inclusive of all levels of participants." -Pat Brannen, Atlanta, GA
- Includes roundtrip airfare and lodging (for boot camps held in Georgia and Florida only)
- Hands-on instruction by a certified instructor
- Includes all course materials and practice exams
- Includes all certification exams
- Onsite Testing
- Breakfast and Lunch provided each day
Microsoft Office Word
Use innovative tools and features to more easily create, share, and read great-looking documents.
Microsoft Office Excel
Excel enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes.
Microsoft Office PowerPoint
Improve the way you create, present, and collaborate on presentations. Use enhanced multimedia capabilities to deliver presentations with more impact.
Microsoft Word 2003 - Intermediate
In the first course in this series you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft® Office Word XP on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft® Word XP works for you, and you can improve the quality of your work by enhancing your documents with customized Microsoft® Word XP elements. In this course, you will increase the complexity of your Microsoft® Word XP documents by adding components such as customized lists, tables, charts, and graphics. You will also create personalized Microsoft® Word XP efficiency tools.
Course Objective: You will add complexity to Microsoft® Office Word XP documents and create personalized efficiency tools in Microsoft® Word XP.
Target Student: This course was designed for persons who can create and modify standard business documents in Microsoft® Word XP, and who need to learn how to use Microsoft® Word XP to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Office Specialist exams for Microsoft® Word XP.
Prerequisites: Students should be able to use Microsoft® Word XP to create, edit, format, save, and print basic business documents that contain text, basic tables, and simple graphics.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- manage data in lists.
- customize tables and charts.
- customize formatting.
- work with custom styles.
- modify pictures in a document.
- create customized graphic elements.
- control text flow.
- automate common tasks.
- automate document creation.
- perform mail merges.
Course Content
Lesson 1: Managing Lists
- Sort a List
- Restart a List
- Create an Outline Numbered List
- Customize List Appearance
Lesson 2: Customizing Tables and Charts
- Sort a Table
- Modify Table Structure
- Merge or Split Cells
- Position Text in a Table Cell
- Apply Borders and Shading
- Perform Calculations in a Table
- Create a Chart from a Word Table
- Modify a Chart
Lesson 3: Customizing Formatting
- Modify Character Spacing
- Add Text Effects
- Control Paragraph Flow
Lesson 4: Working with Custom Styles
- Create a Character or Paragraph Style
- Modify an Existing Style
- Create a List Style
- Create a Table Style
Lesson 5: Modifying Pictures
- Set Picture Contrast or Brightness
- Crop a Picture
- Wrap Text Around a Picture
Lesson 6: Creating Customized Graphic Elements
- Draw Shapes and Lines
- Insert WordArt
- Insert Text Boxes
- Create Diagrams
Lesson 7: Controlling Text Flow
- Insert Section Breaks
- Insert Columns
- Link Text Boxes
Lesson 8: Automating Common Tasks
- Run a Macro
- Create a Macro
- Modify a Macro
- Customize Toolbars and Buttons
- Add Menu Items
Lesson 9: Automating Document Creation
- Create a Document Based on a Template
- Create a Document by Using a Wizard
- Create or Modify a Template
- Change the Default Template Location
- Insert a MacroButton Field in a Template
Lesson 10: Performing Mail Merges
- The Mail Merge Process
- Perform a Merge on Existing Documents
- Merge Envelopes and Labels
- Use Word to Create a Data Source
[ back to top ]
Microsoft Excel 2003 - Introduction
In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.
Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.
Target Student: This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create a basic worksheet.
- modify a worksheet.
- perform calculations.
- format a worksheet.
- develop a workbook.
- print the contents of a workbook.
- customize the layout of the Excel window.
Course Content
Lesson 1: Getting Started with Excel
- An Overview of Excel
- Navigate in Excel
- Select Data
- Enter Data
- Save a Workbook
- Obtain Help
Lesson 2: Modifying a Worksheet
- Move and Copy Data Between Cells
- Fill Cells with Series of Data
- Insert and Delete Cells, Columns, and Rows
- Find, Replace, and Go To Cell Data
Lesson 3: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create an Absolute Reference
Lesson 4: Formatting a Worksheet
- Change Font Size and Type
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Create a Custom Number Format
- Align Cell Contents
- Find and Replace Formats
- Apply an AutoFormat
- Apply Styles
Lesson 5: Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook
Lesson 6: Printing Workbook Contents
- Set a Print Title
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Insert and Remove Page Breaks
- Print a Range
Lesson 7: Customizing Layout
- Split a Worksheet
- Arrange Worksheets
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
[ back to top ]
Microsoft Excel 2003 - Intermediate
In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.
Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create and apply templates.
- create and modify charts.
- work with graphic objects.
- calculate with advanced formulas.
- sort and filter data.
- use Excel with the Web.
Course Content
Lesson 1: Creating and Applying Templates
- Create a Workbook from a Template
- Create a Custom Template
- Working with Comments
- Create a Hyperlink
- Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
- Create a Chart
- Format Chart Items
- Change the Chart Type
- Create a Diagram
Lesson 3: Working with Graphic Objects
- Insert Graphics
- Create AutoShapes
- Format Graphic Objects
- Change the Order of Graphic Objects
- Group Graphic Objects
- Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
- Create and Apply a Name for a Range of Cells
- Calculate Across Worksheets
- Calculate with Date and Time Functions
- Calculate with Financial Functions
- Calculate with Statistical Functions
- Calculate with Lookup and Reference Functions
- Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
- Sort Data Lists
- Filter Data Lists
- Create and Apply Advanced Filters
- Calculate with Database Functions
- Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
- Export Excel Data
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
[ back to top ]
Microsoft PowerPoint 2003 - Introduction
In the past, you have used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use Microsoft® Office PowerPoint® XP to give electronic presentations.
Course Objective: You will create effective basic Microsoft® Office PowerPoint® XP presentations for delivery in front of an audience.
Target Student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic Microsoft® PowerPoint® XP presentations. This course is also intended for students who wish to pursue their Microsoft Office Specialist certification in PowerPoint XP.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- manipulate an existing PowerPoint presentation.
- begin creating a presentation.
- format text slides.
- add tables to a presentation.
- chart data in a presentation.
- modify objects on slides.
- add images to a presentation.
- prepare to deliver a presentation.
Course Content
Lesson 1: An Orientation to PowerPoint
- The PowerPoint Environment
- Orientation to Views
- Navigate Through a Presentation
- Edit Slide Text
- Save the Presentation
- Run a Slide Show
Lesson 2: Beginning a Presentation
- Create a New Presentation
- Change Background Color
- Add Slides to a Presentation
- Enter Text
- Create a Presentation from a Microsoft Word Outline
Lesson 3: Formatting Text Slides
- Apply Character Formats
- Align Text
- Change Line Spacing
- Change Indents
Lesson 4: Adding Tables to a Presentation
- Create a Table
- Format Tables
- Insert a Table from Microsoft Word
Lesson 5: Charting Data
- Create a Column Chart
- Edit Chart Data
- Change Chart Type
- Insert a Chart from Microsoft Excel
Lesson 6: Modifying Objects
- Resize Objects
- Copy and Duplicate Objects
- Move Objects
- Changing Object Orientation
- Format Objects
- Group and Ungroup Objects
- Change the Order of Objects
Lesson 7: Adding Images to a Presentation
- Add Clip Art
- Add a Picture from a File
- Draw Lines and Shapes
- Insert WordArt
Lesson 8: Preparing to Deliver a Presentation
- Spell Check
- Arrange Slides
- Add Transitions
- Create Speaker Notes
- Send a Presentation to Microsoft Word
- Print the Presentation
- Package a Presentation for CD
[ back to top ]
Microsoft PowerPoint 2003 - Advanced
As a Microsoft® Office PowerPoint® XP user familiar with the basics, you're able to convey information clearly without much glitz. That's okay, but you can do better-audiences expect more than the basics. In this course, you will enhance presentations with features that will transform basic presentations into those with a powerful means of communication.
Course Objective: You will use Microsoft® Office PowerPoint® XP features that draw, animate, and format presentations with professional-quality content such that they may be communicated to a wide variety of live, remote, and self-service audiences.
Target Student: This course is designed for students who desire to gain the skills necessary to work with design templates, organizational charts, special effects, Web presentations, collaboration functionality, and advanced presentation delivery, or students who desire to prepare for the Microsoft Office Specialist exam in Microsoft® PowerPoint® XP and who already have knowledge of the basics of Microsoft® PowerPoint® XP, including slide formatting, working with tables, images, and objects, charting data, and presentation preparation.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create a design template.
- create organization charts and diagrams.
- add special effects to a Microsoft® Office PowerPoint® XP slide.
- create a Web-based Microsoft® Office PowerPoint® XP presentation.
- use a Microsoft® Office PowerPoint® XP presentation for collaborative workgroup review.
- use functionality that will enable you to deliver live, self-service, and online presentations.
Course Content
Lesson 1: Creating a Custom Design Template
- Define Design Template Characteristics
- Create a Custom Color Scheme
- Set Up a Slide Master
- Format Custom Bullets
- Add a Footer
- Modify the Notes Master
- Save a Custom Design Template
Lesson 2: Adding Organization Charts and Diagrams
- Working with Organization Charts
- Update an Organization Chart
- Applying a Chart Layout
- Create a Diagram
- Draw a Flowchart
Lesson 3: Adding Special Effects
- Add Sound and Movies
- Add Animation
- Emphasize Objects
- Set a Motion Path
- Set the Order of Effects
Lesson 4: Creating Web Presentations
- Create a Group Home Page with the AutoContent Wizard
- Hyperlink to a Web Page
- Publish as a Web Page
Lesson 5: Collaborating in PowerPoint
- Set Password Protection
- Work with Comments
- Send a Presentation for Review
- Merge Revision Copies
- Apply Reviewer Changes
Lesson 6: Delivering a Presentation
- Hyperlink Within PowerPoint
- Add an Action Button
- Set Up a Custom Show
- Annotate a Presentation
- Working with Narrations and Slide Timings
- Set Up a Slide Show to Repeat Automatically
[ back to top ]
CED Solutions is your best choice for Microsoft Office ,
Microsoft Office training,
Microsoft Office certification,
Microsoft Office boot camp,
Microsoft Office certification training,
Microsoft Office certification course,
Microsoft Office course,
Microsoft Office class.
|
