Analyzing Business Data with Excel

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

A

ABS function, Adjust for the trend

Access databases, Databases

ADDRESS function, Addressing Cells Indirectly, Calculations on the Workarea Sheet

#agg columns, XML

analysis, modeling and, Analysis, Analyzing the Results

anomalies, Trimmed average

Application Data/Microsoft/AddIns folder, Moving average

applications

customizing, Customizing the Application

designing example, Building an Application, Application Design

display techniques, Respect the Information and the Audience, Large Worksheets, Complexity

measuring quality, Running the Application, Application Design

monitoring complex systems, The Application

named ranges, Named Ranges on Workarea

named values, The Named Values on the Workarea Sheet

queuing example, The Application, The Application, Extending the Application

Visual Basic, Visual Basic

array formulas

functionality, The Procedure

measuring quality, Calculations on the Workarea Sheet, Other parts of the Display sheet, Customizing the Application

overview, Array Formulas

arrays, extracting report data, Equivalence

autocorrelation, Find the lag

average

changes in, Moving average

control limits and, Running the Application

filtered, Trimmed average, Find ...