Excel

Beacon Training Services
Addison, Austin, Dallas, Fort Worth, Irving, Plano, Richardson, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course 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

Jobs & Resumes: Addison, Austin, Dallas, Fort Worth, Irving, Plano, Richardson
Houses & Roommates: Addison, Austin, Dallas, Fort Worth, Irving, Plano, Richardson

WebSphere Programming
BEA Tuxedo 6.5 System & Middleware Concepts for Application Developers
Six Thinking Hats
CORBA Architecture and Programming Using Java
RMI Development using Java
Korn Shell Programming
Solaris 7 System Administration
Programming C# and .NET
Crystal Reports 9.0
Cascading Style Sheets
DATA MODELING
ASP.NET Boot Camp
TSO ISPF
IBM Systems/390 Assembler Language Coding
UNIX Fundamentals
AIX System Administration
TCP/IP
Flash
JavaScript

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.