Call Us!
Sales: (604) 239-4283
|
Get Support
|
info@compunet.ca
IT Support For Vancouver Law Firms IT Services For Vancouver Law Firms Vancouver Legal IT Services
  • Managed It Services
  • Cybersecurity
  • Cloud Solutions
Close
Legal IT Support in Vancouver
  • Architecture
    • IT Management
    • Cloud Solutions
    • Software Support
    • Cybersecurity Solutions
  • Law Firms
    • Technology Management
    • Digital Transformation
    • Software Support
    • Cloud Services
    • IT Security
    • Cybersecurity Management
    • Ransomware Prevention
  • Accounting
    • Managed IT Services
    • Cloud Services
    • Ransomware Removal
    • Ransomware Protection
  • Engineering
    • Managed IT
    • Cloud
    • IT Security
    • Ransomware Removal
  • Cybersecurity Services
    • Microsoft MFA
    • Microsoft 365 Secure
    • Microsoft Office Protect
    • Network Security
    • Endpoint Protection
    • Dark Web Protection
  • About Us
    • How We Work
    • Why Choose Us
    • Case Studies
    • Our Blog
    • Is This You?
    • Five-Star Feedback
    • Careers
    • Referral Program
  • Where We Serve
    • Greater Vancouver
    • Burnaby
    • Langley
    • Surrey
    • North Vancouver
    • New Westminster
  • Contact Us
    105-135 East 15th Street
    North Vancouver, BC V7L 2P7
    (604) 986-8170 info@compunet.ca
    Get Support

Excel for Mac: The Latest Features

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 […]

Start A Conversation

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.

Co-Authoring

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.

Microsoft Excel for Mac

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 Calculations

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.

Conclusion

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.

Contents

  • 1 Co-Authoring
  • 2 New Chart Types
  • 3 Expanded PivotChart Functionality
  • 4 Multi-threaded Calculations
  • 5 Slicers for Tables
  • 6 Sending Feedback to Microsoft
  • 7 Conclusion

Schedule Your No Obligation Initial Consultation Now

Complete this short form and schedule your no obligation 10-minute introductory phone call with Compunet Information. A member of our team will reach out immediately.

Latest Blog Posts

Should Your Vancouver Law Firm Marie Kondo Its Data?
Should Your Vancouver Law Firm Marie Kondo Its Data?
Read More
KeePass Security Exploit
KeePass Security Exploit
Read More
What is the Canadian Equivalent of HIPAA?
What is the Canadian Equivalent of HIPAA?
Read More
Read The Compunet Blog

Architecture

  • IT Management
  • Cloud Solutions
  • Software Support
  • Cybersecurity Solutions

Legal

  • Technology Management
  • Digital Transformation
  • Software Support
  • Cloud Services
  • IT Security
  • Cybersecurity Management
  • Ransomware Prevention

Accounting

  • Managed IT Services
  • Cloud Services
  • Ransomware Removal
  • Ransomware Protection

Engineering

  • Managed IT
  • Cloud
  • IT Security
  • Ransomware Removal

Cybersecurity Services

  • Microsoft MFA
  • Microsoft 365 Secure
  • Microsoft Office Protect
  • Network Security
  • Endpoint Protection
  • Dark Web Protection
Compunet infonech

Compunet InfoTech offers Managed IT Support & Hosted IT Services For Vancouver & Surrounding Areas. Serving Vancouver, Burnaby, Richmond, Surrey, Coquitlam and New Westminster.

105-135 East 15th Street
North Vancouver, BC V7L 2P7

(604) 986-8170
info@compunet.ca

  • About Us
  • Why Choose Us?
  • Media Center
  • Vancouver IT Consulting News
  • Testimonials
  • Greater Vancouver
  • Burnaby
  • North Vancouver
  • Langley
  • Surrey
  • New Westminster

© 2023 Compunet InfoTech. All Rights Reserved.

Sitemap | Privacy Policy | Website Accessibility
Attention North Vancouver Businesses: Are You Worried About Your IT Services Provider?

Get A Free Second Opinion Today from Compunet.

Our comprehensive assessment includes:

  • A thorough analysis of your current IT company’s performance
  • A customized action plan to tackle all operational issues
  • A detailed budget and project plan for seamless execution

Don’t let IT issues hold back your business. Gain the clarity you need to get your IT on the right track. With our no-obligation, risk-free assessment, you have nothing to lose. Contact Compunet now.

Interested?
Schedule Your Initial Consultation with Compunet Today.

Schedule Your Initial Consultation With The Compunet Team.

Fill in your information below to get started today.