Pivot Tables Day 2 class notes

Pivot Tables Day 2 class notes - To reference data click on...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Pivot Tables Day 2 Pivot chart is always tied to pivot table Pivt Table Field List o Axis Fields = Row Labels Applying WS protection to protect formulas: o You have to select cells, format cells, protection, and then unlock them A one input Data table only has one input! Data Table inputs o Use row or column input not both You have to reference the original value not the whole column
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: To reference data click on it in pivot table after selecting cell o You can rearrange data and correct value would still be displayed =Vlookup(value, pivottable, column number, FALSE) o The false makes it so it returns exact matches not close ones o Make references absolute o...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online