Friday, February 17, 2017

Compare Excel 2016 for Mac with Excel 2013 for Windows

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

COMMAND 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