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