Submit your Tips & Tricks in this thread to help new users get up to speed!

__________________
Regards,
Simon

Please read this before cross posting!
Please always give feedback...good or bad!

Please take the time to read the Forum Rules before posting!

To Hide the Ribbon Commands:
Double click on one of the ribbon tabs, e.g Home, Insert, or Page Layout.

OR

Press the CTRL + F1 keys on your keyboard.
Only the tabs will be left showing above your spreadsheet.

To Show the Ribbon Commands Again:

Click on one of the ribbon tabs, e.g Home, Insert, or Page Layout.

OR

Press the CTRL + F1 keys on your keyboard again.

__________________
Regards,
Simon

Please read this before cross posting!
Please always give feedback...good or bad!

Please take the time to read the Forum Rules before posting!

Users new to 2007 should note that the file format has completely changed and that 2007 Excel spreadsheets (.xlsx) cannot be run on 2003. Also, if you want to include macros, you have to save as either .xls or .xlsm for a normal spreadsheet. The .xlsx format is far more compact than .xls; one of my spreadsheets shrunk from 20MB to 2.5MB when I upgraded it to .xlsx.
Spreadsheets now have 16,384 columns and 1,048,576 rows, as opposed to 256 columns and 65,536 rows in 2003 and before.
You can now have 30 (I think) nested IF functions, rather than only 7 in previous versions.
The Analysis Toolpak add-in is included in Excel 2007, so many date and other formulas are available out of the box.
Conditional formatting has been greatly improved. Users can create more than three conditional formats (not sure on the exact limit, but I've had over a dozen with no issues) and can choose whether the conditional formatting stops when a condition is found to be true or goes to the next rule. The options available in conditional formatting have been greatly expanded, allowing users to format based on top or bottom values (either absolute rankings or %), values above or below average, or unique or duplicate values, as well as applying a color scale that applies to each cell based on its ranking within the range.
The filter functions also have seen vast improvement. Instead of selecting only one value at a time to filter by, users can check or uncheck the values they want to see. If dates exist in the column, they roll up into months and years, making it easy to show or hide all dates in a certain time period.
There are also dozens of additional chart formats and options, allowing much better 3-D charting.
These are only the changes I've noticed most, by no means is it even close to complete.

To find the recent document(s) that you had open.

Go to the Office button (found in the at the top on the left hand side of the excel window) -> Click on the button and then click on the workbook you desire located on the right.

To adjust on how many document you wish displayed go the Excel Options (located on the bottom right hand side) after clicking on the Office button. Click on the "Advanced". Scroll down to a heading named "Display" then adjust the field next to "Show the number of Recent Documents:"

Number of Documents showing: Min is 0, Max is 50

Pin the Document

If you have a recurring document(s) that work on over days and/or weeks, you can pin it to the Office button by clicking once on the pin on the right hand side of the name of the document (the pin will turn green). That document will stay there until the document is unpinned (the pin will turn back to gray).

__________________
If you receive a solution....Please let us know:
1) Click the EDIT button on your first post
2) Click the GO ADVANCED button
3) Select SOLVED from the Title dropdown (under the Reason for Editing box)
4) Click the SAVE CHANGES button
Note: If it's more than 2 days after your first post, please ask a moderator to mark the thread SOLVED for you.

Office 2007
Any Feedback Welcomed

To get to a list of Options, click on the Office logo at the upper left-hand corner, then Excel Options. The "Popular" tab includes the option to show the Developer tab in the ribbon, which is necessary to record macros. There is also an Add-Ins tab to manage add-ins and several others that have considerably more options than in Excel 2003.

There is one caveat about conditional formatting that you should be aware of: when you copy and paste conditionally formatted cells' formats, Excel seems to want to create an entirely new rule for that selection, rather than expand the selection to which the rule applies. Thus, it is better to highlight the entire selection that you want to be conditionally formatted and then use the $ appropriately in whatever formulas you have, as Excel will update them based on the location of the top left cell in the selection. Alternatively, you can create the rule on just one selection and then go to Manage Rules... and change the range to which it applies.