Ads
related to: What can you do with Google Sheets?Here is the Google Sheets app everyone is using. You have to get one on your phone. Download Google Sheets for Free, Get Latest Version Now. 100% free and with no viruses.
Download Google Sheets following our review. Google Sheets App, Features, Information, Pros, Contras & Download Links
Embedded spreadsheets for websites, web apps and blogs. Lightweight, easy to use and free!
Search results
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as...
- Switching to Sheets From Microsoft Excel
Share directly from Sheets: Save automatically using...
- Google Sheets
See what you can do with Google Sheets. Collaborate on data,...
- How to Use Google Sheets
How to use Google Sheets. Switch to Google Sheets from...
- Switching to Sheets From Microsoft Excel
- Contents
- How to Use Google Sheets
- How to Use Google Sheets: The Working Environment
- How to Use Google Sheets: Data and Basic Formulas
- How to Use Google Sheets: Killer Features
- How to Use Google Sheets: Intermediate Techniques
- Next Steps
What is Google Sheets?
Google Sheets is a free, cloud-based spreadsheet application. That means you open it in your browser window like a regular webpage, but you have all the functionality of a full spreadsheet application for doing powerful data analysis. It really is the best of both worlds.
How is it different to Excel?
No doubt you’ve heard of Microsoft Excel, the long-established heavyweight of the spreadsheet world. It’s an incredibly powerful, versatile piece of software, used by approximately 750 million – 1 billion people worldwide. So yeah, a tough act to follow. Google Sheets is similar in many ways, but also distinctly different in other areas. It has (mostly) the same set of functions and tools for working with data. In fact, some people mistakenly call it “Google Excel” or “Google spreadsheets.” W...
Why use Google Sheets?
How’s this for starters: 1. It’s free! 2. It’s collaborative, so teams can all see and work with the same spreadsheet in real-time. 3. It has enough features to do complex analysis, but… 4. …it’s also really easy to use. Need more convincing? Here are 5 more reasonsfrom Google themselves.
Changing the size, inserting, deleting, hiding/unhiding of columns and rows
To select a row or column, click on the number (rows) or letter (columns) of the row or column you want to select. This will highlight the whole row or column blue, to indicate you have it selected. To change the width of a column, or height of a row, hover your cursor over the grey line denoting the edge of the column or row, until your cursor changes to look like this: Then click and drag the cursor left or right to change the width of this column. It’s the same process to change the height...
Adding extra rows and columns at end
If you reach the outer edges of a Google Sheet, you’ll notice the rows and/or columns stop. But don’t worry, you can add more. If you’ve scrolled all the way to the bottom of your Sheet (or added that much data), you’ll notice that you’re given 1,000 rows by default. There’s a button to add more rows if you need, either 1,000 as shown, or any number you wish (up to a limit, more on that below). If you reach the right edge of the Sheet, i.e. the last column, then you add more columns in the st...
Adding/removing multiple sheets, renaming them
Super easy! Click the big plus button in the bottom left of your Google Sheet to add a new Sheet(also called a Tab). Why use multiple tabs within your Google Sheet? Well, like a book with chapters on different topics, it can help separate different data and keep your Sheet organized. For example, you might have a Sheet solely to record your global settings (any variables like name, email, tax rate, headcount…) and another for transactional data, and yet another for the analysis and charts. Th...
Different types of data
You’ve already seen different data types in Google Sheets in our basic table. The key point to understand with spreadsheet data is that each cell contains the data itself, anda format applied to that data. For example, suppose a cell contained: 2, or 2.00, or $2, or $2.00 In each case the underlying data is the number 2, but with a different format applied each time. If we add 2 to each of these cells we get back the number 4 in every case (with formatting applied). You’ll notice that currenc...
Doing math on numbers
Easy-peasy, just like you do on a calculator. You click the cell you want to do your calculation in, type an equals sign (=) to indicate you’re performing a calculation and then type in your formula, e.g. Notice how calculation will show in the formula bar (1) as well as in the cell (2). You’ll notice that you get a preview of the answer (in this case, 25) above the formula.
Starting with functions: COUNT, SUM, AVERAGE
Technically you’ve already written your first formula in the section above on math calculations, but really, your formula career begins when you start using the built-in functions (of which there are hundreds!). Returning to our basic table, let’s count how many members we have, what the total monthly fees are and what the average monthly fees are. COUNT Click on cell B8, type an equals (=) and then start typing the word COUNT. You’ll notice an auto-complete menu comes up showing all of the f...
Let’s see some of the unique, powerful features that Google Sheets has, as a cloud-based piece of software.
Freeze panes
This is one of the most useful tricks you can learn in Google Sheets, which is why I’m recommending you learn it today. Sooner or later you’ll work with a table of data that continues beyond the area you see on the screen (right now for example, I can see as far as row 26, but it depends on your screen size and other factors). When you scroll down to look at data further down in your table, you lose the column headings off the top of your screen, and therefore can’t see the context of your co...
Relative/Absolute references
This is arguably the hardest concept to grasp in this tutorial. If you understand it and can apply it, then you have a really good understanding of how spreadsheets work and you’re well on your way to being a skilled user. Suppose you have some data in cell A1 and you enter the following formula into cell B1: This formula will retrieve whatever data is in cell A1 and show it in cell B1. Now copy the formula (Cmd + C on a Mac, or Ctrl + C on a PC) and paste it (Cmd + V on a Mac, or Ctrl + V on...
Working with formulas across sheets
Sticking with the topic of referencing other cells for the moment, how does one go about linking to data on a different Sheet? Returning once again to our basic gym membership table for dead famous authors, in Sheet 1, let’s retrieve the table heading and print it out in Sheet 2 with this formula, entered into cell A1 on Sheet 2: Note the exclamation point at the end of the reference to Sheet1, i.e. Sheet1! Now let’s do a simple sum of data on Sheet 1, but show our answer on Sheet 2. In cell...
The old adage “Practice makes perfect” is as true for Google Sheets as anything else, so hop to it! Keep up-to-date with new articles, course launches and exclusive offers, by signing up for my Google Sheets newsletter, and get my free Google Sheets ebook with 100 tips. When you’re ready, check out the intermediate and advanced Google Sheets tutori...
People also ask
What can you do with Google Sheets?
How do I create a spreadsheet in Google Sheets?
How can I Share my Google Sheets?
Is Google Sheets free?
- The next time you need to create a new spreadsheet, save yourself the trouble of opening up the main Google Sheets site and clicking through the commands there.
- Sheets has plenty of keyboard shortcuts, but one series that’s especially worth noting is the collection of commands that quickly insert the current date and/or time wherever you want: Hit Ctrl or Cmd and the semicolon key to add the date, Ctrl or Cmd along with Shift and the semicolon key to add the time, and Ctrl or Cmd along with Alt and Shift and the semicolon key to add the date and time together.
- Google Sheets’ fast-formatting shortcuts are also worth remembering. With the right combination of keys, you can format any cell or selection of cells however you want, without having to dig around in menus.
- You can even create your own personalized shortcut within Sheets to perform a complex series of custom actions with a single command. Open the Tools menu, select Macros, and then select Record macro.
Home. Web. The Beginner's Guide to Google Sheets. By Brady Gavin. Published Jun 17, 2019. Want to learn the basics to Google Sheets? With this beginner's guide, you'll be able to do everything from sharing Sheets to automating tasks with macros in no time at all. Quick Links. What Is Google Sheets? How To Sign Up for an Account.
Sep 1, 2021 · Get more out of Google Sheets with these tips. Learn how to quickly clean up your spreadsheets, clean up your data, apply filters, visualize data, send an email from a cell, and more. Learn a whole range of tips that will save you time and become a Google Sheets power user.
Ads
related to: What can you do with Google Sheets?am5.com has been visited by 100K+ users in the past month
Here is the Google Sheets app everyone is using. You have to get one on your phone. Download Google Sheets for Free, Get Latest Version Now. 100% free and with no viruses.
mobexer.com has been visited by 100K+ users in the past month
Download Google Sheets following our review. Google Sheets App, Features, Information, Pros, Contras & Download Links
