Excel Features and Functions G-W

Front

Global Options

Back

Options and settings you can specify in Excel that affect all workbooks.

Front

Goal Seek

Back

A tool to automate changing one variable while calculating a formula to match the desired value.

Front

Grouping

Back

Simplifies a large table or pivot table by condensing data into logical groups.

Front

Insert Function

Back

Helps you select the desired function to perform calculations in Excel.

Front

Link

Back

Referencing cells or worksheets in a 'source' workbook to update linked workbooks automatically.

Front

Macro

Back

A set of actions recorded and executed with a single command.

Front

Macro Recorder

Back

Tracks Ribbon selections and activities to create a macro.

Front

Macro-enabled Workbook

Back

A workbook in which one or more macros is saved.

Front

Nesting

Back

Embedding one function inside another to yield a value from multiple calculations.

Front

Outline

Back

Enables you to quickly expand or collapse groups of data.