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.