Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

 Google Sheets Tutorials

How to Use AutoFill in Google Sheets

When working with data in Google Sheets, you will sometimes want to use formulas and functions to perform calculations on your data. Formulas are mathematical equations you can manually enter into cells to perform calcuations on your data. Functions are pre-written equations that Google Sheets provides to help you perform simple and complex calculations more quickly.

How to Create a Basic Formula in Google Sheets

Step 1: Select the cell where you would like the formula to appear, and enter the = sign.

Each formula needs to begin with the equal sign. The equal sign ( = ) instructs Google Sheets that the information included after the equal sign should be calculated. You can enter the equal sign in the selected cell, or in the formula bar.

Step 1: Select the Chart you want use to create the template

Step 2: Enter the formula arguments

After you enter the equal sign, you will enter the arguments for the calculation. This can be done in a few different ways: Using static variables, using cell references, or using Google Sheets functions.

Static Variable Formulas

Step 2: Static Variable Formulas example

Cell Reference Formulas

Step 2: Cell Reference Formulas example

Formula Using Google Sheets Functions

Step 2: Formula Using Google Sheets Functions example

Step 3: Click the Enter Key

Once, you enter the formula arguements, click the enter key, and the result of the calculation will appear in the cell where you wrote the formula. That is it. Now you have a completed Google Sheets formula. In the next section, we will look at how to apply a custom chart template to a new set of data.

Step 3: Name the template

How to Edit a Formula in Google Sheets

Step 1: Double click on the Cell where the formula is located.

Use your mouse to select the data you would like to include in your chart.

Step 1: Select your chart data

Step 2: Make any changes needed to the formula

Once the chart data is selected, click in the Insert tab to display insert Chart options on the ribbon.

Step 2: Click the Insert Tab

Step 3: Click on the Enter Key

In the Chart section of the Insert tab, move you mouse to the bottom right corner, then click the See All Charts button.

Step 3: Click on the See All Charts button

Step 4: Click on the All Charts tab in the Insert Chart window

In the Insert Chart window, click on the All Charts tab.

Step 4: Click on the All Charts tab in the Insert Chart window

Step 5: Click on the Templates option on the All Charts tab

In the Chart section of the Insert tab, move you mouse to the bottom right corner, then click the See All Charts button.

Step 3: Click on the See All Charts button

Step 6: Select the custom template you want to use, and click OK

Pick the template you want to use from the templates screen and click OK.

>Step 6: Select the custom template you want to use, and click OK

Google Sheets will then apply the template formatting to the new chart.

>Step 6: Google Sheets will then apply the template formatting to the new chart

Topic #2

How to Use AutoFill in Google Sheets




Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Google Sheets Chart tutorials, or consider taking an Google Sheets class with one of our professional trainers.



"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile