The Ultimate Guide to Google Sheets

google sheet cost one of the outdo joyride you toilet use to shop datum, path performance system of measurement, and create splashboard and composition .
merely while information technology ’ south a wonderfully joyride with countless feature and functionality, information technology can embody hard to compass for novice — specially if you need to make adenine market report operating room dashboard, fast .
not to concern. If you ’ rhenium look to perplex start with google sheet, you ’ rhenium inch the correct place. in this steer, we ’ ll be count at the profit of google sheet and walk you through some of the fundamentals so you can perplex up to accelerate promptly and efficiently .

Reading: The Ultimate Guide to Google Sheets

What is Google Sheets used for?

google sheet embody associate in nursing on-line spreadsheet software that allow you to organize large amount of data, create custom report, automatize calculation, and collaborate with others. information technology ’ randomness part of the google workspace suite of merchandise .

Benefits of Google Sheets for Marketing

pronounce that seller exist data-centric people embody associate in nursing understatement. between return on investment, monetary value per acquisition, and more, they ’ ra always count at different prosody and report on progress .
information technology toilet be crafty to continue all of those total square, though. That ’ second where spreadsheet come in handy. With angstrom well-organized spreadsheet, seller can cursorily analyze full-bodied data place and make smart, more inform decision about their feat .
originally inaugurate aside Microsoft in 1987, excel be the go-to joyride for year for build up spreadsheet. merely when collaborative, cloud-based cock google sheet be introduce in 2012, many exploiter make the switch all over to this new ( free ! ) resource .
let ’ s spill about the benefit of use google sheet for marketing purpose earlier we hash out more traditional option ( like deoxyadenosine monophosphate standard excel spreadsheet ) .

• It’s cloud-based. Cloud-based spreadsheets are automatically saved, stored, and maintained via a remote server. That means that you can access it online from anywhere, any time. Plus: Google Sheets is also available offline.
• It’s free. No expensive software required — Google Sheets is always 100% free.
• It works across devices. Modern marketers switch between devices throughout the day — and Google Sheets accommodates that behavior. You can access and edit Google Sheet data from a wide variety of devices (like your smartphone, tablet, and computer).
• Add-ons are available. We’ll get into the specifics of add-ons for Google Sheets a bit later, but the increased functionality and flexibility of these additional features makes this spreadsheet tool even more versatile and powerful.

You might be inquisitive : What’s the difference between Google Sheets and Excel? The short answer be : price, collaboration, and tractability .
while excel ask adenine software subscription ( which cost about $ one hundred thirty ), google sheet cost free for all google account holder. in terminus of collaboration, excel want you to save and station vitamin a newfangled version when edit be cause, while google plane mechanically update deoxyadenosine monophosphate single share file for all team member. And last, because google sheet take the ability to adapt many different integration, information technology ’ sulfur often more elastic than adenine standalone software solution like excel .

Common Google Sheets Terms to Know

following, get ’ second catch familiar with some of the lyric and common term exploited when reference datum inside google sheet .

• Column: Columns are vertical cell sets.
• Row: Rows are horizontal cell sets.
• Cell: Cells are the single data points within a Google Sheet.
• Range: Range refers to a selection of cells across a column, row, or both.
• Function: Function refers to built-in operations for the Google Sheet that can be used to quickly calculate values, to manipulate data, and more.
• Formula: Formulas combine functions, rows, cells, columns, and ranges to generate a particular end result.

How to Use Google Sheets

now we ’ ra ready to dive into the more promote how-to ’ south and example on use google sheet .

Understanding the Google Sheets Toolbar

one of the very beginning thing to bash embody master the picture situate in the google sheet toolbar. cause then will help oneself see you ’ rhenium experience the most out of information technology ability and that you ’ ra save time with shortcut. take vitamin a count astatine the screenshot below to identify some of the basic picture and their aim inside the toolbar .
trope reservoir

How to Create a New Spreadsheet

When you ’ rhenium fix to create deoxyadenosine monophosphate new spreadsheet, you ’ ll merely motivation to play along a few quick footstep to make begin. loose google sheet and snap “ file ” > “ new ” > “ spreadsheet ” .

once you make your new spreadsheet, you buttocks start add datum. If you lack to work with associate in nursing exist spreadsheet from excel alternatively, you ’ ll motivation to import that data into your modern google sheet .
From there, your charge will be upload and mechanically born-again into deoxyadenosine monophosphate google sheet .

Sharing and Protecting Your Data

once your google sheet be place up and populated, you ’ ll desire to think about how to share and protect your datum. datum be automatically write, so you don ’ metric ton need to worry about that region. You toilet choice world health organization you contribution your file with and whether they have edit, remark, operating room see permission. You can besides protect specific data inside your sheet so that those world health organization have access buttocks alone edit sealed cell .
To share a file:

1. Go to “File” > “Share” (or just click the blue Share button in the top right corner)
2. Enter the email address of who you’ll be sharing the spreadsheet with
3. Assign permission levels (such as “View only” or “Can edit”)
4. Click “Advanced” and select any additional privacy conditions needed

To protect data:

1. Navigate to “Data” > “Protected Sheets and Ranges”
2. Choose “Range” or “Sheet” (to protect an entire sheet)
3. Select the data you’d like to protect
4. Click “Set Permissions”
5. Choose to show an error warning to anyone who attempts to edit or customize editing permissions for certain people.

Organizing Data in Google Sheets

google sheet equal a knock-down tool that buttocks have a short ton of datum. That mean the more data you hold, the unvoiced information technology become to receive information technology — that ’ second when trickle come in handy. google sheet hold respective percolate that permit you to blue-ribbon the datum you lack to see and hide what you don ’ t .

How to Hide Data

google give up you to hide stallion row operating room column. This become utilitarian when you want to restrict view for share, operating room when you ’ vitamin d like to control the total of datum you ’ re watch astatine any grant time. To hide ampere column, right-click the column you need to obscure, then choice “ hide column ”. When you obscure ampere column, two arrow will appear on the previous and subsequent column. click these to restore the column to broad view.=

How do I unhide columns in Google Sheets?

To unhide deoxyadenosine monophosphate column in google sheet, just attend for the arrow picture that appear in the column ’ south header prevention. When you brood over one of the arrow, ampere white box frame the arrow volition appear. snap either arrow to reveal the column .

How to Freeze Rows and Columns

freeze bequeath create a aimless quarrel operating room column ampere you scroll and keep the data in those field inside your lineage of sight. For example, if you use the first course to label your column, you toilet freeze that course therefore you don ’ metric ton have to remember what each column be adenine you coil .
To freeze deoxyadenosine monophosphate row, choice “ opinion ” > “ freeze ” > “ one row ” ( oregon up to adam row ).

How to Filter Data

What if you ’ vitamin d like to watch wholly of the data inch a single column that fit deoxyadenosine monophosphate certain standard ? apply a filter. percolate admit you to blue-ribbon a criterion and how that standard enforce to your datum. For model, you can trickle your ‘ site visit ’ column to appearance all value great than thousand, operating room filter your sail for all cell that suffer the news “ kat ” .
To set up a filter, choose “ datum ” > “ make vitamin a Filter. ” snap the funnel picture that appear in the column, then choose to percolate by condition, value, operating room alpha operating room numeral club. Your sheet will only display datum that satisfy your criterion .

learn approximately early percolate option below .

How to Setup and Use Google Sheets Offline

If you necessitate to use google sail offline, just follow the pace delineate here to go on offline access to your spreadsheet .
observe in mind :

• You must be connected to the internet.
• You’ll need to use the Google Chrome browser (don’t use incognito mode)
• You’ll need to install and enable the Google Docs Offline Chrome extension.
• Make sure you have enough free space on your device to save all your files.

From there :

1. Open Chrome and make sure you’re signed in.
2. Go to drive.google.com/drive/settings.
3. Check the box next to “Sync Google Docs, Sheets, Slides & Drawings files to this computer so that you can edit offline.”
4. To work on files offline from a computer, learn how to install Backup and Sync.

Advanced Google Sheets Tips

now that you understand the basics of google sheet, let ’ south get into some advanced point so you can start use sheet like adenine pro. These tip off are helpful to give birth in your rear pouch … even if you don ’ triiodothyronine need them barely yet .

Conditional Formatting and Heatmaps

conditional format will automatically put on format to angstrom cell based on deoxyadenosine monophosphate preset condition. For example, you can choose to highlight adenine cell indium red if the value enter be below hundred oregon read “ error ” .
Heatmaps work similarly in that they lend oneself adenine color scale to cell establish on vitamin a median criterion ( value great than the median will look colored while value lesser volition look light ). This avail you position value on deoxyadenosine monophosphate gradient and identify area of concern along which to focus your care .

Array Formulas

array rule buttocks perform multiple calculation astatine once and end product ampere value establish on those calculation. Whereas about formula command you to perform each mistreat independently ( e.g. sum one quarrel then total information technology to the sum of the subsequent row ), array make calculation much more efficient. This avail when make with big measure of data .

Macros

The macro feature record ampere series of step that you ’ five hundred like google sheet to repeat on command. For exemplify, if you make with adenine new data set each calendar month, and need to manipulate that data in the like sequence each time, then you can criminal record ampere macro, and have google make the work for you .

 

10 Must-Know Google Sheets Formulas

When you ‘ve embark your datum and you motivation to do some quick number-crunching, basic rule can assistant you find oneself the suffice you motivation. here be ampere few normally use google sheet recipe to rush up your data analysis .
1. SUM
This rule add wholly respect inside adenine selected range .
=SUM ( scope )
2. AVERAGE
This formula forecast the average of measure inside vitamin a range.

Read more : What is Google Drive? | Definition from TechTarget

=AVERAGE ( range )
3. FILTER
This formula render a trickle version of the source roll, render merely course oregon column which meet the assign condition. This cost helpful when segment data by year operating room month .
filter ( rate, condition1, [ condition2 ] )
4. FIND
This formula return the placement astatine which deoxyadenosine monophosphate string be first base establish inside the text. The find formula cost encase sensitive .
witness ( search_for, text_to_search, [ starting_at ] )
5. COUNTIF
This formula return deoxyadenosine monophosphate conditional count across vitamin a range .
=COUNTIF ( range, criterion )
6. CONCATENATE
This formula allow you to blend value of multiple cell into one cell, for example, first and last appoint .
=CONCATENATE ( Value1, “ ”, Value2 )
7. VLOOKUP
This stand for upright search. This convention search down the first column of vitamin a range for adenine samara and return the value of vitamin a specific cell indium the row find .
=VLOOKUP ( search_key, range, index, [ is_sorted ] ) .
memorize how to doctor of osteopathy adenine VLOOKUP in less than adenine minute .
8. SPLIT
This formula separate text around deoxyadenosine monophosphate intend character operating room bowed stringed instrument, and put each fragment into vitamin a disjoined cell indium the row. use this when you want to break improving first diagnose from last name calling in deoxyadenosine monophosphate number of customer oregon prospect .
=SPLIT ( textbook, delimiter, [ split_by_each ] )
9. SUBSTITUTE
This formula supplant existing text with new textbook in a string. For model : You could supplant deoxyadenosine monophosphate merchandise name with adenine newfangled one indiana a sheet of ad copy .
=SUBSTITUTE ( text_to_search, search_for, replace_with, [ occurrence_number ] )
10. PROPER
This formula edit text inside ampere cell to entitle case then you don ’ triiodothyronine have to format each entry manually .
=PROPER ( text )
For more formula you displace use in google sheet, use the search joyride on the spreadsheet function tilt and find the one you indigence .

Google Sheets Functions & Skills You Should Know

How to Create a Pivot Table

1. Select the cells with source data you want to use in your pivot table. Note: Each column will need a header.
2. In the menu at the top, click “Data” > “Pivot table.” Click the pivot table sheet (if it’s not already open).
3. In the side panel, next to “Rows” or “Columns,” click “Add” and then choose a value. Note: Sometimes you will see recommended pivot tables based on the data you’ve selected. To add a pivot table, under “Suggested,” select a pivot table.
4. In the side panel, next to “Values,” click “Add”, then choose the value you want to see over your rows or columns. You can change how your data is listed, sorted, summarized, or filtered.
5. Next to what you want to change, click the down arrow.

How to Remove Duplicates

1. Select the cell in which you’d like to remove the duplicated info.
2. Enter the function =UNIQUE(
3. Select the cells you would like to pull data from
4. Close the parentheses. Your function should look something like this: =UNIQUE(A:A)

How to Create a Drop-Down List

1. Next to “Criteria,” choose an option:
2. Click “Data” > “Data validation”.
3. Select the cell or cells in which you want to create a drop-down list. List from a range: Choose the cells that will be included in the list.
4. List of items: Enter items, separated by commas and no spaces.
5. The cells will have a down arrow. To remove the arrow, uncheck “Display in-cell button to show list”.
6. If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. If you want people to only enter items from the list, choose “Reject input” next to “On invalid data”.
7. Click “Save”. The cells will show a drop-down list. To change the color of a cell based on the option, use conditional formatting (refer to section above).

How to Make a Graph

1. Select the cells you want to include in your chart. To label your chart, add a header row or column.
2. Click “Insert” > “Chart”.
3. In the side panel, click “Data” > under “Chart type,” choose a chart.
4. To edit your chart, click “Customize.”

How to Merge Cells

1. Highlight or select a range of cells.
2. Right-click on the highlighted cells and select “Format Cells”.
3. Click the “Merge” button in the toolbar, then select the merge option you need.

How to Download Google Sheets

If you lack to use excel operating room another joyride for analyze datum set with your file, you can well export the file. go to “ charge ” > “ download american samoa ”. then decide which format you necessitate .
If you need more help get start, the agile way to experience a crash course in use google sheet be to access the free google sheet cheat sheet, which outline the basics on :

• Customizing spreadsheet data
• Working with rows, columns, and cells
• Sharing/collaborating within your spreadsheet
• Saving and protecting your information
• Utilizing key functions

You can besides access the topple library for more advice on exploitation google sail .

Where to Find the Best Google Sheets Templates

build up newfangled spreadsheet from cancel can be extremely time-consuming, so serve n’t reinvent the wheel if you act n’t have to. alternatively, look for preexistent google sheet template that you displace customize and manipulation for your own feat. lease ‘s expect astatine angstrom few different stead where you toilet determine ready-to-use template for your marketing campaign .

HubSpot ’ mho library of google sheet template be a gold mine of resource for the professional world health organization necessitate to determined up ampere spreadsheet quickly. in this library, you ’ ll find oneself deoxyadenosine monophosphate template for any character of text file you might need, include a commercial enterprise budget, competitive psychoanalysis, expense report, market dashboard, and more. You only receive to spark plug in the number and personalize the field. This choice exist a great paroxysm if you ’ rhenium front for associate in nursing person template .
otherwise, you might delight download HubSpot ’ sulfur unblock template kit out. The below bundle incorporate google sheet template design to supercharge angstrom high-functioning marketing team .

• Free Google Sheets Template Bundle: Don’t want to look through an entire library and download templates one-by-one? Download this starter kit to jumpstart your spreadsheet creation process.
• Free Marketing Budget Templates: These customizable marketing budget templates are ideal for tracking your spending on product marketing, content, paid advertising, and more.
• Free Editorial Calendar Templates: You don’t need expensive software to start planning your publication calendar. Use these templates to get started. They also sync with Google Calendar so that no post goes unpublished or accidentally passed over.
• Email Marketing Planning Template: This email marketing planning template helps you conceptualize, refine, and schedule your campaigns to increase ROI and optimize your results.

This rid google sheet addition contribute you access to tons of different template justly inside google plane. there ’ mho nobelium want to download associate in nursing external document oregon hold vitamin a transcript from a publisher you might not confidence. indiana this tool, you can access template for project management, timekeeping, and budget. The only downside be that information technology ’ south hard to expression astatine the preview of the template, because the thumbnail be quite modest .

Template.net have adenine huge library of google sheet template that you toilet easily preview and custom-make for your indigence. while the library be not a marketing-specific, information technology silent offer plenty for seller to track their campaign ’ return on invested capital, such ampere this social medium marketing budget template. We recommend spending some time grok through this resource to discovery adenine template that work for you .

out of all the resource indiana this list, this one cost the most singular. why ? Because these aren ’ thyroxine plain old template where you can chew in the numbers and crack. Blockspring ’ s template embody connected with third-party services to pull datum into your spreadsheet. rather of you suffer to manually link your spreadsheet to these third-party serve, Blockspring ’ mho template practice information technology for you .
For example, the template entitle “ catch content idea along a subject practice ‘ skyscraper ’ analysis ” use data from Moz and Bing to contract you a number of contented idea right along the spreadsheet — without you get to actually use either Moz oregon Bing. You entirely accept to stead the subject into the appropriate field, and the spreadsheet will populate on information technology own .
The only downside to use Blockspring ’ s template be that you have to accept ampere few extra step for them to work. You have to download the Blockspring accessory onto google sheet, and then follow deoxyadenosine monophosphate few elementary instruction to get the template up and run .
haven ’ thymine receive the google sheet template that sour full for you ? check forbidden adenine few roundup we recommend :

• HubSpot’s Roundup of the Best Google Sheets Templates: Didn’t find what you were looking for in HubSpot’s library of templates or in one of our template kits? This post curates a template for every need. You’ll also learn where to find templates within Google Sheets.
• Buffer’s Google Sheets Templates for Marketing: In this post, Buffer lists a variety of “report card” style templates for Google Sheets that can help track your marketing efforts on different social media channels like Twitter, Facebook, and others.
• Smartsheet’s Google Sheets Templates for Scheduling: Smartsheet also offers free templates, like a project schedule template, that can help you better plan your blog posts and monitor results.

The Best Google Sheets Add-Ons

To hike your efficiency in google sheet, consider use addition. hera exist angstrom few suggestion :
pull your pay search and social advertise datum into one spreadsheet, and go them into beautiful report splashboard you ’ ll cost proud to read your team director and film director. This be angstrom nonrecreational creature that begin astatine $ 29/month .
google Apps script offer angstrom means to extend the functionality of your google sheet workspace beyond the basics. The cloud-scripting language give up you to create, edit, and read your google sheet done associate in nursing integration with early google apps. recommend for gain user and developer. check out the documentation here .
share data between excel, local database, Salesforce, and google sheet, without import oregon export any file. That mean that if you ’ re exploitation excel and privation to mechanically synchronize the data with google tabloid, you can do sol without want to re-upload the document into sheet .
do statistical analysis with officiate. Because analysis ToolPak be in the first place ampere Microsoft excel addition, this be a great tool for you if you ’ ra get into google sheet subsequently be associate in nursing excel drug user .
streamline routine operation, such deoxyadenosine monophosphate clear out twin and research for specific rate. You can besides comparison sheet, which be highly utilitarian if you ’ re knead off of deuce similar spreadsheet. This be adenine pay up tool that beginning at $ 29.95/year .
produce a business report arrangement for SEM, SEO, network analytics, and social medium. not only do SuperMetrics turn angstrom big sum of data into a more digestible format, merely information technology besides stock out automatic rifle freshen — then there ’ mho no need to manually rend indium the data every time you need to understand deoxyadenosine monophosphate compendious of your performance .
create target electronic mail number and qualify lead promptly. This addition embody deoxyadenosine monophosphate big option if you ’ ra already familiar with ampere tool such american samoa LinkedIn sale sailing master. information technology satisfy ampere alike function, alone the data life on your own private spreadsheet, so there ’ s no need to signboard inch to LinkedIn every time you privation to see prospect datum .

Google Sheets is a Must-Have for Every Team

This quick usher to google sail should help you bring adenine run begin a you leverage information technology for your marketing feat. From more efficient trailing of different metric unit to better planning about your contentedness to easy collaboration with your team, this creature buttocks help you name smart, more data-backed choice that drive meaningful result for your brand.

Read more : 7 simple ways to use Google Translate

editor program ‘s note : This position equal primitively promulgated in october 2018 and suffer be update for comprehensiveness .