Advanced Microsoft Excel 2013

#text-block-10 { margin-bottom:0px; text-align:left; }

Using Pivot Tables

Creating Pivot Tables

Preparing Your Data

Inserting a Pivot Table

Inserting Slicers

Working with Pivot Tables

Grouping Data

Using PowerPivot

Managing Relationships

Inserting Pivot Charts

More Pivot Table Functionality

Exercise: Working with Pivot Tables

Auditing Worksheets

Tracing Precedents

Exercise: Tracing Precedents

Tracing Dependents

Exercise: Tracing Dependents

Showing Formulas

Data Tools

Converting Text to Columns

Exercise: Converting Text to Columns

Linking to External Data

Controlling Calculation Options

Data Validation

Exercise: Using Data Validation

Consolidating Data

Exercise: Consolidating Data

Goal Seek

Exercise: Using Goal Seek

Working with Others

Protecting Worksheets and Workbooks

Password Protecting a Workbook

Removing Workbook Metadata

Exercise: Password Protecting a Workbook

Password Protecting a Worksheet

Exercise: Password Protecting a Worksheet

Password Protecting Ranges in a Worksheet

Exercise: Password Protecting Ranges in a Worksheet

Tracking Changes

Accepting or Rejecting Changes

Setting Tracking Options

Merging Multiple Workbooks

Marking a Workbook as Final

Exercise: Tracking Changes

#text-block-11 { margin-bottom:0px; text-align:left; }

Recording and Using Macros

Recording Macros

Copy a Macro from Workbook to Workbook

Exercise: Recording a Macro

Running Macros

Editing Macros

Adding Macros to the Quick Access Toolbar

Managing Macro Security

Exercise: Adding a Macro to the Quick Access Toolbar

Random Useful Items

Sparklines

Inserting Sparklines

Customizing Sparklines

Exercise: Inserting and Customizing Sparklines

Preparing a Workbook for Internationalization and Accessibility

Display Data in Multiple International Formats

Modify Worksheets for Use with Accessibility Tools

Use International Symbols

Manage Multiple Options for +Body and +Heading Fonts

Importing and Exporting Files

Importing Text Files

Exercise: Importing Text Files

Exporting Worksheet Data to Microsoft Word

Exercise: Copying Data from Excel to Word

Exporting Excel Charts to Microsoft Word

Exercise: Copying Charts from Excel to Word

Microsoft Excel 2013 New Features

Using Slicers to Filter Data

Exercise: Filtering Data with Slicers

Creating a PivotTable Timeline

Exercise: Creating a Timeline

Creating a Standalone PivotChart

Workspaces in Excel 2013