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
· UK Excel User Conference 12/12/2008
· Understanding Excel Services Load Balancing Options
12/12/2008
· Using Excel to Optimize a Network Problem
12/04/2008
· Using the Open XML SDK to Work With Excel Files
11/25/2008
· Using PivotTables to Analyze Data From a SharePoint List
11/06/2008
· Excel Web Application Announced at PDC
10/29/2008
· Creating a Master-Detail View in Excel
10/23/2008
· Don't forget about the "A" in "VBA"!
10/17/2008
· Using Office Data Connection files (.odc) and the DataConnections Web Part in SharePoint to Specify External Data Connections in Newly Created Excel Workbooks.
10/15/2008
· What is the fastest way to scan a large range in Excel?
10/03/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