Skip to Main Content
Analyzing Business Data with Excel
book

Analyzing Business Data with Excel

by Gerald Knight
January 2006
Beginner to intermediate content levelBeginner to intermediate
262 pages
6h 18m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Business Case Analysis with R: Simulation Tutorials to Support Complex Business Decisions

Business Case Analysis with R: Simulation Tutorials to Support Complex Business Decisions

Robert D. Brown III

Publisher Resources

ISBN: 0596100736Supplemental ContentErrata Page