After the great progress made with macros in the 2011 release, this is a real letdown.Ī related issue is that some familiar-and useful-shortcuts are now changed or gone. In short, if you need macros, stick to Excel 2011. (Microsoft details is Visual Basic support in a FAQ). Further, you can’t create custom menu commands, as you could in prior versions of Excel. About all you can do is hand-edit a recorded macro.
While you can create and record macros, the macro editor is crippled: there’s no way to insert procedures, modules, etc. If you’re a serious user of Excel’s macro facilities, you are in for a big letdown: Excel’s 2016 support for macros is basically missing.
Select the data you want graphed, click the Recommended Charts button, then browse the mini chart previews to find the one that best matches what you’re trying to say.Įxcel 2016 helps you pick the right chart by analyzing your data and presenting a list of charts you can use to visualize that data.
#ANOVA ON EXCEL FOR MACBOOK WINDOWS#
Again in the interest of cross-platform compatibility, many Excel for Windows shortcuts now work on the Mac, which is quite useful if you regularly work on both platforms.Įxcel also makes charting easier by analyzing your data and letting you select a recommended chart from a convenient drop-down menu. Also included are a number of formulas that were previously found only in Excel 2013 for Windows, improving cross-platform compatibility. If you need to do complex statistical and/or engineering analysis-think Anova, Fourier Analysis, Regression, etc.-you’ll find the Analysis Toolpak invaluable. I say new in quotes because while new to Excel 2016, long-time Excel vets will remember the Analysis Toolpak from the pre-OS X days. Here, only data from 2012, 2013, and 2015 is visible.Īnother “new” feature is the inclusion of the Analysis Toolpak add-on. Slicers let you limit what you see in a pivot table you can add one or more to really refine what you see. In a pivot table showing years of sales by salesperson, for example, you can use slicers to restrict the table to one or more years, or to one or more salespeople. A slicer is a way to limit the data you see in a pivot table. Recipients can (assuming you grant permission) edit your file, even if they don’t own Excel, through Microsoft’s web-hosted Excel app.įans of pivot tables will find a new slicer tool that greatly increases the usability of pivot tables.
#ANOVA ON EXCEL FOR MACBOOK PDF#
Save your file to OneDrive, and you can then use a sharing button to invite people via their email address, copy a link you can then email to others, or send the workbook as either a PDF or native workbook attachment. I don’t miss them at all, as they were redundant and took up screen space.Īlso new is greatly improved sharing. While you could hide these in Excel 2011, they’re completely gone-replaced by the task pane-in Excel 2016. So what’s new and unique to Excel 2016? Quite a few things, starting with the removal of the Standard and Formatting toolbars.
0 kommentar(er)
