# Using Basic Formulas

Excel Microsoft 365 (Windows)    |    Beginner
• 12 Videos | 58m 20s
• Includes Assessment
Likes 704
Formulas in MS Excel for Office 365 are useful in helping you visualize data. This course explores the large collection of formulas available in the Excel searchable library. Learn how to program each data cell to perform calculations, insert subtotals, create automated cumulative totals, and apply a formula to a large number of entries with the fill down function. Observe how to employ the COUNTA, COUNTIF, number rounding, and replacement formulas. Other topics explore how to rank a value with the rank function; convert between binary and hexadecimal number systems; factorize division results with the QUOTIENT and MODE formulas, and generate random values.

## WHAT YOU WILL LEARN

• insert a formula using the Excel 365 function library perform simple calculations in Excel 365 use automated formulas in a table in Excel 365 create automated cumulative totals in Excel 365 insert subtotals in Excel 365 count cells in a range in Excel 365
• rank a value in Excel 365 round a number in Excel 365 use replacement formulas in Excel 365 convert number types in Excel 365 factorize the results of a division in Excel 365 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.