1. Launching Google Sheets
After logging in, click on the Google Apps icon in the top right corner of your screen. A drop-down menu will appear.
Scroll down and select “Sheets” to get started. You can also access the sheets through Google Drive. Click “Plus New,” “Google Sheets,” and then “Blank Spreadsheet.”
When using Sheets, Google Drive automatically saves everything as you go. Just make sure you are connected to the internet.
2. Creating a Spreadsheet
You will be presented with a blank sheet and other template options. Google Sheets offers ready-made templates for personal and business use, such as invoice templates, weekly planners, and expense reports. We will start with a blank sheet. To name your sheet, click “Untitled Spreadsheet” and type a name.
Select the location of your file by clicking on the folder icon. You may select an existing Google Drive folder or make a brand-new one. Each document is made up of one sheet.
You’ll see it below where it says “Sheet1”. You can have multiple sheets in each document. To add a new one, click the “+” icon. Double-click “Sheet 1,” enter a new name, and then hit Enter to rename your sheet.
Click the arrow next to the title to see more ways to organize your sheet. Your spreadsheet may be copied to another spreadsheet or duplicated. To keep certain sheets in a document private, you can enable a password by clicking here. You can also change the color of your sheet by hovering your cursor over “Change Color” and then selecting one.
3. Importing Files
To import data into your sheet, go to the top menu, click “File” and then “Import.” A pop-up menu will appear, and you’ll be presented with options for where you can upload your file.
Let’s upload the excel file from our computer. In the “Choose file from your device” box, click “Upload.” After choosing your file, click “Select.”
You will be prompted by Google Sheets to choose the format of your submitted data. You can create a new spreadsheet, change the data in a selected cell, or change the entire spreadsheet. Picking “Create a new spreadsheet” is what we’ll do.
You need to make sure your Excel file is converted to make sure it works properly in Google Sheets. To do this, go to the Google Drive settings tool, click “Settings,” then click the box next to “Change uploads.” Your files will now be automatically converted in the future.
4. Columns, Rows, and Cells
A sheet consists of cells, columns, and rows. Columns are indexed alphabetically at the top and rows numerically at the bottom. By clicking on its letter or number, each column or each row may be selected. You can double-click a cell, type some information, and press Enter. You’ll need to know which cell your data is in when utilizing utilizing formulae in Google Sheets.
Each cell is named by the column letter followed by the row number. Let’s click on that cell. Column “G” is highlighted at the top. Row “9” is highlighted on the left. “G9.” You can select multiple cells, which is useful when you need to create formulas or move cells around. Click a cell and drag your cursor over other cells to select the group. Let’s select all our cost values.
We’ll click on C5 and then drag it down to C13. Once you’ve made a choice, you may move your mouse over the edge of the choice until the grab symbol appears. You may drag and click to reposition your cells. When using formulas in Google Sheets, you may need to refer to a group of cells that you are selecting. This is called a limit. This range will be called “C5:H13”.
5. Using Formulas
You can use basic formulas in Google Sheets. Select the cell where you wish to see your answer to develop a formula. At the top of your screen, click the white bar next to the “fx” icon. This is where the formulas for each cell are stored. You will be able to write as well as edit formulas here.
Let’s use a formula to calculate how much stock we have. First, double-click where you want the total, and then type the equation in the fx bar. Always start a formula with an equal sign followed by the formula statement. Type “SUM” after the “=” in capital letters, then enter the range after the “(“. Our range is D5 to D13 because those are the numbers we want to total).
So we’ll type “D5:D13” followed by the closing brackets to complete the equation. Press Enter. If the formula is entered correctly, the total will be displayed in the cell immediately. If you made a mistake, maybe you typed something wrong, an error symbol will appear, like this. Then you should go back to your FX bar, and you can edit it until it’s just right. You can learn how to create other formulas by learning the language of Google Sheets.
6. Creating a Header
Create a header so that it stays at the top of your sheet when you scroll down. Hover your mouse over the gray line below the top left corner cell, and it will turn blue. Click it and drag it past the header cell. All cells in the first row are now headers. You can use the same method to lock cells in a column. Customize by clicking on your header and using the format icons at the top of your page.
7. Inserting a Chart
First, highlight the data you want to use in your chart, then go to “Insert” and click “Chart.” Your chart will appear with an editing window. To change from a 2D bar chart to a different graph style, select “Chart Type” and choose the design you want. You can add series to your chart by selecting “Add Series”. To delete it, click the three dots and then select “Remove”.
For more ways to modify your chart, click the “Customize” tab. To change your background color and format your chart, click “Chart Style” and select your preferences.