Microsoft Excel 2013 Advanced Training Materials

Training Course Outline

Download sample courseware

Excel 2013 pivot tables

  • Creating and using a pivot table
  • Filtering and sorting data within a pivot table
  • Automatically grouping data in a pivot table and renaming groups
  • Manually grouping data in a pivot table and renaming groups

Excel 2013 input tables

  • One-input data tables
  • Two-input data tables

Excel 2013 charts

  • Creating a combo line and column chart
  • Changing the chart type for a particular data series
  • Adding a data series to a chart
  • Removing a data series from a chart
  • Re-positioning chart title
  • Re-positioning the chart legend
  • Moving and formatting chart data labels
  • Modifying chart axis scales
  • Formatting an axis to display using commas
  • Inserting images into chart columns
  • Formatting the chart plot area using a picture
  • Formatting the chart area using a picture

Excel 2013 and hyperlinks

  • Inserting a hyperlink
  • Editing a hyperlink
  • Removing a hyperlink

Linking & embedding within Excel 2013

  • What is embedding and linking?
  • 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 into Excel 2013

  • What is a delimited text file?
  • Importing a delimited text file

Sorting, filtering & totalling data within Excel 2013

  • Sorting data by multiple columns at the same time
  • Applying a pre-installed custom sort
  • Creating a customized list and performing a custom sort
  • Deleting an Excel customised list
  • Using AutoFilter
  • Using AutoFilter to perform multiple queries
  • Top 10 AutoFilter
  • Removing all AutoFilters from a worksheet
  • Advanced filter criteria
  • Sub-totalling
  • Removing subtotals
  • Expanding and collapsing outline detail levels

Tracking and reviewing changes in Excel 2013

  • Enabling or disabling the ‘track changes’ feature
  • Sharing, comparing and merging worksheets

Excel 2013 scenarios

  • Scenario manager
  • Scenario summary reports

Validating within Excel 2013

  • Data validation – whole number
  • Data validation – decimal number
  • Data validation – list
  • Data validation – date
  • Data validation – time
  • Data validation – text length
  • Customising a validation input message and error alert
  • Removing data validation

Auditing techniques in Excel 2013

  • Tracing precedent cells
  • Tracing dependent cells
  • Identifying cells with missing dependents
  • Showing all formulas in a worksheet, rather than the resulting values
  • Inserting and viewing comments
  • Editing comments
  • Deleting comments
  • Showing and hiding comments

Macros within Excel 2013

  • Recording an Excel macro

Excel 2013 passwords & security issues

  • Adding ‘open’ password protection to a workbook
  • Adding ‘modify’ password protection to a workbook
  • Removing an ‘open’ password from a workbook
  • Removing a ‘modify’ password from a workbook
  • Password protecting cells and worksheets
  • Hiding formulas
  • Un-hiding formulas

Download sample courseware

Available separately, as part of our Microsoft Office 2013 courseware bundle, or as part of the full IT Courseware library

 

Microsoft Excel 2013 Advanced Training Materials
4.67 (93.33%) 3 votes