Excel 2010 Advanced Courseware

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.

 

Rate this post