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. 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. And with these latest features, it has only gotten better.
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. You will no longer have to struggle with a “this file is locked message” when someone else is using a file. You also won’t be forced to work with a read-only copy.
Now when someone else is working on the same workbook, the Sharing corner will show you who that person is. By clicking on their initials, you can see their name and where they are currently editing. This also makes it easy for you to chat with them from inside Excel.
New Chart Types
Excel for Mac has also added some new chart types to support even more powerful data visualization. The Waterfall Chart is one of the newly added types. It is ideal for visualizing data such as revenue coming in, costs going out, and the difference between them.
Charts that focus on hierarchies of data are also supported, such as Treemaps and Sunburst Charts. 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.
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. The Sunburst chart shows how different pieces contribute to the whole at various levels of abstraction.
Histogram charts have been added to the new release, also. Now you no longer have to adapt a column chart in order to visualize your histogram data.
Another impressive addition to the charting capabilities available in Excel for Mac is 2D Map Charts. 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. Excel works with data from the Bing map engine to create stunning mapped charts.
Expanded PivotChart Functionality
Excel 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 makes PivotCharts much easier to use and far more interactive. If your document has a data component, you can use the Timeline feature to adjust what data is plotted in the PivotChart. Timelines can easily be inserted via the Insert menu.
Multi-threaded, simultaneous calculations of spreadsheet formulas is now supported in the latest Excel for Mac release. In the past, each formula was processed one after another. Now, with multi-threading, multiple formulas can be processed at the same time. This means that worksheets filled with long, complex calculations will take just a fraction of the time they did in the past. 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.
Slicers for Tables
Another useful feature that Excel for Mac now supports is Slicers for tables. Slicers allow users to easily filter out unwanted information so they can immediately focus on what is important to them. What makes Slicers useful is the easy-to-use button interface and the fact that they don’t just work on PivotTables.
Sending Feedback to Microsoft
You can send feedback to Microsoft via the Smiley Face button that appears on the upper right-hand side of the screen. 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. The latter not only means you can more easily request new features, but you can send information about specific problems you have encountered. If you’d like to get a response, you can include an email address – but just remember that they don’t have time to respond personally to all the feedback that they receive.
Excel for Mac is constantly evolving to be more like Excel for Windows, and these updated and added features demonstrate Microsoft’s commitment to making that happen. With multi-threading capabilities, coauthoring, new and better charts, and slicers, Excel for Mac users can do even more. And don’t forget to provide your own feedback to Microsoft. This feedback helps the company design more user-friendly apps for its users.
“My passion for quality IT service is at the forefront of my career.”
Lance Skipper Client Engineer
“A day without laughter is a day wasted.”– Charlie Chaplin
Always at your service to provide the highest level of quality support to our customers.
Anthony Firth Client Engineer
“I’m passionate about building and fostering relationships, and finding solutions for success.”
Michael Koenig Client Account Manager
“Enabling IT to become an effective and valuable partner by delivering premier customer service and quality IT solutions achieving business goals.”
Jake Parrott Business Development Manager
“Striving to provide friendly and quality service to our customers”
Ted Rorabaugh Client Engineer
“I help clients stabilize and grow their IT infrastructure so they can focus on growing their core business.”
Josh Wilshire Systems Engineer Team Lead
“Striving to be your trusted adviser and IT teammate in accomplishing all your business goals”
Brandan Bishop Client Account Manager
“I strive to provide the highest level of quality service to our customers.”
Tommy Williams Sr. Hardware Engineer
“I’m driven by the steadfast belief that technology must serve as a business enabler. This mantra has driven 21
Years of successful partnerships.”
Stephen Riddick VP Sales & Marketing
“CSP doesn’t succeed unless your company succeeds.”
Stephen Allen Inventory Manager
“Through my intuition and genuine concern to help others I have built long-lasting relationships with our customers, co-workers and business partners.”
Scott Forbes VP Support Services
“Every day, I work with clients to help plan the future of their businesses.”
Michael Bowman vCIO
“Your IT problems become our IT solutions.”
Mark McLemore Project Engineer
“Managing internal and external operations to ensure that CSP provides quality and reliable customer service .”
Margie Figueroa Business Manager
“Helping customers get the most out of their IT Infrastructure.”
Marc Gillet Project Engineer
“Providing quality internal and externals financial support to our customers and accounting support to CSP.”
Katie Steiglitz Accounting Administrator
“Your satisfaction is our #1 priority.”
Heather Moore Project Manager
“Some call me the CEO. I call myself the Cheerleader for an awesome team!”
William B. Riddick Founder & CEO
“CSP is here to assist you with your IT needs.”
Beth Wylie Inside Sales Manager
Thinking ofHiring A New IT Company?
On What Questions You Need To Ask Before Signing Any Agreement.