Office 2010 Training Manuals – Excel Word 2010 Advanced Courseware

Office 365 training materials from the Cheltenham Group
Free Samples

Microsoft Excel 2010 Advanced Training Course Teaching Materials

Computer Courseware Training Materials

Training Course Outline

Excel 2010 Pivot Tables

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

Input Tables

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

Excel 2010 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 in Excel 2010

  • 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 in Excel 2010.
  • Tracing Dependent Cells.
  • Identifying Cells With Missing Dependents.
  • Showing All Formulas In a Worksheet.
  • Comments.

Macros

  • Using Excel 2010 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 within Excel 2010
Excel 2010 Advanced Courseware
3.4 (68%) 5 votes