Using Basic Formulas in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 11 videos | 45m 20s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 56 users Rating 4.4 of 56 users (56)
This course will focus on manipulating data and performing basic calculations using formulas in Google Sheets. First, discover how to manually select and use formulas in a cell, as well as to get access to the full list of functions available in Google Sheets. You will also see how to copy formulas to quickly fill out a table. Other functions will allow you to rank, count, and round values in a sheet. Google Sheets' functions are useful for manipulating text as well. For example, to replace specific characters or a text string. Finally, learn how to create formulas to generate random numbers and remove whitespace.

WHAT YOU WILL LEARN

  • Get access to the function library to create formulas
    Perform basic calculations with operators and functions
    Re-use formulas to copy values and perform calculations
    Get cumulative totals
    Convert numbers to binary, hexadecimal or decimal formats
    Obtain the quotient and remainder in a division
  • Count a full list of values or specific items in a list
    Rank values and find the smallest or largest values in a list
    Use different functions to round a value
    Use functions to replace characters and remove whitespace
    Use formulas to generate random values

IN THIS COURSE

  • 5m 2s
    The full list of functions available in Google Sheets can be accessed in a number of different ways. As well as being able to view a full list of functions via the Insert menu, Google Sheets offers automatic suggestions when you start entering a formula into a cell. Google has also created a fully searchable functions glossary, which can be accessed via the Google Sheets help portal. FREE ACCESS
  • 4m 7s
    A cell in Google Sheets can act as a calculator, allowing you to perform mathematical equations and calculations. In order to begin using a cell in this way, you to need to start your data entry with an equals sign (=). In this tutorial, you will find out how to perform simple calculations, and even perform multiple calculations in a single cell. FREE ACCESS
  • Locked
    3.  Repeating your formula within your spreadsheet in Google Sheets 2020
    4m 28s
    Rather than copy out the same formula multiple times, you can use the fill-down function in Google Sheets in order to repeat a particular cell's contents elsewhere. Google Sheets automatically updates the data involved in order to ensure that the appropriate calculation is performed. FREE ACCESS
  • Locked
    4.  Creating automated cumulative totals in Google Sheets 2020
    3m 16s
    If your data in Google Sheets is in chronological order, you can automatically add values together to give a running total. Learn how to add the values and save time by using the auto-fill to automatically add data to your worksheet cells. FREE ACCESS
  • Locked
    5.  Changing number units in Google Sheets 2020
    3m 2s
    If you are using a particular number format in your spreadsheet and suddenly find that you need to change to a different system, you can use several different functions in Google Sheets in order to perform the operation automatically. This tutorial will show you how to convert binary, hexadecimal and decimal number formats. FREE ACCESS
  • Locked
    6.  Factorizing the results of a division in Google Sheets 2020
    3m 5s
    When performing a division calculation, you can use MOD and QUOTIENT in order to find out the remainder and quotient data relating to your operation. In this tutorial, you will find out how to use these two formulas in Google Sheets. FREE ACCESS
  • Locked
    7.  Counting cells in a range in Google Sheets 2020
    2m 54s
    Using a formula in Google Sheets, you can find out how many rows or entries there are in a specified selection using the COUNTA formula. In this tutorial, you will also find out how to use the formula in conjunction with the IF conditional modifier, allowing you to specify particular properties in your data. FREE ACCESS
  • Locked
    8.  Ranking a value in Google Sheets 2020
    4m 9s
    Being able to rank a data entry is very useful, particularly if you are working with statistics. Google Sheets includes a number of rank-based formulas, including LARGE, RANK and SMALL, all of which will be explained in this tutorial. FREE ACCESS
  • Locked
    9.  Rounding numbers in Google Sheets 2020
    5m 49s
    In Google Sheets there are many different formulas that you can use to round your data values up or down. Which one you choose will depend on how you want to perform the calculation. You can, for example, round a value up to the nearest multiple, round it down to the nearest fraction, and even truncate a value. You'll use formulas such as ROUNDUP, ROUNDDOWN, CEILING, FLOOR, and TRUNC. FREE ACCESS
  • Locked
    10.  Using replacement formulas in Google Sheets 2020
    4m 35s
    Google Sheets features a number of formulas that can be used to very precisely locate and replace character strings. In this tutorial, you will learn how to use formulas such as REPLACE and SUBSTITUTE in order to replace text entries rather than editing them manually. Finally, see how to use the TRIM option to remove any unnecessary blank space. FREE ACCESS
  • Locked
    11.  Generating random numbers in Google Sheets 2020
    4m 54s
    Google Sheets' random number generators can help you do everything from organizing a weekend athletics competition to creating project groups at work. Use the functions RAND and RANDBETWEEN to generate random numbers. You can even use the RANK function to automatically create a running order. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.4 of 37 users Rating 4.4 of 37 users (37)
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 2067 users Rating 4.3 of 2067 users (2067)
Rating 4.5 of 51 users Rating 4.5 of 51 users (51)
Rating 4.5 of 1052 users Rating 4.5 of 1052 users (1052)