Excel 2003: Level 2 training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Excel 2003: Level 2  

 Email information about this seminar Excel 2003: Level 2 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Excel 2003: Level 2 by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is designed for 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.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

In this course, students will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

excel+microsoft+spreadsheet training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Excel 2003: Level 2 seminar

 

 

Training Course Syllabus:


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

Audience
·  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 2003.

Benefits
·  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.

Required Prerequisites
 ·  Excel 2003: Level 1

Exams
 ·  Excel 2003 : Microsoft Excel 2003
 ·  Excel 2003 Expert : Microsoft Excel 2003 Expert

Next Steps
 · Excel 2003: Level 3

Outline
    1. Creating and Applying Templates
      1. Create a Workbook from a Template
      2. Create a Custom Template
      3. Working with Comments
      4. Create a Hyperlink
      5. Use Web-based Research Tools
    2. Creating and Modifying Charts
      1. Create a Chart
      2. Format Chart Items
      3. Change the Chart Type
      4. Create a Diagram
    3. Working with Graphic Objects
      1. Insert Graphics
      2. Create AutoShapes
      3. Format Graphic Objects
      4. Change the Order of Graphic Objects
      5. Group Graphic Objects
      6. Move, Copy, and Resize Graphic Objects
    4. Calculating with Advanced Formulas
      1. Create and Apply a Name for a Range of Cells
      2. Calculate Across Worksheets
      3. Calculate with Date and Time Functions
      4. Calculate with Financial Functions
      5. Calculate with Statistical Functions
      6. Calculate with Lookup and Reference Functions
      7. Calculate with Logical Functions
    5. Sorting and Filtering Data
      1. Sort Data Lists
      2. Filter Data Lists
      3. Create and Apply Advanced Filters
      4. Calculate with Database Functions
      5. Add Subtotals to a Worksheet
    6. Using Excel with the Web
      1. Export Excel Data
      2. Publish a Worksheet to the Web
      3. Import Data from the Web
      4. Create a Web Query

    Seminar Summary:

    In this course, students will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. (see full course description)

    print this agenda print agenda for the Excel 2003: Level 2 training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search