Yawn-proof software training

Excel for Mac 2011 VS. PC 2010

It wasn’t long ago that the lines were pretty well defined for what computer platform a user would have to choose in order to run a particular piece of software. The Microsoft Office suite seemed to demand being run on a Windows PC, while design software  like Adobe Creative Suite migrated toward the Mac side. Today, these lined are blurred while many programs and full productivity suites, including Microsoft Office, are not only available and fully functional for both systems, but they are compatible. What a bonus for those of us who don’t wish to choose - or change.

Today our focus is on Microsoft Excel (2010 and 2011 versions) in particular; as this is the program that has raised the greatest debates in cross-platform functionality. In the computing world, the term “compatible” can be subjective to the user - heck, it can be subjective to the computer as well sometimes!  Today, we define the compatibility between Excel versions as the ability to use the same functions and tools, and the ability to open and save the same files for sharing. Compatibility does not necessarily mean the files will display identically in each version, nor with the tools and functions be located in the same places or initiated in the same way. 

The basics between 2010 and 2011 are covered:

Simple spreadsheets, workbooks, and templates open easily and without corruption and distortion across the board. This equates to more effective collaboration efforts and file sharing through iCloud, SkyDrive, or your local network. 

And so is the “fancy” stuff: 

The following, more elaborate, tools and features are also available in both the 2010 (PC) and 2011 (Mac) versions. 

  • Sparklines:  A nifty tool for creating pint-sized graphs in individual cells and visually highlighting the features of the adjacent cell data.
  • Pivot-Tables: These are ideal for quickly sorting great volumes of data based on user defined criteria.
  • Conditional Formatting: This tool takes your data sorting to the next level by highlighting any data that matches the specified criteria in a search with preset or user-defined formatting. 

We’ve only covered a few feature highlights so as not to overwhelm our readers. If you have a specific question about feature compatibility in any Microsoft Excel version, please feel free to post it in our comment section below.
Microsoft PowerPoint for Mac
Microsoft Word for Mac – Sharing and Collaboration

Related Posts



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Saturday, 04 April 2020

Captcha Image


How To Choose a Software Trainer They'll Thank You For

Survey says: "Sitting through software training is painful".

Knowing how to use MS Office and knowing how to train people to use it are two different things. Download this Special Report and discover how to choose a trainer that leaves your employees feeling useful.

  • Claire Langfield, Executive Assistant

    Chippewas of Rama First Nation

    The majority of my computer training focused on Publisher. I have received positive comments and feedback from several of my colleagues on the changes between my first attempt and current expertise creating the monthly internal newsletter for my department. They enjoy the updated format and the way in which the information is presented. 

    Deborah assisted me through a learning curve, as I had not previously had any exposure to this program prior to joining Rama. She also provided me with a refresher course on PowerPoint and Excel.  Deborah is a patient teacher and tailored the training to suit my job requirements.