Excel Pivot Tables, Filters and Data Tools

Prerequisites:Students Looking to take this course should have taken an introduction to computers class and Excel Level 1 or the equivelant knowledge.

Sorting Data
 · Sorting Records from Top to Bottom
 · Sorting Field Data from Left to Right
 · Sorting by Four or More Columns
 · Specifying Custom Sort Orders

Using Names
 · Naming Cells
 · Creating Cell Names

Using Filters
 · AutoFilter Feature
 · Specifying Custom Criteria
 · Removing Filters
 · Advanced Filter Feature
 · Setting up a Criteria Range
 · Extracting Data

Using Pivot Tables
 · Creating Pivot Tables
 · Editing Pivot Tables
 · Pivot Table Names and Functions
 · Deleting Pivot Tables
 · Refreshing Pivot Tables
 · Sorting Pivot Tables

Advanced Data Analysis
 · Displaying the Auditing Toolbar
 · Removing Arrows
 · Finding Cells with Specific Content
 · Using the Goal Seek Feature

Automated Features
 · Automatic Subtotals Feature
 · Inserting Automatic Subtotals
 · Record Detail
 · Using Conditional Formatting

Protecting Worksheet Data
 · Cell Notes
 · Creating Cell Notes
 · Displaying and Hiding Cell Notes
 · Worksheet Protection
 · Password Protection

Manipulating the Screen
 · Working with Multiple Workbooks
 · Displaying Multiple Workbooks
 · Freezing Worksheet Titles
 · Working with Toolbars
 · Displaying and Hiding Toolbars

Sharing Worksheet Data
 · Importing Data
 · Exporting Data
 · Linking Workbooks
 · Creating Links
 · Updating Links

Automating Your Work
 · Working with Templates
 · Customizing Templates
 · Creating Templates
 · Working with Macros
 · Recording Macros
 · Executing Macros

Drawing Tools
 · Inserting Graphics
 · Circle Data
 · Flow Charts
 · Hyperlink Buttons



Close this Window

SiliconBay Training
4847 Hopyard Rd Suite #4165
Pleasanton, CA 94588
Phone: (925) 462-3277