Using Formula Tools in Excel iPad

Excel iPad    |    Beginner
  • 17 videos | 1h 13m 13s
  • Earns a Badge
Likes 13 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
    find duplicates in spreadsheets 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

  • Playable
    1.  Using the function library in Excel iPad
    4m 45s
    Excel for iPad'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… FREE ACCESS
  • Playable
    2.  Performing simple calculations in Excel iPad
    4m 26s
    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… FREE ACCESS
  • Locked
    3.  Choosing between absolute & relative cell references in Excel iPad
    5m 52s
    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.… FREE ACCESS
  • Locked
    4.  Using data from multiple worksheets in a formula in Excel iPad
    3m 14s
    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. FREE ACCESS
  • Locked
    5.  Using automated formulas in a table in Excel iPad
    3m 58s
    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… FREE ACCESS
  • Locked
    6.  Creating automated cumulative totals in Excel iPad
    5m
    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… FREE ACCESS
  • Locked
    7.  Performing calculations using constants in Excel iPad
    7m
    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's cell reference, rather than the value… FREE ACCESS
  • Locked
    8.  Inserting a conditional sum formula in Excel iPad
    5m 2s
    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… FREE ACCESS
  • Locked
    9.  Counting cells in a range in Excel iPad
    2m 55s
    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. FREE ACCESS
  • Locked
    10.  Factorizing the results of a division in Excel iPad
    2m 38s
    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… FREE ACCESS
  • Locked
    11.  Ranking a value in Excel iPad
    4m 17s
    Excel for iPad'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… FREE ACCESS
  • Locked
    12.  Rounding a number in Excel iPad
    4m 30s
    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… FREE ACCESS
  • Locked
    13.  Finding duplicates in your spreadsheet in Excel iPad
    4m 2s
    Using the IF function checks to see if a condition you'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… FREE ACCESS
  • Locked
    14.  Retrieving information with dates in Excel iPad
    3m 39s
    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… FREE ACCESS
  • Locked
    15.  Inserting data automatically in Excel iPad
    4m 3s
    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… FREE ACCESS
  • Locked
    16.  Finding & replacing formulas in Excel iPad
    3m 13s
    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… FREE ACCESS
  • Locked
    17.  Understanding formula errors in Excel iPad
    4m 40s
    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. FREE ACCESS

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.