Working with Formulas in Excel 2016 for Mac

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 in Excel 2016 for Mac
    4m 9s
    If you have taken out a loan, Excel 2016 for Mac can help you to estimate and manage your repayments. You can break the payments down into your interest repayments, your loan repayments, and your total repayments per… FREE ACCESS
  • Playable
    2.  Reaching a target value in Excel 2016 for Mac
    4m 46s
    If you use formulas to obtain certain results in your table, you can use the Goal Seek tool to reach a target value. This means that rather than adjusting the values and performing the calculations yourself, Excel 2016… FREE ACCESS
  • Locked
    3.  Solving a problem in Excel 2016 for Mac
    5m 14s
    If you have a mathematical problem in your table which is governed by various different constraints, you can attempt to solve it automatically using Excel 2016 for Mac's solver tool. You simply need to select the value… FREE ACCESS
  • Locked
    4.  Creating automatic reports in Excel 2016 for Mac
    4m 17s
    The SUMPRODUCT formula can be used to perform a sum calculation on data that corresponds to particular criteria. You can, for example, use it to create an automatic data report in Excel 2016 for Mac. FREE ACCESS
  • Locked
    5.  Finding identical values in your spreadsheet in Excel 2016 for Mac
    3m 30s
    Combining the SUMPRODUCT and COUNTIF formulas in Excel 2016 for Mac can help you to find identical values in your spreadsheet. This can be very useful if you need to tidy up your data tables and remove duplicates. FREE ACCESS
  • Locked
    6.  Finding duplicates in your document in Excel 2016 for Mac
    4m 29s
    The COUNTA formula will return the number of non-empty cells in a data range. If you combine this calculation with the SUMPRODUCT and COUNTIF formulas in Excel 2016 for Mac, you can obtain the number of different values… 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 351 Likes 351  
Likes 306 Likes 306  
Likes 53 Likes 53