Pivot Tables

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

Purpose of a Pivot Table

-Used to summarize and analyze large volumes of data. -Two or three way tabular presentation of chosen fields. -Certain statistics can be calculated at the field intersections.

Adding and removing report totals fields to the value area

...

Classic Pivot Table Layout

...

Sorting within a Pivot Table

...

Adding a calculated field

Creating a field that doesn't exist in the database. -Use the field name.

Record

Group of related fields about one object or event. ROWS

Field

Represents and attribute or measurement of some object or event. COLUMNS

Filtering within a Pivot Table

TABS 3: All records including averages. 2: Just averages and grand averages. 1: Grand average total.

Database Hierarchy

-Data is made up of characters. -Related characters=field -Related fields=record -Related records=file -Related files=database CFRFD

Steps in creating a Pivot Table

-Familiarize yourself with the database. -Visualize what you want it to look like. -Place your active cell in the data and click on the Pivot Table icon in the Insert Ribbon. -Pivot Table Options/Display, click on Classic Pivot Table Layout. -Click and drag field names onto the page, row, column, or data areas.

Pivoting values from columns to rows

Drag

What goes on the top row?

Field Names

Purpose of refresh icon

Keeping the table's information correct with the database.

Database

Organized collection of related information.

Changing the Field Settings and Appearance

Pivot Table Tools -Options and Design Tabs


Kaugnay na mga set ng pag-aaral

Lesson 4: Basic Life Support for Children and Infants

View Set

n-clex level questions test 3 RNUR 1070

View Set

Competency 1 - Chapter 2 - Input, Processing, and Output

View Set

CH20-21 Assignment #24-30, 28-34

View Set

Chapter 8: Appendicular Skeleton

View Set

5.2.2 Quiz: Public Policy and Your Safety

View Set

GEOM A, U7L3: Proving That a Quadrilateral Is a Parallelogram

View Set

anatomy - heart and blood vessels

View Set

mastering A&P ch. 23 group 1 modules 23.1-23.5 DSM

View Set

KINE 307 Chapter 14: Sociocultural Influences on Motor Development

View Set

Unit 2 - Solving Multi-step equations

View Set

AP Statistics Chapter 15: Probability Rules!

View Set