computer training
enterprise training solutions

Home :: Onsite Computer Training

Onsite Microsoft Excel 2003 Training Classes

onsite computer training

Does your team need to sharpen their Excel skills? CBT Planet's onsite Excel 2003 training is the perfect choice for raising the bar with Excel. Let our certified instructor conduct the Microsoft Excel 2003 class at your location and show your team how to use Excel to its fullest.

Not only will your employees finally master Excel and get hands-on practice, you will see significant cost-savings. The onsite Excel 2003 training course quickly becomes cost effective with at least six students enrolled. Rather than sending the team offsite and paying travel costs, choose the Microsoft Excel 2003 course.

Onsite Excel 2003 training keeps everyone nearby and eliminates travel and related expenses. This makes it both affordable and popular with employees. Results are instantaneous because once the Excel 2003 class is over, students can start using their new skills on the job.

Onsite Microsoft Excel 2003 training is more affordable than you think; give us a call for details.

Common Questions:
   
Maximum number of student allowed: 15
Number of hours: 8 hours per level. We start from 9 am to 5 pm.
Books Included: Yes. Each student will receive their own course manual.
Online Training Included: Optional. Receive 50% off the list price when bundled.
Computers Included: No - Customer must provide computers and software.
Instructor Background: Minimum 6 years experience in the field.
Price: Call 1-866-718-7246
 
Excel 2003 Outline:
 

Basic Excel 2003 - 1 day

Unit 1: Getting started
Topic A: Spreadsheet terminology
Topic B: Exploring the Excel window
Topic C: Getting help
Topic D: Opening and navigating workbooks
Topic E: Closing workbooks

Unit 2: Entering and editing data
Topic A: Creating workbooks
Topic B: Entering and editing labels and values
Topic C: Entering and editing formulas
Topic D: Saving and updating workbooks

Unit 3: Modifying a worksheet
Topic A: Moving and copying data
Topic B: Moving and copying formulas
Topic C: Using absolute references
Topic D: Inserting and deleting ranges

Unit 4: Using functions
Topic A: Entering functions
Topic B: Using AutoSum
Topic C: Using AVERAGE, MIN, and MAX

Unit 5: Formatting worksheets
Topic A: Formatting text
Topic B: Formatting rows and columns
Topic C: Number formatting
Topic D: Using Format Painter and AutoFormat

Unit 6: Printing
Topic A: Preparing to print
Topic B: Page Setup options
Topic C: Printing worksheets

Unit 7: Creating charts
Topic A: Chart basics
Topic B: Modifying charts
Topic C: Printing charts

Unit 8: Web features
Topic A: Saving workbooks as Web pages
Topic B: Hyperlinks
Topic C: Sending workbooks via e-mail

Excel 2003 Intermediate - 1 day

Unit 1: Working with large worksheets
Topic A: Viewing options
Topic B: Hiding, displaying, and outlining data
Topic C: Printing large worksheets

Unit 2: Using multiple worksheets and workbooks
Topic A: Using multiple worksheets
Topic B: Linking worksheets by using 3-D formulas
Topic C: Consolidating data
Topic D: Linking workbooks
Topic E: Managing workbooks

Unit 3: Customizing Excel
Topic A: Using the Options dialog box
Topic B: Customizing toolbars and menus

Unit 4: Advanced formatting
Topic A: Borders and shading
Topic B: Using special number formats
Topic C: Working with dates
Topic D: Working with styles
Topic E: Other advanced formatting

Unit 5: List management
Topic A: Examining lists
Topic B: Sorting and filtering lists
Topic C: Advanced filtering

Unit 6: Advanced charting
Topic A: Chart formatting options
Topic B: Using combination charts
Topic C: Using graphic elements

Unit 7: Documenting and auditing
Topic A: Auditing features
Topic B: Comments and text boxes
Topic C: Protection
Topic D: Workgroup collaboration

Unit 8: Using templates
Topic A: Built-in templates
Topic B: Creating and managing templates

Excel 2003 Advanced - 1 day

Unit 1: Working with advanced formulas
Topic A: Using names
Topic B: Using decision-making functions
Topic C: Creating nested functions
Topic D: Using financial functions

Unit 2: Lookups and data tables
Topic A: Working with lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables

Unit 3: Advanced list management
Topic A: Creating subtotals
Topic B: Validating cell entries
Topic C: Exploring database functions
Topic D: Working with data forms

Unit 4: Working with PivotTables and PivotCharts
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: Working with PivotCharts

Unit 5: Exporting and importing
Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Topic C: Querying external databases

Unit 6: Using analytical options
Topic A: Working with Goal Seek and Solver
Topic B: Working with the Analysis ToolPak
Topic C: Working with scenarios
Topic D: Working with views

Unit 7: Working with macros
Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Function procedures

Unit 8: Interactive Web pages
Topic A: Creating interactive Web spreadsheets
Topic B: Publishing PivotTables on the Web

Unit 9: Using SharePoint services
Topic A: Document Workspaces

 

If your city is not listed, please contact us and we can try to accomodate your onsite corporate training needs.

  • Abilene, TX
  • Albany, NY
  • Albany, GA
  • Albuquerque, NM
  • Alexandria, LA
  • Allentown, PA
  • Altoona, PA
  • Amarillo, TX
  • Anchorage, AK
  • Anniston, AL
  • Appleton, WI
  • Asheville, NC
  • Athens, GA
  • Atlanta, GA
  • Atlantic City, NJ
  • Auburn, AL
  • Augusta, GA
  • Austin, TX
  • Bakersfield, CA
  • Baltimore, MD
  • Bangor, ME
  • Barnstable, MA
  • Baton Rouge, LA
  • Beaumont, TX
  • Bellingham, WA
  • Benton Harbor, MI
  • Billings, MT
  • Biloxi, MS
  • Binghamton, NY
  • Birmingham, AL
  • Bismarck, ND
  • Bloomington, IL
  • Bloomington, IN
  • Boise, RI
  • Boise City, ID
  • Boston, MA
  • Brownsville, TX
  • Bryan, TX
  • Buffalo, NY
  • Burlington, VT
  • Canton, OH
  • Casper, WY
  • Cedar Rapids, IA
  • Champaign, IL
  • Charleston, SC
  • Charlotte, NC
  • Charlottesville, VA
  • Chattanooga, TN
  • Cheyenne, WY
  • Chicago, IL
  • Chico, CA
  • Cincinnati, OH
  • Clarksville, TN
  • Clayton, NC
  • Cleveland, OH
  • Colorado Springs, CO
  • Columbia, MO
  • Columbia, SC
  • Columbus, GA
  • Columbus, OH
  • Corpus Christi, TX
  • Corvallis, OR
  • Cumberland, MD
  • Dallas, TX
  • Danville, VA
  • Davenport, IA
  • Dayton, OH
  • Daytona Beach, FL
  • Decatur, AL
  • Decatur, IL
  • Denver, CO
  • Des Moines, IA
  • Detroit, MI
  • Dothan, AL
  • Dover, DE
  • Dubuque, IA
  • Duluth, MN
  • Eau Claire, WI
  • El Paso, TX
  • Elkhart, IN
  • Elmira, NY
  • El Paso, TX
  • Enid, OK
  • Erie, PA
  • Eugene, OR
  • Evansville, IN
  • Fairbanks, AK
  • Fargo, ND
  • Fayetteville, AR
  • Fayetteville, NC
  • Flagstaff, AZ
  • Florence, AL
  • Florence, SC
  • Fort Collins, CO
  • Fort Myers, FL
  • Fort Pierce, FL
  • Fort Smith, AR
  • Fort Walton Beach, FL
  • Fort Wayne, IN
  • Fresno, CA
  • Gadsden, AL
  • Gainesville, FL
  • Galveston, TX
  • Glens Falls, NY
  • Goldsboro, NC
  • Grand Forks, ND
  • Grand Junction, CO
  • Grand Rapids, MI
  • Great Falls, MT
  • Green Bay, WI
  • Greensboro, NC
  • Greenville, NC
  • Greenville, SC
  • Harrisburg, PA
  • Hartford, CT
  • Hattiesburg, MS
  • Hickory, NC
  • Honolulu, HI
  • Houma, LA
  • Houston, TX
  • Huntington, WV
  • Huntsville, AL
  • Indianapolis, IN
  • Iowa City, IA
  • Jackson, MI
  • Jackson, MS
  • Jackson, TN
  • Jacksonville, FL
  • Jamestown, NY
  • Janesville, WI
  • Johnson City, TN
  • Johnstown, PA
  • Jonesboro, AR
  • Joplin, MO
  • Kalamazoo, MI
  • Kansas City, MO
  • Key West, FL
  • Killeen, TX
  • Knoxville, TN
  • Kokomo, IN
  • La Crosse, WI
  • Lafayette, IN
  • Lafayette, LA
  • Lake Charles, LA
  • Lakeland, FL
  • Lancaster, PA
  • Lansing, MI
  • Laredo, TX
  • Las Cruces, NM
  • Las Vegas, NV
  • Lawrence, KS
  • Lawton, OK
  • Lewiston, ME
  • Lexington, KY
  • Lima, OH
  • Lincoln, NE
  • Little Rock, AR
  • Longview, TX
  • Los Angeles, CA
  • Louisville, KY
  • Lubbock, TX
  • Lynchburg, VA
  • Macon, GA
  • Madison, WI
  • Mansfield, OH
  • McAllen, TX
  • Medford, OR
  • Melbourne, FL
  • Memphis, TN
  • Merced, CA
  • Miami, FL
  • Milwaukee, WI
  • Minneapolis, MN
  • Missoula, MT
  • Mobile, AL
  • Modesto, CA
  • Monroe, LA
  • Montgomery, AL
  • Muncie, IN
  • Myrtle Beach, SC
  • Naples, FL
  • Nashville, TN
  • New London, CT
  • New Orleans, LA
  • New York, NY
  • Newark, NJ
  • Norfolk, VA
  • Ocala, FL
  • Odessa, TX
  • Oklahoma City, OK
  • Olympia, WA
  • Omaha, NE
  • Orlando, FL
  • Owensboro, KY
  • Panama City, FL
  • Parkersburg, WV
  • Pensacola, FL
  • Peoria, IL
  • Philadelphia, PA
  • Phoenix, AZ
  • Pine Bluff, AR
  • Pittsburgh, PA
  • Pittsfield, MA
  • Pocatello, ID
  • Portland, ME
  • Providence, RI
  • Provo, UT
  • Pueblo, CO
  • Punta Gorda, FL
  • Raleigh, NC
  • Rapid City, SD
  • Reading, PA
  • Redding, CA
  • Reno, NV
  • Richland, WA
  • Richmond, VA
  • Roanoke, VA
  • Rochester, MN
  • Rockford, IL
  • Rocky Mount, NC
  • Roswell, NM
  • Sacramento, CA
  • Saginaw, MI
  • Salem, OR
  • Salinas, CA
  • Salt Lake City, UT
  • San Angelo, TX
  • San Antonio, TX
  • San Diego, CA
  • San Francisco, CA
  • San Luis Obispo, CA
  • Santa Barbara, CA
  • Santa Fe, NM
  • Sarasota, FL
  • Savannah, GA
  • Scranton, PA
  • Seattle, WA
  • Sharon, PA
  • Sheboygan, WI
  • Sherman, TX
  • Shreveport, LA
  • Sioux City, IA
  • Sioux Falls, SD
  • South Bend, IN
  • Spokane, WA
  • Springfield, IL
  • St. Cloud, MN
  • St. Joseph, MO
  • St. Louis, MO
  • State College, PA
  • Steubenville, OH
  • Stockton, CA
  • Sumter, SC
  • Syracuse, NY
  • Tallahassee, FL
  • Tampa, FL
  • Terre Haute, IN
  • Texarkana, TX
  • Toledo, OH
  • Topeka, KS
  • Tucson, AZ
  • Tulsa, OK
  • Tuscaloosa, AL
  • Tyler, TX
  • Utica, NY
  • Vero Beach, FL
  • Victoria, TX
  • Visalia, CA
  • Waco, TX
  • Washington, DC
  • Waterloo, IA
  • Wausau, WI
  • West Palm Beach, FL
  • Wheeling, WV
  • Wichita, KS
  • Wichita Falls, TX
  • Williamsport, PA
  • Wilmington, NC
  • Yakima, WA
  • York, PA
  • Youngstown, OH
  • Yuba City, CA
  • Yuma, AZ

 

 

 

Copyright © 2001-2010 CBT Planet All rights reserved. - Computer Based Training