get_appDownload PDF

1

Differences at a glance

In the past, you might’ve used the consumer (such as Microsoft® Office® 2013) version of Microsoft Excel® outside of work. Now that you’re using Google Apps for Work, you’ll find many similar features—and several additional benefits—when you use Google Sheets.

1.1

Feature

excel In Excel
Based on Office 2013

sheets In Sheets

Feature

Real-time collaboration

excel In Excel
Based on Office 2013

  • Add collaborators*
  • See changes as they occur*
  • Add and reply to comments*
  • Chat within the spreadsheet in real-time*

*Excel Online only, requires Microsoft account

sheets In Sheets

  • Add collaborators
  • See changes as they occur
  • Add and reply to comments
  • Chat within the spreadsheet in real-time

Feature

Share your spreadsheet

excel In Excel
Based on Office 2013

  • Email a copy as an attachment
  • Share a link in an email or chat window*
  • Publish on the web*

*Excel Online only, requires Microsoft account

sheets In Sheets

  • Email a copy as an attachment
  • Share a link in an email or chat window
  • Publish on the web
  • Share directly in Sheets
  • Insert your Sheets file in an email
  • Embed in Google Sites

Feature

Set sharing access

excel In Excel
Based on Office 2013

2 sharing access levels*

  • Recipients can only view (view-only access)
  • Recipients can edit (full edit access)

*Excel Online only, requires Microsoft account

sheets In Sheets

4 sharing access levels

  • Can view (view-only access)
  • Can edit (full edit access)
  • Can comment
  • Is owner (transfer ownership)

Feature

Control sharing visibility

excel In Excel
Based on Office 2013

3 ways to control visibility*

  • Specific people
  • Anyone with the link
  • Public on the web (searchable on the web)

*Excel Online only, requires Microsoft account

sheets In Sheets

5 ways to control visibility

  • Specific people or Google Groups
  • Anyone with the link
  • Public on the web (searchable on the web)
  • Anyone in your domain with the link
  • Your domain (searchable in your domain)

Feature

Version control

excel In Excel
Based on Office 2013

  • Access detailed versions of your spreadsheet
  • Revert to an earlier version
  • See who made which changes*

*Excel Online only, requires Microsoft account

sheets In Sheets

  • Access detailed versions of your spreadsheet
  • Revert to an earlier version
  • See who made which changes

Feature

Security and protection

excel In Excel
Based on Office 2013

  • Disable options to forward, copy, or print spreadsheets*
  • Protect spreadsheets and ranges with an encrypted password

*Requires the Windows Rights Management Services (RSM) Client

sheets In Sheets

  • Disable options to download, copy, or print spreadsheets for people with comment or view access
  • Protect spreadsheets and ranges with ACL-based protection
  • Prevent others from sharing spreadsheets

Feature

Create charts and graphs

excel In Excel
Based on Office 2013

  • Line, pie, bar, and area charts
  • Scatterplots
  • Histograms*
  • Maps*

*Requires Microsoft add-in software

sheets In Sheets

  • Line, pie, bar, and area charts
  • Scatterplots
  • Histograms
  • Maps
2

Access your spreadsheets

You can reach Sheets on any computer, smartphone, or tablet. When you change or delete a Sheets spreadsheet from one device, the same change immediately appears on every device so you’re always accessing the most up-to-date version.

2.1

excel In Excel
Based on Office 2013

sheets In Sheets

On the web

excel In Excel
Based on Office 2013

View spreadsheets saved in Microsoft OneDrive™ or Dropbox™ in Excel Online, a scaled-down web version of Excel, at office.live.com.*

*Requires Microsoft account

sheets In Sheets

View your Sheets from any device with an Internet browser, anytime.

If you don’t have Internet access, you can still access Sheets offline.

On your computer

excel In Excel
Based on Office 2013

Open Excel fles from where they’re saved on your computer.

sheets In Sheets

If you’ve installed Google Drive for Mac/PC, go to the Drive folder on your computer to open your Sheets.

On your mobile devices

excel In Excel
Based on Office 2013

Install the Excel app, then open, edit, or share an Excel spreadsheet stored in Microsoft OneDrive or Dropbox.

sheets In Sheets

Install the Sheets app, then open, edit, or share any file.

3

Work with spreadsheets

Your most important Excel features exist in Sheets, too.

3.1

Customize your spreadsheet and data.

3.2

Work with rows and columns.

  1. Add rows and columns Select cells, click Insert, and choose where to add the cells.
  2. Delete or hide rows and columns Right-click the row number or column letter and select Delete or Hide.
  3. Move rows and columns Click the row number or column letter to select it. Then, drag it to a new location.
  4. Freeze header rows and columns Keep some of your data in the same place. On the menu bar, click View. Then, choose an option under Freeze.
Temp Image
3.3

Click Share to share your spreadsheet, then choose what collaborators can do. They'll also receive an email notification.

Share or unshare

Edit content directly

Add comments

Can edit

Share or unshare

Edit content directly

Add comments

Can comment

Share or unshare

Edit content directly

Add comments

Can view

Share or unshare

Edit content directly

Add comments

3.4

Collaborate with your team in real-time.

3.5

Create different versions and copies of your spreadsheet.

Make a copy Create a duplicate of your spreadsheet. This is a great way to create templates.
See revision history See all the changes you and others have made to the spreadsheet, or revert to earlier versions.
Download as Download your spreadsheet in other formats, such as Microsoft® Excel® or PDF.
Publish to the web Publish a copy of your spreadsheet as a webpage, or embed your spreadsheet in a website.
Email as attachment Email a copy of your spreadsheet.

None
4

Work with functions

Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do.

4.1

AVERAGE

Statistical
Returns the numerical average value in a dataset, ignoring text.

AVERAGEIFS

Statistical
Returns the average of a range that depends upon multiple criteria.

CHOOSE

Lookup
Returns an element from a list of choices based on index.

COUNT

Statistical
Returns the count of the number of numeric values in a dataset.

COUNTIF

Statistical
Returns a conditional count across a range.

DATE

Date
Converts a provided year, month, and day into a date.

FIND

Text
Returns the position at which a string is first found within text.

FINDB

Text
Returns the position at which a string is first found within text counting each double-character as 2.

IF

Logical
Returns one value if a logical expression is true and another if it is false.

INDEX

Lookup
Returns the content of a cell, specified by row and column offset.

INT

Math
Rounds a number down to the nearest integer that’s less than or equal to it.

LOOKUP

Lookup
Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.

MATCH

Lookup
Returns the relative position of an item in a range that matches a specified value.

MAX

Statistical
Returns the maximum value in a numeric dataset.

MIN

Statistical
Returns the minimum value in a numeric dataset.

NOW

Date
Returns the current date and time as a date value.

ROUND

Math
Rounds a number to a certain number of decimal places according to standard rules.

SUM

Math
Returns the sum of a series of numbers and/or cells.

SUMIF

Math
Returns a conditional sum across a range.

TODAY

Date
Returns the current date as a date value.

VLOOKUP

Lookup
Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

5

Do more with Sheets

5.1

Work on your spreadsheet when you're offline. Learn more

None
5.2

Edit Microsoft® Office® files on any device, without installing Office. Learn more

None
5.3

Get targeted feedback on a section of your spreadsheet and send an email notification. In the comment text, type the plus (+) sign and an email address (such as "+cassy@solarmora.com"). Learn more

None
5.4

Filter data in shared spreadsheets without changing what collaborators see. Learn more

None
5.5

Create polls, surveys, and more in Google Forms, then see real-time responses in Sheets. Learn more

None
5.6

Use Sheets-only functions to work with imported data from HTML pages, miniature cell-sized charts, historical securities information from Google Finance, and more. Learn more

None

get_appDownload PDF