Analyzing Business Data with Excel

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [V] [W] [X] [Z]

pictures 2nd

pivot charts

     adding 2nd

     analysis example

     display techniques 2nd

     linking 2nd

     multiple layers and pages

pivot tables

     analysis example

     changing data

     display techniques

     drilling down

     filtering 2nd

     linking pivot charts 2nd

     multiple data items

     multiple layers and pages

     options

     overview

     populating 2nd

     rows and columns 2nd

     sorting 2nd

PivotTable wizard 2nd 3rd

pointers, tag sort and

positive correlation

predictions

     forecasting procedure

     monitoring complex systems

     regression example

     trends and

prices, setting product

probabilities 2nd 3rd

problem definition

problem solving

     calculating market share

     equivalence

     extracting report data

     finding multiple values

     goal seeking

     importing dates 2nd

     importing numbers

     matrix problems

     mixture problem

     quadratic equations

     regression problems

     setting prices

     Solver tool and

     zero/one problem

processes, business 2nd

products, setting prices