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

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: ds_msexip_05_enus

Expertise Level
Beginner