MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Distance Learning Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us


Microsoft Office Excel 2003 Intermediate Training

Excel 2003 - Level 2

Course Length: 1 days

Class Schedule
Call for Class Schedule

In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and apply templates.
  • create and modify charts.
  • work with graphic objects.
  • calculate with advanced formulas.
  • sort and filter data.
  • use Excel with the Web.

Course Content

Lesson 1: 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
Lesson 2: Creating and Modifying Charts
  • Create a Chart
  • Format Chart Items
  • Change the Chart Type
  • Create a Diagram
Lesson 3: 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
Lesson 4: 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
Lesson 5: Sorting and Filtering Data
  • Sort Data Lists
  • Filter Data Lists
  • Create and Apply Advanced Filters
  • Calculate with Database Functions
  • Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
  • Export Excel Data
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

MCSEClasses.com is your best choice for Microsoft Excel, Microsoft Excel training, Microsoft Excel certification, Microsoft Excel certification boot camp, Microsoft Excel boot camp, Microsoft Excel certification training, Microsoft Excel boot camp training, Microsoft Excel boot camp certification, Microsoft Excel certification course, Microsoft Excel course, training Microsoft Excel, certification Microsoft Excel, boot camp Microsoft Excel, certification Microsoft Excel boot camp, certification Microsoft Excel training, boot camp Microsoft Excel training, certification Microsoft Excel course.



mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us





Search classes by keyword:
Search classes by category:
mcse training
MCSE boot camp MCSE Training MCSE Certification MCSE Bootcamp MCSE Boot Camp MCSE Course MCSE Training MCSE Certification MCSE Bootcamp MCSE Boot Camp MCSE MCSA Training MCSA Certification MCSA Bootcamp MCSA Boot Camp MCSA Course MCSA Training MCSA Certification MCSA Bootcamp MCSA Boot Camp MCSA Course MCSA MCSE 2003 MCSE Training 2003 MCSE Certification 2003 MCSE Boot Camp 2003 MCSE Course 2003 MCSE 2003 Training MCSE 2003 Certification MCSE 2003 Boot Camp MCSE 2003 Course Training MCSE 2003 Certification MCSE 2003 Boot Camp MCSE 2003 Course MCSE 2003 MCSE Training Course MCSE Training Boot Camp MCSE training
MCSE certification MCSE Training Certification
Training MCSE Certification Training MCSE Boot Camp Training MCSE Course MCSE Certification Training MCSE Certification Boot Camp MCSE Certification Course MCSE Boot Camp Training MCSE Boot Camp Course MCSE Course Training MCSE Course Certification MCSD MCSD Training MCSD Certification MCSD Course Certification Training Training Certification Microsoft Certification Certification Microsoft Microsoft Training

Copyright © 2012 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.

MCSE certification boot camps and courses are offered in these select cities: Albany MCSE, Albuquerque MCSE, Alexandria MCSE, Anchorage MCSE, Atlanta MCSE, Austin MCSE, Billings MCSE, Birmingham MCSE, Bismarck MCSE, Boise MCSE, Boston MCSE, Charleston MCSE, Charlotte MCSE, Cheyenne MCSE, Chicago MCSE, Cincinnati MCSE, Cleveland MCSE, Columbia MCSE, Columbus MCSE, Dallas MCSE, Denver MCSE, Des Moines MCSE, Detroit MCSE, Hartford MCSE, Honolulu MCSE, Houston MCSE, Indianapolis MCSE, Jackson MCSE, Kansas City MCSE, Las Cruces MCSE, Lincoln MCSE, Little Rock MCSE, Los Angeles MCSE, Louisville MCSE, Madison MCSE, Milwaukee MCSE, Minneapolis MCSE, Montpelier MCSE, New Orleans MCSE, New York City MCSE, Norfolk MCSE, Oklahoma City MCSE, Omaha MCSE, Philadelphia MCSE, Phoenix MCSE, Pierre MCSE, Pittsburgh MCSE, Portland MCSE, Princeton MCSE, Providence MCSE, Raleigh MCSE, Richmond MCSE, Sacramento MCSE, Salt Lake City MCSE, San Antonio MCSE, San Diego MCSE, San Francisco MCSE, San Jose MCSE, Seattle MCSE, Stamford MCSE, Tulsa MCSE, Washington MCSE, Wilmington MCSE.

MCSE Canada Boot Camps : mcse Calgary, mcse Edmonton, mcse Halifax, mcse Hamilton, mcse Kitchener, mcse London, mcse Montreal, mcse Ottawa, mcse Quebec City, mcse Toronto, mcse Vancouver, mcse Winnipeg.

CED Solutions offers MCSE certification boot camps and courses in the United States: MCSE Alabama, MCSE Alaska, MCSE Arizona, MCSE Arkansas, MCSE California, MCSE Colorado, MCSE Connecticut, MCSE District of Columbia, MCSE Delaware, MCSE Georgia, MCSE Hawaii, MCSE Idaho, MCSE Illinois, MCSE Indiana, MCSE Iowa, MCSE Kansas, MCSE Kentucky, MCSE Louisiana, MCSE Maine, MCSE Massachusetts, MCSE Michigan, MCSE Minnesota, MCSE Mississippi, MCSE Missouri, MCSE Montana, MCSE Nebraska, MCSE New Jersey, MCSE New Mexico, MCSE New York, MCSE North Carolina, MCSE North Dakota, MCSE Ohio, MCSE Oklahoma, MCSE Oregon, MCSE Pennsylvania, MCSE Rhode Island, MCSE South Carolina, MCSE South Dakota, MCSE Texas, MCSE Utah, MCSE Vermont, MCSE Virginia, MCSE Washington, MCSE West Virginia, MCSE Wisconsin, MCSE Wyoming.

MCSE Canada Boot Camps : Alberta mcse, British Columbia mcse, Manitoba mcse, New Brunswick mcse, Newfoundland mcse, Nova Scotia mcse, Ontario mcse, Saskatchewan mcse. Quebec mcse.