| Excel 2003 |
Location in Excel 2007 |
| Spelling |
- Review Tab
- Proofing Group
- Spelling
|
| Research |
- Review Tab
- Proofing Group
- Research
|
| Error Checking |
- Formulas Tab
- Formula Auditing Group
- Click Error Checking
- Then click Error Checking
|
| Speech |
Show Text to Speech Toolbar –
Not included in 2007 |
| Shared Workspace |
- Office Button
- Publish
- Create Document Workspace
|
| Share Workbook |
- Review Tab
- Changes Group
- Share Workbook
|
| Track Changes |
- Highlight Changes
- Accept or Reject Changes
|
| Protection |
- Protect Sheet
- Allow Users to Edit Ranges
- Protect Workbook
- Protect and Share Workbook
|
| Online Collaboration |
Not included in 2007 |
| Goal Seek |
- Data Tab
- Data Tools Group
- Click What-If Analysis
- Goal Seek
|
| Scenarios |
- Data Tab
- Data Tools Group
- Click What-If Analysis
- Scenario Manager
|
| Formula Auditing |
- Trace Precedents
- Trace Dependents
- Trace Error
- Remove All Arrows
- Evaluate Formula
- Show Watch Window
- Formula Auditing Mode
- Show Formula Auditing Toolbar
|
Macro
Commands for working with macros and XML are on the Developer Tab which is
displayed only if you turn it on. To display the Developer Tab do the following |
- Click Office Button
- Excel Options
- Popular
- Show Developer Tab in the Ribbon
|
| Add-Ins |
- Office Button
- Excel Options
- Click Add-Ins on the left column
- To the right of Manage: Select the type of Add-Ins you want then click Go
- The Add-In will be available under the appropriate Tab
- If you choose the Conditional Sum Add-In
- Under the Formula Tab the Solutions Group will be available
|
| AutoCorrect Options |
- Office Button
- Excel Options
- Proofing Group
|
| Customize |
- Office Button
- Excel Options
|
| Options |
- Office Button
- Excel Options
|
