Excel Pivot Tables & Filtering

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This ½ day workshop provides an understanding about the value of the Pivot Tables and AutoFilter features within Excel.



PivotTables are a great data analysis tool for management. They allow you to create multi dimensional data views by dragging and dropping column headings to move data around.



Microsoft Excel also provides a very simple mechanism (AutoFilter) for filtering/selecting data subsets. AutoFilters can be set up to choose specific values or a range of values. Several filters can be used, each acting further on the current data subset

Course Content
Using AutoFilter

· Using AutoFilter to Filter a List

· Clearing AutoFilter Criteria

· Creating a Custom AutoFilter

· Disabling AutoFilter

Working with Advanced Filters

· Creating a Criteria Range

· Showing All Records

· Using Comparison Criteria

· Using an Advanced AND Condition

· Using an Advanced OR Condition

· Copying Filtered Records

· Using Database Functions

Creating and Revising Pivot Tables

· Creating a PivotTable

· Adding Pivot Table Report Fields

· Selecting a Page Field Item

· Changing the Summary Function

· Adding, Moving and Deleting Pivot Table Fields

· Hiding and Unhiding Items

· Creating a Page Field Report

· Formatting a Pivot Table

· Creating a Pivot Chart

· Publishing Pivot Table Reports to the Web


·

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Flash MX 2004
HTML
HTML/CSS Advanced
Programming in VBA using Access
Programming in VBA using Excel
Programming in VBA Using Word
Visual Basic
Certificate III in Business Administration
Certificate IV in Business Administration
Excel Formulas and Functions
Access Query and Reports

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.