Learn how to install and activate Office 2007, which is no longer supported by Microsoft. You'll need an Office 2007 installation disc and a product key for the version you're trying to install.

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.

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

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.

Learn how to install and activate Office 2007, which is no longer supported by Microsoft. You'll need an Office 2007 installation disc and a product key for the version you're trying to install.

In Excel 2013 and later, Excel defaults to showing the Start screen with recent workbooks, locations, and templates upon starting. This setting can be changed to instead bypass this screen and create a blank workbook.

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

Insert or delete a worksheet. In Excel, you can easily insert, rename, and delete worksheets in your workbook.

Learn how to install and activate Office 2007, which is no longer supported by Microsoft. You'll need an Office 2007 installation disc and a product key for the version you're trying to install.

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.