Microsoft Excel 2016 for iPad: Using Formula Tools

Expected Duration
Lesson Objectives
Course Number
Expertise Level


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)

Lesson Objectives

Microsoft Excel 2016 for iPad: Using Formula Tools

  • Using the function library
  • Performing simple calculations
  • Choosing between absolute & relative cell references
  • Using data from multiple worksheets in a formula
  • Using automated formulas in a table
  • Creating automated cumulative totals
  • Performing calculations using constants
  • Inserting a conditional sum formula
  • Counting cells in a range
  • Factorizing the results of a division
  • Ranking a value
  • Rounding a number
  • Finding duplicates in your spreadsheet
  • Retrieving information with dates
  • Inserting data automatically
  • Finding & replacing formulas
  • Understanding formula errors
  • Course Number:

    Expertise Level