Microsoft Excel 2010 Advanced Training Materials

Courseware Training Materials

Training Course Outline

Pivot Tables

• Using a Pivot Table.
• Filtering and Sorting Data
• Grouping Data

Input Tables

• One-Input Data Tables.
• Two-Input Data Tables.

Charts

• Combined Line and Column Chart.
• Adding a Secondary Axis.
• Changing the Chart Type For a Data Series.
• Adding a Data Series to a Chart.
• Removing a Data Series from a Chart.
• Modifying the Chart Title, Legend & Data Labels.
• Chart Axis Scales.
• Inserting Images Into Chart Columns.
• Formatting the Chart Area

Hyperlinks

• Inserting a Hyperlink.
• Editing a Hyperlink
• Removing a Hyperlink

Linking & Embedding

• Linking Data within a Worksheet.
• Linking Cells between Worksheets within a Workbook.
• Linking Data between Workbooks.
• Linking Data from Excel to a Word Document.
• Linking an Excel Chart to a Word Document.
• Updating, Locking and Breaking Links.

Importing Text Files

• Importing a Delimited Text File.

Sorting and Filtering Data

• Sorting Data by Multiple Columns
• Custom Sorts
• Customized List
• AutoFilter.
• Top 10 AutoFilter.
• Advanced Filter Criteria.
• Sub-Totalling.
• Removing Subtotals.
• Expanding and Collapsing Outline Detail.

Tracking and Reviewing Changes

• Enabling or Disabling ‘Track Changes’.
• Sharing, Comparing and Merging Worksheets.

Scenarios

• Scenario Manager.
• Scenario Summary Reports.

Validating

• Whole Number.
• Decimal Number.
• List.
• Date.
• Time.
• Text Length.
• Validation Input Message and Error Alert.
• Removing Data Validation.

Auditing

• Tracing Precedent Cells.
• Tracing Dependent Cells.
• Identifying Cells With Missing Dependents.
• Showing All Formulas In a Worksheet.
• Comments

Macros

• Using Macros
• Assigning a Macro to a Button on the Quick Access Toolbar.
• Deleting Macros.

Passwords & Security Issues

• Password Protection.
• Password Protecting Cells and Worksheets.
• Hiding Formulas.
• Un-Hiding Formulas.