Working with Microsoft Office 2011 for Mac

Office 2011 can use Microsoft Access .mdb files as data sourcess
Click here for more information.

Make a histogram in Excel
Click here for step-by-step instructions.

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.

Free Toolbar for Excel
The Mac MVPs have put together a free toolbar that gives you access to features you might otherwise not know about.

Articles about working with external data:
Microsoft Office For Macintosh Database Connectivity Overview
Office 2011 for Mac and Microsoft Access for Windows
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 Programmatically 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)

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.

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 sites
J.E. McGimpsey's Excel Pages (Mac oriented)
Jon Peltier's Excel Page (PC oriented focusing on graphs and charts)
Ron de Bruin's Excel for Mac page
Tushar Mehta's Excel tips (PC oriented)
Chip Pearson's Excel Page (PC oriented)
SIMTOOLS and FORMLIST statistics add-ins
        SIMTOOLS seems to work as advertisied in Excel 2011. FORMLIST functions seem to work, but the FORMLIST Tools menu item does not display.