There are lots of useful features in Excel such as AutoFill, and AutoSum.
Here are a couple more:
To insert today's date into a cell, press Ctrl+;
Occasionally, when you try to type something in Excel it changes. This is due to default formatting. For example: if you type in a cell Jan 11, it becomes 11-Jan. Or, you might for some reason want to enter in a fraction. However, 1/2 becomes 2-Jan. Or, you wish to enter in a zip code with leading zeros, but you lose the leading zeros.
These automatic formats can usually be changed by going to the Format Cells dialog. However, another way around it is before you enter in a cell something you know might get reformatted, type in what you want with a leading '. The ' will be stripped away and whatever was typed remains.
Ex: '00454 stays 00454, '1/2 stays 1/2 etc.
New Features in Microsoft Office 2010: A Preview
General:
The Office Button has been replaced by a File tab. This launches a "Backstage View" which provides new ways to manage, print and share documents.
The Ribbons can now be customized.
Word 2010
Incorporates a new Navigation pane to search for text and new formatting tools.
Excel 2010
New chart feature called Sparklines.
Add slicers to PivotTables to better sort and manage data.
Outlook 2010
Main interface is now all Ribbons.
Show messages as Conversations grouped by subject in order to better follow e-mail conversations between users.
Access 2010
Additions to Table design include Quick Start fields. These are common fields like Address, City, etc. that are easy to add and delete. Also included is a data type gallery to make it easier to select data types with certain properties selected.
PowerPoint 2010
Now has a Reading View, and allows you to organize slides into sections.