PowerPivot for the Data Analyst: Microsoft® Excel 2010

Index

Symbols

32-bit PowerPivot version, 9–10

64-bit PowerPivot version, 9–10

& (ampersand) operator, 132–133

A

ABS function, 123, 129

active cell, hiding, 281

adding. See inserting

advantages

of PowerPivot, 38–44, 58–60

of PowerPivot Server, 286–287

ALLEXCEPT function, 237–239

ALL function, 230–240

ALLNONBLANKROW function, 238–239

ampersand (&) operator, 132–133

AND function, 140–141

appended data, handling improper data in, 73–74

asymmetric pivot tables, building with named sets, 39–40

asymmetric reporting, 33–34, 256–258

Atom feeds, importing data from, 83

autodetecting relationships, 85–88

AutoLayout mode (slicers), 41, 208

AVERAGE function, 226, 239

AVERAGEA function, 227, 239

AVERAGEIFS function, 228

AVERAGEX function, 144

axis line, deleting, ...