# Using Formula Tools in Excel iPad

• 17 videos | 1h 13m 13s
Likes 13
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 in Excel iPad
Excel for iPad&#39;s Function Library can help you to locate and insert the formulas you need. These formulas are grouped according to category. Once you have selected the formula you wish to use, Excel for iPad can guide…
• 2.  Performing simple calculations in Excel iPad
The cells in your Excel for iPad worksheet can be thought of as little calculator spaces. You can use these individual cells to perform simple and complex calculations. Once you have inserted a calculation, any data…
• 3.  Choosing between absolute & relative cell references in Excel iPad
Moving or automating a formula in Excel for iPad will automatically adjust the cell references that it contains. Any references to cells, columns and rows contained in these formulas are known as relative cell references.…
• 4.  Using data from multiple worksheets in a formula in Excel iPad
When storing and using data on several different worksheets in your Excel for iPad document, it is important to know how to reference them correctly in your formulas.
• 5.  Using automated formulas in a table in Excel iPad
If you are going to be applying your formulas to a large number of data entries in your worksheet, it is important to know how to use the Fill Down function. When a formula is copied and pasted into a new cell in Excel…
• 6.  Creating automated cumulative totals in Excel iPad
If you have organized your data entries into chronological order, a cumulative total can very quickly be created. In Excel for iPad, you can create the calculation once and then apply it automatically to the rest of your…
• 7.  Performing calculations using constants in Excel iPad
You will often use constant data values when working on your Excel for iPad table. If one of your formulas is using a fixed value, then you may find it useful to use the value&#39;s cell reference, rather than the value…
• 8.  Inserting a conditional sum formula in Excel iPad
In Excel for iPad, you can use the SUMIF and SUMIFS formulas to perform a sum calculation on certain data values in your range. All you need to know is how to specify the conditions that your qualifying data values have…
• 9.  Counting cells in a range in Excel iPad
The COUNTA formula will return the number of non-empty cells in a data range. You can go further by using the COUNTIF in order to add criteria to your formulas.
• 10.  Factorizing the results of a division in Excel iPad
If you want to perform a division in Excel for iPad, and you want to obtain a whole number answer, you are going to need to use the QUOTIENT formula. You can also visualize the remainder of the equation by using the MOD…
• 11.  Ranking a value in Excel iPad
Excel for iPad&#39;s RANK function is extremely useful if you want to find out where a particular value places in a list of data entries. You can also visualize the smallest and largest values in a list by using the SMALL…
• 12.  Rounding a number in Excel iPad
In Excel for iPad, there are many different formulas that you can use to round up or down your data values. Which one you choose will depend on how you want to perform the calculation. You can, for example, round a value…
Using the IF function checks to see if a condition you&#39;ve created is true of false. You can use the function to see if your data range contains duplicate entries. After applying the function to identify the…
• 14.  Retrieving information with dates in Excel iPad
Excel for iPad features a number of different date formulas that can be used to return precise information relating to a particular month, day or year. You can use these formulas - which include MONTH, DAY, YEAR, and…
• 15.  Inserting data automatically in Excel iPad
The VLOOKUP formula can be used to fill in your data cells automatically. Once you have inserted your reference data into Excel for iPad, you can use the VLOOKUP tool to automatically cross reference the data range and…
• 16.  Finding & replacing formulas in Excel iPad
In Excel for iPad, you can find and replace contextual data, but you can also use the find and replace feature in order to modify formulas. Once you locate and replace a function, the corresponding formulas will be…
• 17.  Understanding formula errors in Excel iPad
Excel for iPad features a wide range of formula error messages. If you want to fix these problems, you are going to need to know how to identify what each message represents and how the error was produced.

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.