Compare Excel 2016 for Mac with Excel 2013 for Windows
The following feature list is not comprehensive, but it will give you an idea of how Excel 2016 for Mac compares with Excel 2013 for Windows.
● Feature is supported
◌ Feature is not supported
Feature | Feature action/button | Excel for Mac | Excel for Windows |
Entering and formatting data | Conditional formatting Data validation AutoComplete Flash Fill | ● ● ● ◌ | ● ● ● ● |
Pictures | Inserting pictures from File Inserting online pictures from within Excel Inserting screen clippings from within Excel | ● ◌ ◌ | ● ● ● |
Filters | Filter Advanced filter Timeline filter | ● ● ◌ | ● ● ● |
Formulas | Formula Builder Functions * AutoComplete Evaluate Formula Watch Window | ● ● ● ◌ ◌ | ● ● ● ● ● |
Add-Ins | Analysis Toolpak Solver | ● ● | ● ● |
Data analysis | PivotTables PivotTable slicers Table slicers Charts PivotCharts | ● ● ◌ ● ◌ | ● ● ● ● ● |
External data | Connect to a SQL Server database with an ODBC driver installed with Excel Connect to other ODBC data sources ** Import data from a text file Import data from a web query Import a file from FileMaker | ● ● ● ● ● | ● ● ● ● N/A |
Macros | Recording macros Running macros | ● ● | ● ● |
Printing | Page Layout view Page Break Preview view Print to PDF | ● ◌ ● | ● ● ● |
Keyboard shortcuts | key shortcuts Control key shortcuts Function key shortcuts Alt key shortcuts Ability to customize shortcuts | ● ● ● ◌ ◌ | N/A ● ● ● ● |
* Excel 2016 for Mac includes all functions that are in Excel 2013 for Windows, except for WEBSERVICE, FILTERXML, and ENCODEURL.
** In Excel 2016 for Mac, this requires downloading an ODBC driver.
No comments:
Post a Comment