gsuite.google.com/learning-center sheets.google.com

Learning Center

Sheets Cheat Sheet Create and simultaneously edit spreadsheets with your team, right in your browser. Analyze data with charts and filters, handle task lists, create project plans, and much more. All changes are saved automatically.

1 Customize your spreadsheet and data.

©2017 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA

1

gsuite.google.com/learning-center sheets.google.com

Learning Center

Sheets Cheat Sheet

2 Work with rows, columns, and cells.

Add rows, columns, and cells—Select a cell or block of cells. Then, on the menu bar, click Insert and choose where to add the row, column, or cells.

Delete or hide rows and columns—Right-click the row number or column letter and select Delete or Hide. Delete a cell or a block of cells—Select the cells you want to delete. Click Edit > Delete cells and shift up, or Edit > Delete cells and shift left. Move rows and columns—Click the row number or column letter to select it. Then, drag it to a new location. Freeze header rows and columns—Keep some data in the same place as you scroll through the rest of your spreadsheet. On the menu bar, click View > Freeze and choose an option.

©2017 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA

2

gsuite.google.com/learning-center sheets.google.com

Learning Center

Sheets Cheat Sheet

3 Click

Share

to share your spreadsheet and then choose what collaborators can do. They'll also receive an email

notification.

Share or unshare

Edit content directly

Add comments

Can edit







Can comment







Can view







4 Collaborate with your team in real time.

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 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.

©2017 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA

3

gsuite.google.com/learning-center sheets.google.com

Learning Center

Sheets Cheat Sheet

6 Work with functions Your most important Excel functions exist in Sheets, too. Here’s a few of the things you can do. 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.

©2017 Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, USA

4

Sheets Cheat Sheet - G Suite

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 ...

100KB Sizes 3 Downloads 277 Views

Recommend Documents

Google+ Cheat Sheet - G Suite
3 Find or follow people. 4 Follow or create collections, which group posts around a topic. Learning Center gsuite.google.com/learning-center.

Groups Cheat Sheet - G Suite
1 Access your groups, or create new ones. Switch from public groups to ... Change your Groups settings Edit membership settings, email subscriptions, update ...

Keep Cheat Sheet - G Suite
Create and share notes, lists, and reminders. 1 Create notes, lists, and reminders. 2 Organize notes with colors and labels. Learning Center.

Slides Cheat Sheet - G Suite
This is a great way to create templates. Import slides—Add slides from ... Email as attachment—Email a copy of your presentation. 4 Click. Share to share your ...

Hangouts Chat Cheat Sheet - G Suite
Send messages to individuals or groups, set up rooms for project teams, and have multiple conversations on different topics inside rooms. 1 Send direct messages to an individual or a group. 2 Create a room. 3 Work with Chat. Learning Center gsuite.go

Sites Cheat Sheet - G Suite
Build internal project hubs, team sites, and public-facing websites. 1 From Drive, click. NEW. > More > Google Sites. 2 Customize your site and home page.

Gmail Cheat Sheet - G Suite
Work faster and collaborate better with powerful email features. Create and send email, reply to threaded email conversations, and organize your inbox. 1 Click ...

Docs Cheat Sheet - G Suite
Publish to web—Publish a copy of your document as a webpage, or embed your document in a website. Learning Center gsuite.google.com/learning-center.

Calendar Cheat Sheet - G Suite
invite, join a video call or meeting, or edit the event. 3 Add more people or propose a ... Learning Center gsuite.google.com/learning-center calendar.google.com.

Cloud Search Cheat Sheet - G Suite
1 Search across Google products. Search results' details: Gmail. Email. Calendar ... Online forums and email-based groups ... sales OR marketing sales | ...

Team Drives Cheat Sheet - G Suite
Files in a Team Drive belong to the team instead of an individual. Even if members leave, the files stay exactly where they are so your team can continue to ...

Inbox Cheat Sheet - G Suite
1 Click Create to create email and reminders. 2 Click an email to read, print, or reply to it. 3 Work with email. Feature. Description. Bundles. Group similar email ...

Drive Cheat Sheet - G Suite
https://www.google.com/drive/download. Open the Drive folder on your desktop. Mobile and tablet devices. Install the Drive app from the Play Store (Android) ...

Forms Cheat Sheet - G Suite
Create, edit, and update forms and quizzes—all from your mobile or web browser. Manage event registrations, create a quick opinion poll, and much more with ...

Hangouts Meet Cheat Sheet - G Suite
Hold video meetings worldwide with several people at once. Join impromptu meetings on the go, virtual training classes around the world, remote interviews, ...

Switching to Sheets from Excel - G Suite
6 ways to control visibility. Specific people or .... plus (+) sign and an email address (such as ... 6 Summarize data with charts and graphs in your spreadsheet.

git cheat sheet - Cheat-Sheets.org
git clone ssh://[email protected]/repo.git. Create a new local repository. $ git init. LOCAL CHANGES. Changed files in y our working directory. $ git status.

CSS3 Cheat Sheet - GitHub
Border Radius vendor prefix required for iOS

HTML5 Canvas Cheat Sheet [.pdf] - Cheat-Sheets.org
HTML5 Canvas Cheat Sheet v1.1. Page 2. Colors, styles and shadows. Attributes. Name. Type. Default. strokeStyle any black. fillStyle any black. shadowOffsetX.

gitchangelog Cheat Sheet - GitHub
new: test: added a bunch of test around user usability of feature X. fix: typo in spelling my name in comment. !minor. By Delqvs cheatography.com/delqvs/. Published 14th August, 2017. Last updated 14th August, 2017. Page 1 of 1. Sponsored by ApolloPa

Cheat sheet Services
Create a Version of your current container, and test it out on your live site by using Preview or Debug mode. Navigate around your site and see if the rules and tags are acting the way you expect. Migrate by removing hard-coded tags: You're almost re