Excel 2010 Training Advanced

Title Banner
Expand All | Collapse All

Chapters	Courseware	Online Learning	Skills Assessments

10. Working with PivotTables

Creating a PivotTable	Demo	Demo	Demo
Specifying PivotTable Data	-	-	-
Changing a PivotTable’s Calculation	-	-	-
Filtering and Sorting a PivotTable	-	-	-
Working with PivotTable Layout	-	-	-
Grouping PivotTable Items	-	-	-
Updating a PivotTable	-	-	-
Formatting a PivotTable	-	-	-
Creating a PivotChart	-	-	-
Using Slicers	-	-	-
Sharing Slicers Between PivotTables	-	-	-

11. Analyzing Data

Creating Scenarios	Demo	Demo	Demo
Creating a Scenario Report	-	-	-
Working with Data Tables	-	-	-
Using Goal Seek	-	-	-
Using Solver	-	-	-
Using Text to Columns	-	-	-
Grouping and Outlining Data	-	-	-
Using Subtotals	-	-	-
Consolidating Data by Position or Category	-	-	-
Consolidating Data Using Formulas	-	-	-

12. Working with the Web and External Data

Inserting a Hyperlink	Demo	Demo	Demo
Importing Data from Access or Text Files	-	-	-
Importing Data from the Web or Other Sources	-	-	-
Working with Existing Data Connections	-	-	-

13. Working with Macros

Recording a Macro	Demo	Demo	Demo
Playing and Deleting a Macro	-	-	-
Adding a Macro to the Quick Access Toolbar	-	-	-
Editing a Macro’s Visual Basic Code	-	-	-
Inserting Copied Code in a Macro	-	-	-
Declaring Variables and Adding Remarks to VBA Code	-	-	-
Prompting for User Input	-	-	-
Using the If…Then…Else Statement	-	-	-

14. Customizing Excel

Customizing the Ribbon	Demo	Demo	Demo
Customizing the Quick Access Toolbar	-	-	-
Using and Customizing AutoCorrect	-	-	-
Changing Excel’s Default Options	-	-	-
Creating a Custom AutoFill List	-	-	-
Creating a Custom Number Format	-	-	-

Popular Courses

FREE QUICK REFERENCES

Sign up to download Quick References for your favorite software programs - 100% spam free.

Copyright © 2010 CustomGuide Inc. - All rights reserved.