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] ABS function 2nd 3rd 4th Access databases 2nd ADDRESS function 2nd 3rd 4th Address property (range) #agg columns alignment, X axis analysis, modeling and 2nd anomalies 2nd Application Data/Microsoft/AddIns folder applications considering data sources conventions and names customizing 2nd designing example 2nd 3rd display techniques 2nd 3rd 4th formatting example importing data for linking to data 2nd listing requirements measuring quality 2nd monitoring complex systems named ranges 2nd 3rd named values 2nd presentation 2nd queuing example 2nd 3rd running example Solver and Goal Seek tools Visual Basic array formulas functionality measuring quality 2nd 3rd 4th monitoring complex systems 2nd 3rd 4th overview queuing example workload forecasting arrays, extracting report data Assign Macro dialog box autocorrelation average changes in control limits and 2nd filtered 2nd 3rd 4th finding moving statistical functions trimmed X charts and 2nd average error regression model 2nd 3rd 4th 5th workload forecasting 2nd 3rd 4th AVERAGE function depicted optimizing example queuing example 2nd workload forecasting 2nd AVERAGEA function 2nd |