Course details

Microsoft Excel 2016 for iPad: Using Formula Tools

Microsoft Excel 2016 for iPad: Using Formula Tools


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
1.2

Lesson Objectives

Microsoft Excel 2016 for iPad: Using Formula Tools

  • 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
  • Course Number:
    ds_msexip_05_enus

    Expertise Level
    Beginner