Pivots, Subtotals and Data Analysis in Excel 2007

pivots, subtotals and data analysis in excel 2007

Course DescriptionThis half-day course covers some of Excel's advanced feature functionality in regards to Pivots, Subtotals and Data Analysis.

Course Length: 4 Hours

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 PivotsLesson 1 - Working with Data Analysis· What If Analysis?· Scenarios· Merge Scenarios· Goal SeekLesson 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 locationsLesson 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

Pivots, Subtotals and Data Analysis 175.00