Excel® 2016 Pivot Table Data Crunching

Index

Symbols

% (percent), comparing lines with, 71

= (equal sign), 292

3D Map, 245

bubble/pie charts, creating, 266

case studies, 271-273

column charts, formatting, 264

data over time, animating, 269

geocoding data, 262-263

geographic data, analyzing, 261-273

heat maps/region maps, applying, 266

labeling points, 266

navigating, 264-265

optimizing, 267-269

preparing data for, 261

tours, building, 270-271

videos, sharing, 271

A

Access (Microsoft), formatting pivot tables, 169-171

accessing functions, OLAP, 211-213

accounts, saving to OneDrive, 195

actions

column-level, 185

tables, 186-188

activating classic layouts, 30

ActiveX controls, 279

activity by market, analysis of, 38

Add This Data to the Data Model option, 25

add-ins

Pivot Power Premium, ...