Using Basic Formulas in Excel 2019 for Windows

Excel    |    Beginner
  • 12 videos | 52m
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 1052 users Rating 4.5 of 1052 users (1052)
Put formulas to work with Excel 2019 for Windows. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this, you will learn how to count cells in a range by using different formulas, and then rank values, which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number, to round up or down your data values; use replacement formulas when you need to make changes; convert number types, and factorize the results of a division. Conclude the course by observing how to create random values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • Insert a formula using the function library in excel 2019
    Perform simple calculations in excel 2019
    Use automated formulas in an in excel 2019 table
    Create automated cumulative totals in excel 2019
    Insert subtotals in excel 2019
    Count cells in a range in excel 2019
  • Rank a value in excel 2019
    Round a number in excel 2019
    Use replacement formulas in excel 2019
    Convert number types in excel 2019
    Factorize the results of a division in excel 2019
    Create random values in excel

IN THIS COURSE

  • 5m 21s
    Excel's Function Library can help you to locate and insert the formula you need. These formulas are grouped according to category. If you are unable to find the formula you want, you can also launch a search query. FREE ACCESS
  • 4m 53s
    The cells in your Excel worksheet can be thought of as little calculator spaces. You can use these individual cells to perform simple and complex calculations. FREE ACCESS
  • Locked
    3.  Using automated formulas in a table in Excel 2019 for Windows
    3m 44s
    If you are going to be applying your formulas to a large number of data entries in your worksheet, it is important to know how to use the Fill Down function. FREE ACCESS
  • Locked
    4.  Creating automated cumulative totals in Excel 2019 for Windows
    3m 10s
    If you have organized your data entries into chronological order, a cumulative total can very quickly be created. In Excel, you can create the calculation once and then apply it automatically to the rest of your data entries. FREE ACCESS
  • Locked
    5.  Inserting subtotals in Excel 2019 for Windows
    5m 13s
    When your Excel data table has become rather long, adding subtotals for individual subgroups within that table can be very useful. FREE ACCESS
  • Locked
    6.  Counting cells in a range in Excel 2019 for Windows
    6m
    The COUNTA formula is used in Excel to count up the number of cells that contain values. The COUNTIF formula can be used to perform a count of certain values that meet your conditions. FREE ACCESS
  • Locked
    7.  Ranking a value in Excel 2019 for Windows
    5m 36s
    Excel's RANK function is extremely useful if you want to find out where a particular value places in a list of data entries. You can also visualize the smallest and largest values in a list by using the SMALL and LARGE formulas. FREE ACCESS
  • Locked
    8.  Rounding a number in Excel 2019 for Windows
    4m 55s
    In Excel, there are many different formulas that you can use to round up or down your data values. Which one you choose will depend on how you want to perform the calculation. FREE ACCESS
  • Locked
    9.  Using replacement formulas in Excel 2019 for Windows
    3m 18s
    If you have inserted text data into your spreadsheet and you need to make some changes, you may find that you can perform these modifications with the help of some Excel's formulas, SUBSTITUTE, TRIM and REPLACE. FREE ACCESS
  • Locked
    10.  Converting number types in Excel 2019 for Windows
    2m 55s
    We generally use a base-10 number system in everyday life. You will occasionally find it useful to work in binary and hexadecimal. FREE ACCESS
  • Locked
    11.  Factorizing the results of a division in Excel 2019 for Windows
    1m 55s
    If you want to perform a division in Excel, and you want to obtain a whole number answer, you are going to need to use the QUOTIENT formula. You can also visualize the remainder of the equation by using the MOD formula. FREE ACCESS
  • Locked
    12.  Creating random values in Excel 2019 for Windows
    5m 1s
    Creating randomized numbers if often very useful if you need a randomly-generated code, are holding a lottery, or are drawing lots. In Excel, there are lots of formulas and calculations that you can use to generate your random numbers. 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

Book Microsoft Excel In Easy Steps: Illustrated Using Excel in Office 365
Book Microsoft Excel Functions and Formulas, Sixth Edition: With Excel 2021 / Microsoft 365
Course 10 common tools in Excel 365 (2023)
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started in Excel 365
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Course Datasets in R: Selecting, Filtering, Ordering, & Grouping Data
Rating 4.6 of 7 users Rating 4.6 of 7 users (7)
Course Formatting Data in Excel 2019 for Windows
Rating 4.5 of 487 users Rating 4.5 of 487 users (487)