LANTEC Logo
Lantec | Course: MS 50448 - Maximizing Pivot Table in Excel 2010-2013

MS 50448 - Maximizing Pivot Table in Excel 2010-2013

$245.00
1 days
Audience
Prerequisites

Description:

This in-depth one-day course introduces ways to create and work with Pivot Tables to look, organize and summarizes, your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. Pivot Table – a great analysis tool!

Course Outline:

Lesson 1: Making Data Work for You

Topic A: Maximize the Power of PivotTable

Topic B: Ask the Questions

Topic C: Get the Answer

Lab 1: Making Data Work for You

Topic A: Maximize the Power of PivotTable

Lesson 2: A Quick Tour

Topic A: Determine What You Need to Know

Topic B: Identify the Source

Topic C: Creating the Pivot Table

Topic D: Working with Pivot Table Layout

Lab 1: Creating the PivotTable

Topic A: Determine the Source Needed for Its PivotTable

Topic B: Create the PivotTable

Topic C: Working with the PivotTable

Lesson 4: Manipulating the PivotTable

Topic A: Rearranging the Layout

Topic B: Adding New Fields

Topic C: Renaming a Field

Topic D: Formatting Numbers

Topic E: Changing Sorting Order

Topic F: Showing Top 10

Topic G: Refreshing Data

Lab 1: Manipulating the PivotTable

Topic A: Rearranging the Layout

Topic B: Adding New Fields

Topic C: Grouping Items

Topic D: Displaying Subtotals

Topic E: Hiding/Showing Grand Totals

Topic F: Formatting PivotTable

Topic G: Using Slicer

Topic H: Formatting Slicer

Lab 2: Digging Deeper

Topic A: Grouping Items

Topic B: Displaying Subtotals

Topic C: Hiding/Showing Grand Totals

Topic D: Formatting PivotTable

Lesson 5: Beyond the Basics

Topic A: Creating a Second Data Field

Topic B: Changing the Summary Function

Topic C: Displaying Numerical Values as a Percentage of the Total

Topic D: Creating a Custom Calculation

Topic E: More Functions in Custom Calculation

Lab 1: Beyond the Basics

Topic A: Create a Second Data Field within the PivotTable

Topic B: Changing Summary Function

Topic C: Displaying Numerical Values as a Percentage of the Total

Topic D: Creating a Custom Calculation

Topic E: More Functions in Custom Calculation

Lesson 6: More PivotTable Calculations

Topic A: Using Formulas

Topic B: Creating a Calculated Field

Topic C: Creating a Calculated Item

Topic D: Using GetPivotData Function

Topic E: Turn off GetPivotData Function

Lab 1: More PivotTable Calculations

Topic A: Use Formulas with the PivotTable

Topic B: Create a calculated field and item

Topic C: Using GetPivotData Function

Topic D: Turn off GetPivotData Function

Lesson 7: Optional Topics

Topic A: Creating PivotChart

Topic B Publishing PivotTable to the Web

Topic C: Using Multiple Source Ranges

Lab 1: Optional Topics

Topic A: Creating PivotChart

Topic B: Publishing PivotTable to the Web

Topic C: Using Multiple Source Ranges to create PivotTable

Lesson 8: Optional Topics

Scheduled Courses

This course isn't currently on the schedule, but we can add it. Just let us know.

Need to Request This Course On a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?


Karson Thompson, Eagle

"Wonderful teacher, helpful with all aspects of this course."