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.

Symbols

$ (dollar sign)
button, Discussion

A

accelerator characters, Main menu bar
Add Procedure dialog box, Subroutines
add-in functions, creating, Creating an add-in
Alt key, Main menu bar
Analysis ToolPak, Introduction
Correlation tool, Discussion
exponential smoothing, Solution
Fourier Analysis tool, Solution
Moving Average, Analysis ToolPak Moving Average
Rank and Percentile tool, Solution
Application object, The Object Browser
arguments, Discussion
arrays, Problem
AutoFilter, Discussion
automation
macros, Discussion
averages
AVERAGE formula, Spreadsheet formulas

B

boundary value problems, Introduction
breakpoints, Discussion
built-in financial formulas, Introduction
built-in functions, Problem
lookup functions, Discussion
button controls, adding to spreadsheets, Automating Goal Seek
ByVal keyword, Subroutines

C

Call keyword, Functions
cells, Discussion
cell names, Solution
cell references, Discussion
A1-style, Discussion
ranges, Solution
relative cell references, Discussion
data types, setting
scientific notation, Discussion
charts, Introduction
axes, customizing
Scale tab, Discussion
Chart Wizard, Solution
Axes tab, Discussion
Data Range tab, Discussion
Gridlines tab, Discussion

Get Excel Scientific and Engineering Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.