Excel

Open an add-in dialog box from Excel Options

2012-11-15T01:58:00.001-08:00

Click the Office button, click Excel Options

Click Add-ins, click the Manage list arrow,

click Excel Add-ins or COM Add-ins

Click Go.

Manage Installed Add-ins

2012-11-15T01:56:00.003-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Add-Ins. 
           Click the Manage list arrow, and then click the add-in list:
           COM Add-ins.
           Excel Add-ins.
           Smart Tags.
           XML Expansion Pack.
           Disabled Items.

Click Go.

Click OK.

View Installed Add-ins

2012-11-15T01:55:00.003-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Add-Ins.

Click an add-in to display information about it.

Change Macro Security Settings

2012-11-15T01:48:00.005-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Trust Center. Then click Trust Center Settings.

In the left pane, click Macro Settings. Select the option for macros: 
             Disable all macros without notification, 
             Disable all macros with notification, 
             Disable all macros except digitally signed macros, 
             Enable all macros.

If you're a developer, select the Trust access to

the VBA project object model check box.

Create a self-signing certificate for a macro project

2012-11-15T01:47:00.001-08:00

Click Digital Certificate for VBA Projects under Office Tools

Enter a name, and then click OK.

Office programs trust a self-signed certificate

only on the computer that created it.

Sign a Macro Project

2012-11-15T01:45:00.004-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. Select the

Show Developer tab in the Ribbon.

Click the Developer tab. Click the Visual

Basic button to open the Visual Basic window.

Click the Tools menu, and then click Digital Signature.

Click Choose.

Select a certificate in the list.

To view a certificate, click View Certificate, and then click OK.

Open a Workbook with Macros

2012-11-15T01:44:00.003-08:00

Click the Office button, and then click Open.

Click the workbook with macros you want to open, and then click Open.

Click Options in the Security Warning.
           Click OK.

Save a Workbook with Macros

2012-11-15T01:41:00.000-08:00

Click the Office button, and then click Save As.

Type a workbook file name.
Click the Save as type list arrow, and then select:
Excel Macro-Enabled Workbook. A workbook (.xlsm) that

contains VBA code.
or Excel Macro-Enabled Template. A template (.xltm)

that includes preapproved macros.

Click Save.

Record a Macro

2012-11-15T01:39:00.001-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.

Click the Developer or View tab.

To record a macro with actions relative to the

initially selected cell, click the Use Relative References button.

Click the Record Macro button.

Type a name for the macro. Assign a shortcut key to run the macro.

Click the Store macros in list arrow, and then select:
           Personal Macro Workbook to use the macro whenever you use Excel.
           New Workbook to use the macro in new workbooks.
           This Workbook to use the macro only in this workbook.

Type a description. Click OK.

Execute the commands.

Click the Stop Recording button

Edit a Macro

2012-11-15T01:36:00.001-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.

Click the Developer or View tab. Click the Macros button.

Click the macro you want to edit, and then click Edit.

Click the Module window containing the Visual Basic code.

Edit the commands already present

Debug a Macro Using Step Mode

2012-11-15T01:34:00.005-08:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.

Click the Developer or View tab.  
           Click the Macros button.

Click the macro you want to debug. Click Step Into.

The Microsoft Visual Basic window opens.

Click the Debug menu, and then click Step Into to

proceed through each action.

Delete a Macro

2012-11-02T04:46:00.001-07:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.

Click the Developer or View tab. 
           Click the Macros button.

Click the macro you want to delete. 
           Click Delete.

To stop a macro. Press Ctrl+Break to stop a macro

Run a Macro

2012-11-02T04:42:00.003-07:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.

Click the Developer or View tab. 
           Click the Macros button.

Click the macro you want to run. Click Run.

Assign a Macro to a Toolbar

2012-11-02T04:40:00.004-07:00

Click the Customize Quick Access Toolbar list arrow, 
           and then click More Commands.

Click the Choose command from, and then click Macros.

Click the macro from left column. Click Add.

Click the Move Up and Move Down arrow buttons to arrange the order.

Click Modify.

Type a name for the button. Click an icon in the symbol list.

Create a Macro

2012-11-02T04:38:00.005-07:00

Click the Office button, and then click Excel Options.

In the left pane, click Popular. 
           Select the Show Developer tab in the Ribbon.

Click the Developer tab.  
           Click the Macros button.

Type a name for the macro.

Click the Macros in list arrow, and then click All Open Workbooks.

Click Create.

The Microsoft Visual Basic window opens.

Click the Module window, and then type new Visual Basic commands.

Create a Scenario Summary or PivotTable Report

2012-11-02T04:34:00.004-07:00

Click the Data tab. 
           Click the What-If Analysis button,

and then click Scenario Manager.

Select the scenario.
           Click Summary.

Click the Scenario summary or Scenario

PivotTable report option.Click OK.

A scenario summary worksheet tab appears with the report.

Show a Scenario

2012-11-02T04:32:00.007-07:00

Click the Data tab. 
           Click the What-If Analysis button, 
           and then click Scenario Manager.

Select the scenario you want to see.

Click Show.

Click Close.

Show a Scenario

2012-11-02T04:32:00.005-07:00

Click the Data tab. 
           Click the What-If Analysis button, 
           and then click Scenario Manager.

Select the scenario you want to see.

Click Show.

Click Close.

Show a Scenario

2012-11-02T04:32:00.003-07:00

Click the Data tab. 
           Click the What-If Analysis button, 
           and then click Scenario Manager.

Select the scenario you want to see.

Click Show.

Click Close.

Create and Show a Scenario

2012-11-02T04:30:00.002-07:00

Click the Data tab. 
           Click the What-If Analysis button, 
           and then click Scenario Manager.

Click Add.

Type a name that identifies the scenario.

Type the cells you want to modify in the scenario.

Select the Prevent changes check box to protect the cell.

Click OK.

Type values for each of the displayed changing cells.

Then Click OK. Click Close.

Create a 'What-If' Scenario with Goal Seek

2012-11-02T04:28:00.001-07:00

Click any cell within the list range.
Click the Data tab. 
Click the What-If Analysis button, and then click Goal Seek.

Click the Set Cell box, and then type the cell address.
Click the To Value box, and then type the result value.
Click the By Changing Cell box, and then type the cell

address you want Excel to change.
           Click OK.

The Goal Seek Status dialog box, opens displaying the goal seek results.

To clear the circles

2012-11-02T04:25:00.003-07:00

Click the Data Validation button arrow,

and then click Clear Validation Circles.

View invalid data

2012-11-02T04:24:00.004-07:00

Click the Data Validation button arrow,

and then click Circle Invalid Data

Create Validation Rules

2012-11-02T04:22:00.002-07:00

Select the range. Click the Data tab. Click the Data Validation button.

Click the Settings tab. 
Click the Allow list arrow, and then select a value type.

Click the Data list arrow, and then select a logical operator.

Enter values or use Collapse Dialog button to select

a range for the minimum and maximum criteria.

Click the Input Message tab, 
and then type a title and the input message

that should be displayed when invalid entries are made.

Click the Error Alert tab, 
and then select an alert style, type a title,

and error message.

Click OK.

Use Solver

2012-10-31T04:58:00.001-07:00

Click the Data tab. Then click the Solver button.

Select the target cell.

Click an Equal To option, and then, if necessary, enter a value.

Select the cell range the solver uses to compare against the target cell.

Click Add.

Enter specific cell reference and constraint, and then click Add.
           Click OK.

Click Solve.

If the Solver finds a solution, the Solver Results dialog box opens.
           Click the Keep Solver Solution option.
           Click a report type.
           Then click OK.