Microsoft Excel 2007 Tutorials, Articles, Resources
Welcome to the Excel 2007 Nexus, your gateway to the "New Excel". Here you will find a quick getting started guide, Excel 2007 tips, and links to all the best tutorials, articles, add-ins, and books.
Getting Started
1. If you haven't already purchased Excel 2007 (or Office 2007), download and install the trial version of Microsoft Office 2007 from the
Official Site
I would make sure you can restore your computer to a point before the install. If you don't want to install the trial, you can still take the online test drive.
 Test Drive 2007 Online
2. Get familiar with the new user interface by watching the online Demo, "Up to Speed With Excel 2007". Play Demo
3. Dive In! Try creating tables, graphs, formulas, etc. I am currently working on an Excel 2007 Tutorial, which you are welcome to try out, but keep in mind that it is certainly a work in progress. Excel 2007 Tip of the WeekWe've created a new Monthly Calendar template specifically for Excel 2007 that allows you to modify the color scheme by picking a new theme! Check it Out! Free Online Excel 2007 Courses |
MS Excel 2007 Help
The following links will work if you have the Excel 2007 Beta on your computer.
Excel 2007 Help and How-To · What's New · Basics (Entering, Formatting, Copying, etc.) · Command Locations (2003 vs. 2007) · Formulas and Name Basics · Function Reference · Importing Data · Charts · Macros · Tables · Pivot Tables and Charts · File Conversion and Compatibility 
Microsoft Excel 2007 Blog
· PivotTables: Calculated Items 05/09/2008
· Append Multiple Text Files into a Worksheet without Code
04/30/2008
· Improving Sheet Selection
04/22/2008
· Building the Excel Media Player – Part 3
04/18/2008
· Building the Excel Media Player – Part 2
04/16/2008
· Building the Excel Media Player – Part 1
04/14/2008
· Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”
04/10/2008
· Statistics and Business Data: Detecting Unexpected Values
04/02/2008
· Office Open XML, a.k.a. IS 29500
04/02/2008
· Shadows on Charts and Cells in Excel 2007
03/28/2008
|
Excel 2007 Books
Excel 2007 Bible
by John Walkenbach
Excel 2007 for Dummies
by Greg Harvey, PhD
Excel 2007 Power Programming With VBA
by John Walkenbach
Excel 2007 Miracles Made Easy
by Bill Jelen