Excel 2003: Core and expert

UWIN Pro Business and Technology Solutions
Scarborough, Onatrio, Canada

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

Course Description:

'' Microsoft® Excel® 2003 provides comprehensive tools to help you create, analyze, and share spreadsheets. You can analyze your data with charts, PivotTable® dynamic views, and graphs. You can also post your results to the Web for universal viewing and collaboration.

To provide you with the necessary skills to:

* Use Excel 2003 functions
* Share workbooks with colleagues
* Use basic and advanced graphing features
* Use web publishing features
* Use File protection features
* Create and use PivotTables
* Use the Scenario Manager, Solver, and Goal Seeker Features
* Use Object and Data Linking capabilities

This course is designed for people seeking to gain proficiency with this powerful spreadsheet application. In addition to providing real-world skills for workbook creation, editing, and analysis, this course will help you prepare for the Excel 2003 Expert level Microsoft Office User Specialist (Microsoft Office Specialist) Certification as well.




You should be familiar with using personal computers and be comfortable with the mouse and keyboard. Basic typing skills is essential as well.





Module 1: Getting Started with Excel

An Overview of Excel
Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help

Module 2: Modifying a Worksheet

Move and Copy Data Between Cells
Fill Cells with Series of Data
Edit Cell Data
Insert and Delete Cells, Columns, and Rows
Find, Replace, and Go To Cell Data
Spell Check a Worksheet

Module 3: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference

Module 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

Module 5: Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

Module 6: Printing Workbook Contents

Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Print a Range

Module 7: Customizing Layout

Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

Module 8: 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

Module 9: Creating and Modifying Charts

Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram

Module 10: 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

Module 11: 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

Module 12: Sorting and Filtering Data

Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet

Module 13: Using Excel with the Web

Export Excel Data
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Module 14: Streamlining Workflow

Create a Macro
Edit a Macro
Customize Access to Excel Commands
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook’s Properties
Modify Excel’s Default Settings

Module 15: Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures

Module 16: Auditing Worksheets
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and Evaluate Formulas
Group and Outline Data

Module 17: Analyzing Data
Create a Trendline
Create Scenarios
Perform What-If Analysis
Develop a PivotTable© Report
Develop a PivotChart© Report
Perform Statistical Analysis with the Analysis ToolPak

Module 18: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Module 19: Importing and Exporting Data
Export to Microsoft Word
Import a Word Table
Import Text Files

Module 20: Structuring XML Workbooks
Develop XML Maps
Import, Add, and Export XML Data
Manage XML Workbooks
Apply XML View Options


...''

Phone:(647) 436-8579

School Address:

705 Progress Avenue, Unit 105
Scarborough, Onatrio
M1H 2X1 Canada



Jobs & Resumes: Scarborough
Houses & Roommates: Scarborough

Search other schools for Excel 2003: Core and expert training resources.

Business Tools for Effective Managers and Business Owners
Business Analysis
Administrative Assistant
Computerized Accounting
Simply Accounting
QuickBooks Pro 2008
ACCPAC System Manager & General Ledger
ACCPAC Accounts Payable & Accounts Receivable
ACCPAC Inventory Control, Order Entry and Purchase Order Modules
MS Word
Office Outlook 2003: Core and expert
Office PowerPoint 2003: Core and expert
Office Access 2003: Core and expert
Medical Office Assistant

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: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.