Excel

School/Trainer: Beacon Training Services
Addison, Austin, Dallas, Fort Worth, Irving, Plano, Richardson, Texas, United States

Course Type: Classroom

Description:

"This course is the second in a three-course series that satisfies the requirements for the Microsoft Office Specialist (MOS) certification. This course gives you an opportunity to work with some more advanced features of Excel 2002, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration.

Goals/Objectives

· Use Excel templates and user-defined templates to create templates and workbooks.

· Use a variety of techniques to sort and filter data.

· Re-use and share data by importing and exporting and saving to the Web.
· Use various functions and auditing features to create advanced formulas and audit worksheets.

· Use PivotTables, PivotCharts, and other analysis tools to analyze data.

· Use Web features and comments to collaborate with others.

Outline/Table of Contents

Working with Templates

· Create a Workbook from an Excel Template

· Create a Template

· Create a Graphic

· Create a Workbook from a User-Defined Template

Sorting and Filtering Data

· Sort Data

· Add Subtotals to a Worksheet

· Filter Lists

· Create and Apply Custom Filters

Importing and Exporting Data

· Import Data from the Web

· Import Data from an External Source

· Export Data

· Save a Worksheet as a Web Page

· Publish a Worksheet to the Web
Working with Advanced Formulas

· Share Data Among Worksheets

· Create a Name for a Range of Cells

· Use Functions to Create Advanced Formulas

· Trace Cell Precedents

· Trace Cell Dependents

· Locate Errors in Formulas

Analyzing Data

· Create a PivotTable Report

· Create a PivotChart Report

· Create Scenarios

· Use Solver

· Use Goal Seek

Collaborating

· Insert and Edit a Hyperlink

· Add and Edit Comments in a Worksheet

· Create Discussion Comments

· Respond to Discussion Comments

Appendix A: Microsoft Office Specialist Program

Appendix B: Internet and Computing Core Certification (IC³) Program

..."

Phone:972-404-0069

School Address:

via e-mail at: info@beacontraining.com or call us at 972-404-0069

Search other schools for Excel training