Working with Formulas in Excel 2013 for Windows

Excel 2013 (Windows)    |    Intermediate
  • 9 videos | 45m 54s
  • Earns a Badge
Rating 4.8 of 20 users Rating 4.8 of 20 users (20)
Learn how to use Excel 2013 for common tasks like calculating the interest on a loan, reaching a target value, solving problems, creating automatic reports, as well as finding, visualizing, and preventing duplicate values.

WHAT YOU WILL LEARN

  • Calculating the interest on a loan
    Simulating a loan
    Reaching a target value
    Solving a problem
    Creating automatic reports
  • Finding identical values in your spreadsheet
    Finding duplicates in your document
    Visualizing your duplicate values
    Preventing duplicate values

IN THIS COURSE

  • 6m 34s
    If you have taken out a loan, Excel 2013 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 period. FREE ACCESS
  • 6m 30s
    Once you know how to use Excel 2013 to estimate your loan repayments, you can begin to simulate and compare different loan amounts, different interest rates, and even different lengths of time. FREE ACCESS
  • Locked
    3.  Reaching a target value in Excel 2013 for Windows
    5m 40s
    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 2013 can automatically obtain the value that you are looking for by modifying the necessary values in your table. FREE ACCESS
  • Locked
    4.  Solving a problem in Excel 2013 for Windows
    5m 57s
    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 2013's solver tools. You simply need to select the value that you wish to optimize, minimize or otherwise adjust and input the various constraints that will have an impact on your eventual result. FREE ACCESS
  • Locked
    5.  Creating automatic reports in Excel 2013 for Windows
    5m 9s
    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 2013. FREE ACCESS
  • Locked
    6.  Finding identical values in your spreadsheet in Excel 2013 for Windows
    2m 41s
    Combining the SUMPRODUCT and COUNTIF formulas in Excel 2013 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
    7.  Finding duplicates in your document in Excel 2013 for Windows
    5m 45s
    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 2013, you can obtain the number of different values in a range. This data can then be used to work out the number of duplicates that your data table contains. FREE ACCESS
  • Locked
    8.  Visualizing your duplicate values in Excel 2013 for Windows
    4m 29s
    In Excel 2013, you can visualize any duplicates that have crept into your data table by combining conditional formatting with the IF formula. There is even a special conditional formatting tool that can be used to analyze a selected data range and highlight any duplicates that it finds. FREE ACCESS
  • Locked
    9.  Preventing duplicate values in Excel 2013 for Windows
    3m 9s
    If you want to be absolutely sure that users only enter unique values in your data table, you can tell Excel 2013 to block duplicates and display an error message. To do this, you will need to know how to use the data validation tools. 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.

YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Journey Microsoft Excel
Rating 2.7 of 3 users Rating 2.7 of 3 users (3)
Rating 4.5 of 16 users Rating 4.5 of 16 users (16)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 18 users Rating 4.3 of 18 users (18)
Rating 4.5 of 46 users Rating 4.5 of 46 users (46)
Rating 4.7 of 86 users Rating 4.7 of 86 users (86)