Learn how to install Office 2007 with a disc and a product key, and how to activate it from Excel, Word, PowerPoint, and Access. Office 2007 is no longer supported and you should upgrade to a newer version.

Learn how to work with Excel 2007 workbooks in Compatibility Mode or convert them to a file format that can be opened by Excel 97-2003 and later versions. Find out which features are not supported in earlier versions and how to resolve compatibility issues.

List of all Excel functions available. VLOOKUP function. IF function. Create a drop-down list. Combine text from two or more cells. Freeze panes to lock rows & columns. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable. Sort data in a PivotTable or PivotChart.

A list of Excel training, from entry level to advanced skills, plus templates and other resources.

Office 2007. Important: Office 2007 is no longer supported. Learn how to upgrade to a newer version. If you still need to install this version, you'll need an Office 2007 installation disc and a product key for the version you're trying to install.

Excel 2007 Selecting Microsoft Office Button > Excel Options > Advanced > Extend date range and formulas (under Editing options)).

An ISO strict version of the Excel Workbook file format (.xlsx). Excel Workbook (code).xlsm. The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm). Excel Binary Workbook.xlsb. The binary file format (BIFF12) for Excel 2007-2013. Template.xltx

Office 2007. Important: Office 2007 is no longer supported. Learn how to upgrade to a newer version. If you still need to install this version, you'll need an Office 2007 installation disc and a product key for the version you're trying to install.

To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. Then set the Compatibility Checker to run automatically every time you save that workbook.

Excel file formats. The default XML-based file format for Excel 2010 and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007.