Excel Upgrade

MS Excel 2003 -> 2007 Tools

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Spelling>Review | Proofing | Spelling
Research>Review | Proofing | Research
Error Checking>Formulas | Formula Auditing | Error Checking
Track Changes | Highlight Changes>Review | Changes | Track Changes | Highlight Changes
Track Changes | Accept or Reject Changes>Review | Changes | Track Changes | Accept/Reject Changes
Compare and Merge Workbooks>Office Button | Excel Options | Customize | All Commands | Compare and Merge Workbooks
Goal Seek>Data | Data Tools | What-If Analysis | Goal Seek
Scenarios>Data | Data Tools | What-If Analysis | Scenario Manager
Formula Auditing | Trace Precedents>Formulas | Formula Auditing | Trace Precedents
Formula Auditing | Trace Dependents>Formulas | Formula Auditing | Trace Dependents
Formula Auditing | Trace Error>Formulas | Formula Auditing | Error Checking | Trace Error
Formula Auditing | Remove All Arrows>Formulas | Formula Auditing | Remove Arrows
Formula Auditing | Remove All Arrows>Formulas | Formula Auditing | Remove Arrows | Remove Arrows
Formula Auditing | Evaluate Formula>Formulas | Formula Auditing | Evaluate Formula
Formula Auditing | Hide Watch Window>Formulas | Formula Auditing | Watch Window
Formula Auditing | Formula Auditing Mode►Formulas | Formula Auditing | Show Formulas
Formula Auditing | Show Formula Auditing Toolbar►Formulas | Formula Auditing
Macro | Macros►Developer | Code | Macros
Macro | Macros►View | Macros | Macros
Macro | Record New Macro►Developer | Code | Record Macro
Macro | Record New Macro►View | Macros | Macros | Record Macro
Macro | Security►Developer | Code | Macro Security
Macro | Visual Basic Editor►Developer | Code | Visual Basic
AutoCorrect Options►Office Button | Excel Options | Proofing | AutoCorrect Options
Options►Office Button | Excel Options

MS Excel 2003 -> 2007 Data

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
Sort>Office Button | Excel Options | Customize | All Commands | Sort
Filter | AutoFilter>Data | Sort & Filter | Filter
Filter | AutoFilter>Home | Editing | Sort & Filter | Filter
Filter | Show All>Data | Sort & Filter | Clear
Filter | Show All>Home | Editing | Sort & Filter | Clear
Filter | Advanced Filter>Data | Sort & Filter | Advanced
Form>Office Button | Excel Options | Customize | All Commands | Form
Subtotals>Data | Outline | Subtotal
Validation>Data | Data Tools | Data Validation
Table>Data | Data Tools | What-If Analysis | Data Table
Text to Columns>Data | Data Tools | Convert Text to Table
Consolidate>Data | Data Tools | Consolidate
Group and Outline | Hide Detail>Data | Outline | Hide Detail
Group and Outline | Show Detail>Data | Outline | Show Detail
Group and Outline | Group>Data | Outline | Group
Group and Outline | Group>PivotTable Tools | Options | Group
Group and Outline | Ungroup>Data | Outline | Ungroup
Group and Outline | Ungroup>PivotTable Tools | Options | Ungroup
Group and Outline | Auto Outline>Data | Outline | Group | Auto Outline
Group and Outline | Clear Outline>Data | Outline | Ungroup | Clear Outline
Group and Outline | Settings>Data | Outline | Group and Outline Settings
PivotTable and PivotChart Report>Insert | Tables | PivotTable | PivotTable/PivotChart
Import External Data | Import Data>Data | Get External Data
Import External Data | New Web Query>Data | Get External Data | From Web
Import External Data | New Database Query>Data | Get External Data | From Other Sources | From Microsoft Query
Import External Data | Edit Query>Office Button | Excel Options | Customize | All Commands | Edit Query
Import External Data | Data Range Properties>Data | Connections | Properties
Import External Data | Data Range Properties>Table Tools | Design | External Table Data | Properties
Import External Data | Parameters>Office Button | Excel Options | Customize | All Commands | Parameters
List | Create List>Insert | Tables | Table
List | Resize List>Table Tools | Design | Properties | Resize Table
List | Total Row>Table Tools | Design | Table Style Options | Total Row
List | Convert to Range>Table Tools | Design | Tools | Convert to Range
List | Publish List>Table Tools | Design | External Table Data | Export | Export Table to SharePoint List
List | View List on Server>Table Tools | Design | External Table Data | Open in Browser
List | Unlink List>Table Tools | Design | External Table Data | Unlink
List | Synchronize List►Office Button | Excel Options | Customize | All Commands | Synchronize List
List | Discard Changes and Refresh►Office Button | Excel Options | Customize | All Commands | Discard Changes and Refresh
List | Hide Border of Inactive Lists►Removed from product
XML | Import►Developer | XML | Import
XML | Export►Developer | XML | Export
XML | Refresh XML Data►Developer | XML | Refresh Data
XML | XML Source►Developer | XML | Source
XML | XML Map Properties►Developer | XML | Map Properties
XML | Edit Query►Removed from product
XML | XML Expansion Packs►Developer | XML | Expansion Packs
Refresh Data►PivotChart Tools | Analyze | Data | Refresh
Refresh Data►PivotTable Tools | Options | Data | Refresh
Refresh Data►Table Tools | Design | External Table Data | Refresh
Refresh Data►Data | Connections | Refresh | Refresh
Refresh Data►PivotChart Tools | Analyze | Data | Refresh | Refresh
Refresh Data►PivotTable Tools | Options | Data | Refresh | Refresh
Refresh Data►Table Tools | Design | External Table Data | Refresh | Refresh

MS Excel 2003 -> 2007 Window

Posted on by Jeff Feiertag
Excel 2003 Location  Excel 2007 Location
New Window►View | Window | New Window
Arrange►View | Window | Arrange All
Compare Side by Side with►View | Window | View Side by Side
Hide►View | Window | Hide
Unhide►View | Window | Unhide
Split►View | Window | Split
Freeze Panes►View | Window | Freeze Panes
Currently Open Workbooks►View | Window | Switch Windows