Excel: Pivot Tables, HLookUp & VLookUp

Excel: Pivot Tables, HLookUp & VLookUp
Print Friendly, PDF & Email

VLOOKUP and PivotTables in Excel
(3 hours)

The ability to successfully use the VLookup function and create a PivotTable are two skills employers use to measure the strength of a candidate’s Excel skills. This three-hour, hands-on exploration of VLookups (and HLookups) and PivotTables will develop your confidence level with both these extremely powerful tools

Course Objectives

Upon successful completion of this course, students will be able to:
build a PivotTable.
analyze data using PivotTables.
present PivotTable data visually.

Course Content

Lesson 1: Building a PivotTable

Topic 1A: Insert a PivotTable
Topic 1B: Create a PivotTable Based on External Data
Topic 1C: Categorize PivotTable Data
Topic 1D: Customize a PivotTable
Lesson 2: Analyzing Data Using PivotTables

Topic 2A: Create Custom Calculations in a PivotTable
Topic 2B: Restructure a PivotTable
Lesson 3: Presenting PivotTable Data Visually

Topic 3A: Format a PivotTable
Topic 3B: Present a PivotTable in a PivotChart
Topic 3C: Print PivotTables and PivotCharts
Appendix A: Solvers
Appendix B: Goal Seek
Appendix C: Troubleshooting PivotTables
Pivot Tables, HLook Up, VLookUP

Share Post
Share This

About the author

Computer trainer, tech support, webmaster, book keeper and janitor all rolled into one.

View all articles by Admin

1 comment

Comments are closed.