linkedin
5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707
support@lambers.com

SkillSoft Explore Course

BUY NOW! STARTING AT ONLY $299!
Productivity & Collaboration Tools     Microsoft Office 2016     Excel 2016     Excel for iPad (No Assessments)

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.

Asset ID ds_msexip_05_enus
Course Type Video Course
Course Category Microsoft Office 2016
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