This allows you to either tell Microsoft what you liked about Excel for Mac, or tell them what kinds of things they could do better. You can send feedback to Microsoft via the Smiley Face button that appears on the upper right-hand side of the screen. What makes Slicers useful is the easy-to-use button interface and the fact that they don’t just work on PivotTables. Slicers allow users to easily filter out unwanted information so they can immediately focus on what is important to them.
Latest excel for mac for mac#
Slicers for TablesĪnother useful feature that Excel for Mac now supports is Slicers for tables. And perhaps the best part is that you don’t have to do anything special – no settings to change, no options to set – for multi-threading to be implemented. This means that worksheets filled with long, complex calculations will take just a fraction of the time they did in the past. Now, with multi-threading, multiple formulas can be processed at the same time. In the past, each formula was processed one after another. Multi-threaded, simultaneous calculations of spreadsheet formulas is now supported in the latest Excel for Mac release. Timelines can easily be inserted via the Insert menu. If your document has a data component, you can use the Timeline feature to adjust what data is plotted in the PivotChart. This makes PivotCharts much easier to use and far more interactive. Excel works with data from the Bing map engine to create stunning mapped charts.Įxcel for Mac has also updated the functionality of PivotCharts: a PivotChart will immediately adapt to changes in the PivotTable upon which it is based. This allows you to visualize geographically related data overlaid on a map of the region in question, whether it’s world-based, continent-based, or country-based. Now you no longer have to adapt a column chart in order to visualize your histogram data.Īnother impressive addition to the charting capabilities available in Excel for Mac is 2D Map Charts. Histogram charts have been added to the new release, also. The Sunburst chart shows how different pieces contribute to the whole at various levels of abstraction. Sunburst charts, on the other hand, look a little like the classic donut chart but use different levels of rings to allow you to drill down into subcategories. Treemaps allow you to quickly see a hierarchical representation of data using rectangles and allows you to visually compare data for different categories based on the relative size of their rectangles. It is ideal for visualizing data such as revenue coming in, costs going out, and the difference between them.Ĭharts that focus on hierarchies of data are also supported, such as Treemaps and Sunburst Charts. The Waterfall Chart is one of the newly added types. New Chart TypesĮxcel for Mac has also added some new chart types to support even more powerful data visualization. This also makes it easy for you to chat with them from inside Excel. By clicking on their initials, you can see their name and where they are currently editing. Now when someone else is working on the same workbook, the Sharing corner will show you who that person is. You also won’t be forced to work with a read-only copy. You will no longer have to struggle with a “this file is locked message” when someone else is using a file. The latest release of Excel for Mac fully supports the ability for multiple people to work on a document at the same time, also known as Co-authoring. And with these latest features, it has only gotten better. While some spreadsheet power users tend to shy away from the Excel version for the Mac operating system out of fear they won’t be able to do all they are used to, those who have taken the plunge have found it to be every bit as powerful and functional as they need. A new release of Excel for Mac came out in January of 2018, and with it, some very useful features were added to its existing capabilities.
0 kommentar(er)
