Excel Scientific and Engineering Cookbook

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