Using Basic Formulas

Excel 2019 (Windows)
• 12 Videos | 1h 9m 12s
• Includes Assessment
• CPE
• PMI PDU
Likes 146
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.

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.

YOU MIGHT ALSO LIKE

Likes 75
COURSE Managing Data
Likes 25
Likes 52

Likes 705
Likes 212
Likes 279