Working with Formulas

Excel 2016 (Mac)    |    Intermediate
  • 6 Videos | 26m 27s
  • Earns a Badge
Likes 13 Likes 13
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, use the Goal Seek and Solver tools, and handle duplicate values in your spreadsheet.

WHAT YOU WILL LEARN

  • calculate the interest on a loan
    use the Goal Seek tool to reach target values
    solve math problems automatically in Excel 2016 for Mac
  • create automatic reports in Excel 2016 for Mac
    find identical values in your spreadsheet
    find duplicates in your spreadsheets

IN THIS COURSE

  • Playable
    1. 
    Calculating the interest on a loan
    4m 9s
    UP NEXT
  • Playable
    2. 
    Reaching a target value
    4m 46s
  • Locked
    3. 
    Solving a problem
    5m 14s
    FREE ACCESS
  • Locked
    4. 
    Creating automatic reports
    4m 17s
    FREE ACCESS
  • Locked
    5. 
    Finding identical values in your spreadsheet
    3m 30s
    FREE ACCESS
  • Locked
    6. 
    Finding duplicates in your document
    4m 29s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Basic Formulas
Likes 40 Likes 40  
COURSE Finding and analyzing data with formulas in Excel 365
COURSE Using macros in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Excel Tables
Likes 351 Likes 351  
COURSE Getting Started
Likes 809 Likes 809  
COURSE Using the Power Pivot Add-in
Likes 86 Likes 86