Skip Main Navigation
Page Content
This event has ended

Pivots, Subtotals and Data Analysis in Excel 2010

ThinkData Solutions, Inc

Wednesday, July 11, 2012 from 9:00 AM to 12:00 PM (CDT)

Birmingham, AL

Pivots, Subtotals and Data Analysis in Excel 2010

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Pivots, Subtotals and Data Analysis in Excel 2010 7 Tickets Ended $175.00 $0.00

Share Pivots, Subtotals and Data Analysis in Excel 2010

Event Details

Pivots, subtotals and data analysis in excel 2010

 

Course Description

This course covers some of Excel's advance feature functionality in regards to Pivots, Subtotals and Data Analysis.



COURSE OBJECTIVES

Upon completion of this course, the student will be able to:

·        Perform basic data analysis

·        Sort and filter data.

·        Subtotal Data

·        Work with Pivots

Lesson 1 – Working with Data Analysis

·        What If Analysis?

·        Scenarios

·        Merge Scenarios

·        Goal Seek

Lesson 2 – Sort and Filter Data

·        Sort Data

·        Filter Data

·        Advanced Filters

·        Clear Filters      

Lesson 3 – Subtotal Data

·        Subtotal Data

·        Expand and Collapse Subtotals

·        Move Subtotals to other locations

Lesson 4 – Pivot Data

·        Create a Pivot Table

·        Format Pivots

·        Drill Down on Pivot Data

·        Add a Calculated Field to a Pivot

·        Create a Pivot Chart

·        Linking data from Pivot Table to Worksheet

·        Refresh Pivots

·        Add Running Totals

·        Difference From Calculations    

 

 

Have questions about Pivots, Subtotals and Data Analysis in Excel 2010? Contact ThinkData Solutions, Inc

When & Where


ThinkData Lab
1500 1st Ave N
Ste L142
Birmingham, AL 35203

Wednesday, July 11, 2012 from 9:00 AM to 12:00 PM (CDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.