Excel 2003: Intermediate

CompuWorks Systems, Inc
Boston, Massachusetts, United States

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

Course Description:

'' Students will gain the skills needed to create and apply templates, create and modify charts and work with graphic objects. Students will also learn how to calculate with advanced formulas and sort and filter data.


Prerequisites: Introduction to Excel or equivalent experience


Length: One day



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

Creating and Modifying Charts
�Create a Chart
�Format Chart Items
�Change the Chart Type
�Create a Diagram

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

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

Sorting and Filtering Data
�Sort Data Lists
�Filter Data Lists
�Create and Apply Advanced Filters
�Calculate with Database Functions
�Add Subtotals to a Worksheets

Using Excel with the Web
�Export Excel Data
�Publish a Worksheet to the Web
�Import Data from the Web
�Create a Web Query
...''

Phone:1-781-224-1113

School Address:

Boston Training Center, 99 Bedford Street, Boston, MA 02111

2 Pleasure Island Road, Suite 2B, Wakefield, MA 01880



Jobs & Resumes: Boston
Houses & Roommates: Boston

BlackBerry Desktop Manager V4.0
BlackBerry Enterprise Server v4.0 for Microsoft Exchange
Crystal Reports 9.0 Level 1
Crystal Reports v9.0 Level 2
Dreamweaver MX Level 1
Dreamweaver MX Level 2
Dreamweaver MX Level 3
Excel VBA
Excel 2003: Getting Started
Excel 2003: Advanced
FrontPage 2003: Getting Started
Advanced FrontPage 2003
HTML
Outlook 2003
Photoshop
PowerPoint
Project 2003
Visio 2003 Professional

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: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.