Using Formula Tools

Excel iPad
  • 17 Videos | 1h 13m 13s
  • Earns a Badge
Likes 11 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
    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
    4m 45s
    UP NEXT
  • Playable
    2. 
    Performing simple calculations
    4m 26s
  • Locked
    3. 
    Choosing between absolute & relative cell references
    5m 52s
  • Locked
    4. 
    Using data from multiple worksheets in a formula
    3m 14s
  • Locked
    5. 
    Using automated formulas in a table
    3m 58s
  • Locked
    6. 
    Creating automated cumulative totals
    5m
  • Locked
    7. 
    Performing calculations using constants
    7m
  • Locked
    8. 
    Inserting a conditional sum formula
    5m 2s
  • Locked
    9. 
    Counting cells in a range
    2m 55s
  • Locked
    10. 
    Factorizing the results of a division
    2m 38s
  • Locked
    11. 
    Ranking a value
    4m 17s
  • Locked
    12. 
    Rounding a number
    4m 30s
  • Locked
    13. 
    Finding duplicates in your spreadsheet
    4m 2s
  • Locked
    14. 
    Retrieving information with dates
    3m 39s
  • Locked
    15. 
    Inserting data automatically
    4m 3s
  • Locked
    16. 
    Finding & replacing formulas
    3m 13s
  • Locked
    17. 
    Understanding formula errors
    4m 40s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 705 Likes 705  
COURSE Tools
Likes 54 Likes 54  
Likes 713 Likes 713