Excel for Mac 2011 vs. Excel for Windows 2010
Whereas Excel for Mac 2011 and Excel for Windows 2010 are essentially two different versions, the new (and for the first time) philosophy of the latest round of Office suites (which includes Office 2010 and 2011) is incorporated in both versions. A direct result, like with Word for Mac 2011, is a 100 percent compatibility ratio, which will please a lot of people collaborating on documents that own different versions of the software.
Talking about collaboration, power users of the application, both in a corporate, student or a home environment will definitely enjoy the newly incorporated collaboration options in Excel 2011. As with Excel 2010, Excel documents can now be uploaded to Microsoft SkyDrive, where documents can be edited with the Web App version of Excel. Through the Web App of Excel, multiple users can co-author the same document. However, coauthoring is not possible locally, like with Word for Mac 2011, which is a bit of a drawback.
There are also a few differences between Excel 2011 for Mac and Excel 2010 for Windows. The main improvements in core functionality in Excel for Mac 2011 lay in conditional formatting, sparklines (an entirely new feature, also seen in Excel 2010), pivot-tables (a complete reinvention of the concept), visual basic and the sorting & filtering options. Whereas most features seem to be a direct port of their Windows counterparts, especially the sorting & filtering options, and are a step forward even from Excel 2010. The amount of options have gone up so considerably that mastering this aspect of the software will result in a considerable increase in efficiency. Naturally, the fact that Excel 2011 manages to outperform Excel 2010 is ironic and might even drive away people from Windows in favor of choosing the Mac platform.