Working with Excel for Mac

By Jim Gordon, co-author of
Office 2008 for Mac All-in-One For Dummies

An entire "book within a book" about Mac Excel is included in the Dummies book. I hope you click the link above to look inside the book. I think we succeeded in creating a book that you will find indispensable.

Articles about working with external data:

Macintosh, Microsoft Office 2004, and Microsoft Access (This will download a Microsoft Word document.)
Microsoft Office For Macintosh Database Connectivity Overview
Using Microsoft Office as a Relational Database
How to link Excel data with a graph in Word or PowerPoint
How to create Web query files for use with Excel for Mac
How to Pro grammatically Perform a Web Query using Visual Basic for Applications (should be good for all Excel versions '95 through 2004, but not Excel 2008)
You can not edit a web query by clicking on the "edit query" button on the data tool bar
Use Excel Macros (Visual Basic for Applications (Does not Apply to Excel 2008)
How to shade every other row (This downloads a how-to PowerPoint presentation)

Free Web Table Report template

Click here for details about this free Excel template that uses web queries to import table data from the web into Excel.

Troubleshooting Excel

Start by clicking here for general troubleshooting steps for OS X.
When using Snow Leopard, font problems can easily surface. This guide can help.
Summary of Methods to Recover Data from Corrupted Excel Files.

Free On-line Tutorials:

            Mr. Excel, Bill Jelen, has a series of tutorials on line hosted in Apple's iTunes.
            Click this link to see Bill's recent podcasts in iTunes.

Online Analysis Tools By Rodney and Neville
Provides the same functionality as the Excel Data Analysis Toolpak for use online, without macros. Click here.

Links to other Excel MVP sites

J.E. McGimpsey's Excel Pages (Mac-oriented)
Jon Peltier's Excel Page (PC oriented focusing on graphs and charts)
Tushar Mehta's Excel tips (PC oriented)
Chip Pearson's Excel Page (PC oriented)
Complete list of Excel MVPs (PC oriented)
Jim Gordon's MVP Home