# Using Basic Formulas

Excel Microsoft 365 (Windows)
• 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.

## YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 25
Likes 10
Likes 0

Likes 547
Likes 1408
Likes 705