Published in Workplace content on 19th March 2019. 6 minute read

14 ways Google Sheets is more powerful than Excel users realise

  • Home
  • 14 ways Google Sheets is more powerful than Excel users realise

Many of us are reluctant to embrace new productivity tools when our employers want to change the technology we use at work. We worry that, even as we move towards a digital workplace that improves team collaboration across the business, we’ll lose access to some features that are key to getting our jobs done.

14 ways Google Sheets is more powerful than Excel users realise

Microsoft Excel “power users” seem to worry more than most about switching spreadsheet applications — but Google Sheets is more powerful than most of them realise. Here are 14 ways Sheets can help you do more:

  1. one-click templates that let you instantly create new formatted spreadsheets — customised with your company branding — for routine reporting tasks.
  2. easy importing from many different formats, including quickly converting text into tabular data, importing a range of cells from another spreadsheet, and importing from structured data sources such as RSS and ATOM feeds as well as CSV files.
  3. easy data capture from colleagues, customers and partners, through Google Forms. Another tool in G Suite, Forms populates Sheets in real time, so you can start analysing data immediately.
  4. fast, seamless importing from third-party applications such as SAP and Salesforce, with the option to build connectors for any application.
  5. grouping rows and columns, so you can hide or show sections, making it easier to focus on just one area.
  6. macros to automate repetitive work, whether that’s cleaning and consistently formatting data across multiple tabs or creating charts and pivot tables.
  7. third-party and in-house add-ons, available from the add-on store, to handle complex tasks like removing duplicates, merging data, normalising values and detecting outliers.
  8. a scripting language, Google Apps Script, that lets you create custom analytical functions or set triggers to kick off actions when data changes in a sheet.
  9. drill down and automatic grouping in pivot tables, to let you quickly access the data being summarised and make it easy to show data by quarters or years.
  10. user-specific filters, known as filter views, that let each person viewing a Sheet organise the data in the way they want without affecting what other users see.
  11. intelligent suggestions for analysis, through the Explore button. You can ask questions using natural language, such as “what’s the average profit by product category?” The Explore area will also suggest charts, pivot tables and formatting to help you quickly get a handle on your data.
  12. seamless collaboration, with everyone able to work on the most up-to-date sheet at the same time. You can hold rich discussions in comments attached to a particular cell — with an easy way to invite people into the discussion — while an activity dashboard lets you see who’s viewed a sheet and makes it easy to directly nudge anyone who hasn’t.
  13. named snapshots of key versions of spreadsheets, so you can quickly look at changes between important milestones. Of course, there’s also a full version history of every change made, who made it and when.
  14. enterprise-grade security to keep your data safe. Alongside all the access controls you’ll find in any of the collaboration tools in G Suite, you can set expiration dates when sharing sheets and prevent people from downloading, printing or copying them.

How cosmetics company, Lush, is using Google Sheets

One business that is benefitting from Sheets is cosmetics company Lush, an Ancoris customer. Managers used to send schedules to staff as email attachments — and send a new attachment each time the schedule changed. Now, everyone can always access the most up-to-date schedule in Sheets, from any device. That saves time for staff, who no longer have to hunt for the most recent schedule, and streamlines the scheduling process for managers.

Working with a Google Workspace Premier Partner

Ancoris is only one of a handful of European Google Cloud partners with the Work Transformation Enterprise specialisation.  Our deployment experts will help you make a smooth transition―for the technology and for the people using it.

A business is only as good as its people – so why not make them extraordinary? Empowering them to work better together not only unleashes their talent and creativity but makes them your competitive advantage. The modern, easy to use applications in Google Workspace make real-time collaboration a breeze. Combine Google Workspace with Chrome Enterprise and you've got the most secure and mobile workplace.

To complement our technical service delivery consultants, we have a dedicated in-house change management and user enablement team to guide you through the process.

If you’d like to find out more about how we can help you to create your digital workplace, why not take a look at some of our customer success stories or talk to our Google Workspace specialists.

10 reasons to leap into a collaborative new world with Google Workspace

Free resources

Please download any of our resources to help with your research and project specifications