# Using Basic Formulas

Excel 2019 (Windows)    |    Beginner
• 12 Videos | 51m 12s
• Includes Assessment
• CPE
• PMI PDU
Likes 266
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

• 1.
Inserting a formula using the function library
• 2.
Performing simple calculations
• 3.
Using automated formulas in a table
• 4.
Creating automated cumulative totals
• 5.
Inserting subtotals
• 6.
Counting cells in a range
• 7.
Ranking a value
• 8.
Rounding a number
• 9.
Using replacement formulas
• 10.
Converting number types
• 11.
Factorizing the results of a division
• 12.
Creating random values

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.