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)