Microsoft Excel 2007 Version Overview
The following is a list of key new features in Microsoft Excel 2007.
For other versions of Excel, check out the following:
Microsoft Excel 2016 Version Overview
Microsoft Excel 2013 Version Overview
Microsoft Excel 2010 Version Overview
Looking for Excel training courses?
Microsoft Excel 2007 New Features
Applies to: Microsoft Excel 2007 for Windows
The following are some of the key new features available in Microsoft Excel 2007.
The Ribbon
The Ribbon first appeared in 2007 and offers a new way of navigating compared to the traditional Excel menus. The Ribbon tabs are arranged in groups and certain tabs only appear when you have a specific item selected such as a picture.
Office Button (Backstage View)
The Office button replaced the traditional File menu and is also called the Backstage View. Here you'll be able to open, close, save and print your documents.
Customize the Quick Access Toolbar
In Excel 2007, you have the ability to customize the Quick Access Toolbar and add your favorite buttons.
Improved Sorting and Filtering
Excel 2007 includes significant improvements for filtering lists, Check boxes now appear automatically for filtering most fields. You can filter multiple items and also filter in pivot tables. You can also sort by more fields and sort by color and dates.
Format Using Themes and Styles
Excel 2007 includes themes which are tied to styles. A theme is a predefined set of colors, fonts and effects that can be applied to your entire workbook. There are predefined styles that are based on the theme that you can choose to apply to tables, charts, shapes and cells. You can also create your own themes and styles.
Enhanced Conditional Formatting
Several changes have been made to conditional formatting. You can now apply data bars, icon sets and other types of conditional formatting.
Larger Spreadsheets
You now have 16,284 columns and 1,058,576 rows. This is a significant increase from Excel 2003.
Resizable Formula Bar and AutoComplete
In Excel 2007, the formula bar now resizes so a formula doesn't cover data in the cells. Excel 2007 also now has an Autocomplete feature where a drop-down menu appears when you start to type in a function.
New Functions
A few new functions were added in Excel 2007 including SUMIFS, COUNTIFS and IFERROR.
Contact us to discuss any of our custom options.
Check out our blog for more Excel tips, tricks and shortcuts.
Public courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Avantix Learning Excel Courses | Frequently Asked Questions (FAQs)
Do you need more information? Contact us!
Copyright 2017 Avantix Learning Inc.
To request this page in an alternate format, contact our staff.
Custom training
Register for a public course or contact us to arrange custom training at your site or ours.
Related Excel courses
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction
You may like
How to Combine First and Last Name in Excel (5 Ways)
You can combine first and last name in Excel in several ways – using the CONCATENATE operator, the CONCATENATE function, the CONCAT function, the TEXTJOIN function or Flash Fill. These functions are often used to combine text in cells but you can also combine text with spaces, commas, dashes or another character. It's common to combine first and last names that appear in two columns into one new column. Some functions are only available in newer versions of Excel but the CONCATENATE operator and function are available in all versions.
How to Insert Multiple Columns in Excel (4 Fast Ways with Shortcuts)
You can quickly insert multiple columns in Excel using a drop-down menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple columns at once, rather than one by one, is to select the number of columns you want to insert first and then insert columns. Excel will insert the same number of columns you selected.
You may also like
How to Generate Random Text in Word
If you are creating a Microsoft Word document, template or mockup and you want to create placeholder text, you can generate random text using the built-in RAND function or LOREM function (which generates Latin or Lorem ipsum text).
How to Center Text Vertically in a Word Table (and Fix Common Issues)
You can center or align text vertically in cells in a Word table using commands in the Table Design or Table Tools Design tab in the Ribbon. If the text doesn't seem to align correctly, there are several common issues that may be affecting the alignment including extra blank paragraphs, paragraph spacing and cell margins.
How to Insert a Watermark in Word (like DRAFT)
You can insert a watermark in the background of one or more pages in a Microsoft Word document. Common watermarks are text such as DRAFT or CONFIDENTIAL but you can also add a picture watermark.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca