Excel 2003: Level 3 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 3  

 Email information about this seminar Excel 2003: Level 3 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Excel 2003: Level 3 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 desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. (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 3 seminar

 

 

Training Course Syllabus:


Description
In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Audience
·  This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data.
·  In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003.

Objectives
·  Customize workbooks.
·  Collaborate with others using workbooks.
·  Audit worksheets.
·  Analyze data.
·  Work with multiple workbooks.
·  Import and export data.
·  Structure workbooks with XML.

Required Prerequisites
 ·  Excel 2003: Level 2

Exams
 ·  Excel 2003 Expert : Microsoft Excel 2003 Expert

Outline
    1. Streamlining Workflow
      1. Create a Macro
      2. Edit a Macro
      3. Customize Access to Excel Commands
      4. Apply Conditional Formatting
      5. Add Data Validation Criteria
      6. Update a Workbook's Properties
      7. Modify Excel's Default Settings
    2. Collaborating with Others
      1. Protect Files
      2. Share a Workbook
      3. Set Revision Tracking
      4. Review Tracked Revisions
      5. Merge Workbooks
      6. Adjust Macro Settings
      7. Administer Digital Signatures
    3. Auditing Worksheets
      1. Trace Cell Precedents
      2. Trace Cell Dependents
      3. Locate Errors in Formulas
      4. Locate Invalid Data and Formulas
      5. Watch and Evaluate Formulas
      6. Group and Outline Data
    4. Analyzing Data
      1. Create a Trendline
      2. Create Scenarios
      3. Perform What-If Analysis
      4. Develop a PivotTable© Report
      5. Develop a PivotChart© Report
      6. Perform Statistical Analysis with the Analysis ToolPak
    5. Working with Multiple Workbooks
      1. Create a Workspace
      2. Consolidate Data
      3. Link Cells in Different Workbooks
      4. Edit Links
    6. Importing and Exporting Data
      1. Export to Microsoft Word
      2. Import a Word Table
      3. Import Text Files
    7. Structuring XML Workbooks
      1. Develop XML Maps
      2. Import, Add, and Export XML Data
      3. Manage XML Workbooks
      4. Apply XML View Options

    Seminar Summary:

    In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. (see full course description)

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

     view dates and locations for this seminar

     

     

     

    Custom Search