COUNTIF function - Microsoft Support
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says:
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Add a data series to your chart - Microsoft Support
After creating a chart, you might need to add an additional data series to the chart. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits.
Use conditional formatting to highlight information in Excel
First rule: a home buyer has budgeted up to $75,000 as a down payment and $1,500 per month as a mortgage payment. If both the down payment and the monthly payments fit these requirements, cells B4 and B5 are formatted green.
Using Excel formulas to figure out payments and savings
Excel formulas and budgeting templates can help you calculate the future value of your debts and investments, making it easier to figure out how long it will take for you to reach your goals. Use the following functions: PMT calculates the payment for a loan based on constant payments and a constant interest rate.
IRR function - Microsoft Support
Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually.
SUBTOTAL function - Microsoft Support
Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
Guidelines and examples of array formulas - Microsoft Support
The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as existing array formulas entered as both dynamic and legacy arrays.
Calculate percentages - Microsoft Support
Calculate an average. Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!
FV function - Microsoft Support
FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. Use the Excel Formula Coach to find the future value of a series of payments.