# Using Formula Tools

• 17 Videos | 1h 13m 13s
Likes 11
A major benefit of a spreadsheet is the ability to perform calculations on its data. Discover how to use Excel for iPad's Function Library, and work with formulas to count cells, perform rounding and ranking, and locate duplicates.

## WHAT YOU WILL LEARN

• use the Function Library in Excel for iPad
perform simple calculations in Excel for iPad
choose between absolute and relative cell references
use data from multiple worksheets in a formula
use automated formulas in a table
create automated cumulative totals in Excel for iPad
perform calculations using constants in Excel for iPad
insert conditional sum formulas in Excel for iPad
count cells in a range in Excel for iPad
• factorize the results of a division in Excel for iPad
rank values in Excel for iPad
round numbers in Excel for iPad
retrieve information with dates in Excel for iPad
inset data automatically in Excel for iPad
find and replace data in Excel for iPad
understand formula error messages in Excel for iPad

## IN THIS COURSE

• 1.
Using the function library
• 2.
Performing simple calculations
• 3.
Choosing between absolute & relative cell references
• 4.
Using data from multiple worksheets in a formula
• 5.
Using automated formulas in a table
• 6.
Creating automated cumulative totals
• 7.
Performing calculations using constants
• 8.
Inserting a conditional sum formula
• 9.
Counting cells in a range
• 10.
Factorizing the results of a division
• 11.
Ranking a value
• 12.
Rounding a number
• 13.
• 14.
Retrieving information with dates
• 15.
Inserting data automatically
• 16.
Finding & replacing formulas
• 17.
Understanding formula errors

## 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.

Likes 0
Likes 10
Likes 1

Likes 705
COURSE Tools
Likes 54
Likes 713