- Windows XP Professional: Level 1
- Windows XP: Introduction

- A 1 GHz Pentium-class processor or faster.
- A minimum of 1 GB of RAM is recommended.
- 20 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for Office 2010 installation.
- A DVD-ROM drive.
- A keyboard and mouse or other pointing device.
- A 1024 x 768 resolution SVGA monitor is recommended.
- Network cards and cabling for local network access.
- Internet access (check with your local network administrator).
- A printer (optional) or an installed printer driver.
- A projection system to display the instructor’s computer screen.

Each computer requires the following software:

- Microsoft® Office Professional Plus 2010 Edition.
- Microsoft® Windows® XP Professional with Service Pack 3.

- create a basic worksheet by using Microsoft Excel 2010.
- perform calculations in an Excel worksheet.
- modify an Excel worksheet.
- modify the appearance of data within a worksheet.
- manage Excel workbooks.
- print the content of an Excel worksheet.
- use advanced formulas.
- organize worksheet and table data using various techniques.
- create and modify charts.
- analyze data using PivotTables, Slicers, and PivotCharts.
- insert and modify graphic objects in a worksheet.
- customize and enhance workbooks and the Microsoft Office Excel environment.
- enhance productivity and efficiency by streamlining the workflow.
- collaborate with other workbook users.
- audit worksheets.
- analyze data.
- work with multiple workbooks.
- import and export data.
- manipulate data using statistical and lookup functions.
- analyze data using the data analysis tools in Microsoft Excel 2010.
- make investment decisions using the financial functions in Excel 2010.
- examine data using math functions in Excel 2010.

- Lesson 1: Getting Started with Excel
**Topic 1A:**Identify the Elements of the Excel Interface**Topic 1B:**Navigate and Select Cells in Worksheets**Topic 1C:**Customize the Excel Interface**Topic 1D:**Create a Basic Worksheet

- Lesson 2: Performing Calculations in an Excel Worksheet
**Topic 2A:**Create Formulas in a Worksheet**Topic 2B:**Insert Functions in a Worksheet**Topic 2C:**Reuse Formulas

- Lesson 3: Modifying an Excel Worksheet
**Topic 3A:**Edit Worksheet Data**Topic 3B:**Find and Replace Data**Topic 3C:**Manipulate Worksheet Elements

- Lesson 4: Modifying the Appearance of a Worksheet
**Topic 4A:**Apply Font Properties**Topic 4B:**Align Content in a Cell**Topic 4C:**Apply Number Formatting**Topic 4D:**Apply Cell Styles

- Lesson 5: Managing an Excel Workbook
**Topic 5A:**Manage Worksheets**Topic 5B:**View Worksheets and Workbooks

- Lesson 6: Printing Excel Workbooks
**Topic 6A:**Define the Page Layout**Topic 6B:**Print a Workbook

- Lesson 7: Calculating Data with Advanced Formulas
**Topic 7A:**Apply Cell and Range Names**Topic 7B:**Analyze Data with Logical and Lookup Functions

- Lesson 8: Organizing Worksheet and Table Data
**Topic 8A:**Create and Modify Tables**Topic 8B:**Sort or Filter Data

- Lesson 9: Presenting Data Using Charts
**Topic 9A:**Create a Chart**Topic 9B:**Create Advanced Charts

- Lesson 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts
**Topic 10A:**Create a PivotTable Report**Topic 10B:**Filter Data Using Slicers**Topic 10C:**Analyze Data Using PivotCharts

- Lesson 11: Inserting Graphic Objects
**Topic 11A:**Insert and Modify Pictures and ClipArt**Topic 11B:**Draw and Modify Shapes**Topic 11C:**Illustrate Workflow Using SmartArt Graphics

- Lesson 12: Customizing and Enhancing the Excel Environment
**Topic 12A:**Customize the Excel Environment**Topic 12B:**Customize Workbooks**Topic 12C:**Create and Use Templates

- Lesson 13: Streamlining Workflow
**Topic 13A:**Update Workbook Properties**Topic 13B:**Create a Macro**Topic 13C:**Edit a Macro**Topic 13D:**Apply Conditional Formatting**Topic 13E:**Add Data Validation Criteria

- Lesson 14: Collaborating with Other Users
**Topic 14A:**Protect Files**Topic 14B:**Share a Workbook**Topic 14C:**Set Revision Tracking**Topic 14D:**Review Tracked Revisions**Topic 14E:**Merge Workbooks**Topic 14F:**Restrict Document Access

- Lesson 15: Auditing Worksheets
**Topic 15A:**Trace Cells**Topic 15B:**Troubleshoot Invalid Data and Formula Errors**Topic 15C:**Watch and Evaluate Formulas**Topic 15D:**Create a Data List Outline

- Lesson 16: Analyzing Data
**Topic 16A:**Create a Trendline**Topic 16B:**Create Sparklines**Topic 16C:**Create Scenarios**Topic 16D:**Perform a What-If Analysis**Topic 16E:**Perform a Statistical Analysis with the Analysis ToolPak

- Lesson 17: Working with Multiple Workbooks
**Topic 17A:**Create a Workspace**Topic 17B:**Consolidate Data

- Lesson 18: Importing and Exporting Data
**Topic 18A:**Export Excel Data**Topic 18B:**Import a Delimited Text File**Topic 18C:**Import and Export XML Data

- Lesson 19: Manipulating Data Using Functions
**Topic 19A:**Forecast GDP Using Statistical Functions**Topic 19B:**Manipulate Data Using Text Functions**Topic 19C:**Validate Data Using Information Functions

- Lesson 20: Analyzing Data Using Data Analysis Tools
**Topic 20A:**Analyze Sales Data Using Descriptive Statistics**Topic 20B:**Analyze Time Series Data Using Exponential Smoothing**Topic 20C:**Analyze Data Using Regression**Topic 20D:**Analyze Sector Data Using Correlation and Covariance Matrices**Topic 20E:**Optimize a Stock Portfolio Using Solver

- Lesson 21: Working with Data Using Financial Functions
**Topic 21A:**Develop an Investment Schedule Using Financial Functions**Topic 21B:**Make Investment Decisions Using Financial Functions

- Lesson 22: Examining Data Using Math Functions
**Topic 22A:**Analyze Sales Data Using Math Functions**Topic 22B:**Calculate Stock Returns Using Math Functions**Topic 22C:**Aggregate GDP Data Using Math Functions