Courses  

Excel 2003: Advanced Data Analysis in Excel 2003


Course ID: SS_113309_eng
Price: $40.00
Format: Self Paced
Course Provider: SkillSoft
Audience:
Course Length: 3.0
CE Units: N/A
Contact Hours: N/A
Contact: courses@webjunction.org


Description:

In the Advanced Data Analysis in Excel 2003 course, you will learn to:

  • create and modify PivotTable reports in Excel 2003.
  • perform calculations on PivotTable reports in Excel 2003.
  • create and modify a PivotTable report in Excel 2003.
  • create and modify PivotChart reports in Excel 2003.
  • create and edit a PivotChart report in Excel 2003.
  • use the Goal Seek and Solver tools in Excel 2003.
  • employ scenarios to analyze data in Excel 2003.
  • create data tables and outline their uses in Excel 2003.
  • use data-analysis tools in Excel 2003 to forecast values in a workbook.

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent.

Duration

3 Hours

Prerequisites

Familiarity with the Windows 2000 or XP user environments



Competencies
Member Comments