Microsoft Excel 2013 Advanced Training Course

12/11/2016

Microsoft Excel 2013 Advanced Training Course – Overview

This Microsoft Excel 2013 Advanced Training Course will help you gain the skills necessary to use pivot tables, audit and analyse worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Target Audience: Students who have intermediate skills with Microsoft Excel who want to learn more advanced skills or students who want to learn the topics covered in this course in the new interface.

Microsoft Excel Advanced – ObjectivesMicrosoft Excel

  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.

Class Outline

  • Using Pivot Tables
    • Creating Pivot Tables
      • Preparing Your Data
      • Inserting a Pivot Table
    • Working with Pivot Tables
      • Grouping Data
      • Ungrouping Data
    • Inserting Slicers
    • Inserting Pivot Charts
    • More Pivot Table Functionality
  • Auditing Worksheets
    • Tracing Precedents
    • Tracing Dependents
    • Showing Formulas
  • Data Tools
    • Converting Text to Columns
    • Linking to External Data
    • Controlling Calculation Options
    • Data Validation
    • Consolidating Data
    • Goal Seek
  • Working with Others
    • Protecting Worksheets and Workbooks
      • Password Protecting a Workbook
      • Removing Workbook Metadata
      • Password Protecting a Worksheet
      • Password Protecting Ranges in a Worksheet
    • Tracking Changes
      • Accepting or Rejecting Changes
      • Setting Tracking Options
      • Merging Multiple Workbooks
    • Marking a Workbook as Final
  • Recording and Using Macros
    • Recording Macros
      • Copy a Macro from Workbook to Workbook
    • Running Macros
    • Editing Macros
    • Adding Macros to the Quick Access Toolbar
      • Managing Macro Security
  • Useful Additional Topics
    • Sparklines
      • Inserting Sparklines
      • Customizing Sparklines
  • Importing and Exporting Files
    • Importing Text Files
    • Exporting Worksheet Data to Microsoft Word
    • Exporting Excel Charts to Microsoft Word
  • Microsoft Excel Features that are new in 2013
    • Using Slicers to Filter Data
    • Creating a PivotTable Timeline
    • Creating a Standalone PivotChart
    • Workspaces in Excel 2013

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh