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 Replace Zeros (0) with Blanks in Excel
There are several strategies to replace zero values (0) with blanks in Excel. If you want to replace zero values in cells with blanks, you can use the Replace command or write a formula to return blanks. However, if you simply want to display blanks instead of zeros, you have two formatting options – create a custom number format or a conditional format.
What is Power Query in Excel?
Power Query in Excel is a powerful data transformation tool that allows you to import data from many different sources and then extract, clean, and transform the data. You will then be able to load the data into Excel or Power BI and perform further data analysis. With Power Query (also known as Get & Transform), you can set up a query once and then refresh it when new data is added. Power Query can import and clean millions of rows of data.
You may also like
How to Insert or Type A with an Accent Mark in Word (À, Á, Â, Ä, à, á, â, or ä)
You can insert or type a with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter a can be inserted with an accent in both upper or lower case. The following are common accents in upper or lower case – À, Á, Â, Ä, à, á, â, or ä.
10 Word Shortcuts to Select Text Using a Keyboard
You can use several shortcuts in Word to select text in your documents using only your keyboard. When you select text, it will typically be highlighted in grey. After you select text, you can cut, copy, or delete the selected text or apply character or paragraph formatting.
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).
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