MS Excel 2002 Utilisation avancée


Présentation/Description
Public ciblé
Durée prévue
Objectifs du cours
Numéro du cours

Présentation/Description
This course covers skills particular to the expert user of Excel 2002. The course teaches template and database integration. The section on Workbook Capabilities deals with shared workbooks and with consolidating data across workbooks. The final section, Data Analysis and Automation, covers data importing and querying, pivot tables, macros, and data analysis tools.

Public ciblé
Ce cours s'adresse aux utilisateurs finaux et aux utilisateurs avertis, qui peuvent connaŒtre ou non les versions pr‚c‚dentes de Microsoft Excel. Ces personnes doivent r‚aliser des tƒches d'administration ou de gestion, et travailler avec des donn‚es relatives … la comptabilit‚ ou aux finances. Ce cours sera utile aux utilisateurs finaux, au personnel du centre d'assistance ou charg‚ du support, ainsi qu'aux concepteurs r‚seau.

Durée prévue (hours)
8.0

Objectifs du cours

MS Excel 2002 Utilisation avancée

  • Create a new template file.
  • Modify an existing template file.
  • Create a new workbook by using a user-defined template.
  • Open a spreadsheet solutions template.
  • Enter data in a list by using the data form.
  • Sort a row in a list by using multiple columns.
  • Sort a column in a list by using multiple rows.
  • Create a custom sort order.
  • Apply a custom filter to a list.
  • Summarize data in a list by using subtotals.
  • Create a shared workbook.
  • Highlight changes in a shared workbook.
  • Accept a change in a shared workbook.
  • Merge multiple workbooks.
  • Create a workspace file.
  • Import a delimited text file.
  • Import data from a fixed-width text file.
  • Import data from a database.
  • Create an Extensible Markup Language (XML) query.
  • Identify the features of the real-time data (RTD) function.
  • Export data in text file format.
  • Save a workbook in Extensible Markup Language (XML) spreadsheet format.
  • Create a PivotTable.
  • Identify different formats to apply to a PivotTable report.
  • Change the summary functions in a PivotTable.
  • Hide data in a PivotTable.
  • Manipulate a field in a PivotTable.
  • Identify features of a PivotChart.
  • Record a macro.
  • Run a macro.
  • Edit a macro.
  • Assign a macro to a Custom Button.
  • Create a scenario.
  • View a scenario.
  • Create a scenario report.
  • Forecast using the Goal Seek command.
  • Generate the optimal solution under set constraints by using Solver.

    • Numéro du cours:
    fr_FR_74032_ng