### 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