How to use IF function in Excel
This is a step-by-step guide on how to use IF function in Excel. It shows you how to create a formula using the IF function, it includes several IF formula [...]
How to use EOMONTH function in Excel
Excel's EOMONTH function returns the last day of a month, N months in the future or the past.
How to use INDEX and MATCH functions in Excel
If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.
How to use VLOOKUP in Excel (2022)
VLOOKUP was created to lookup and retrieve data from a specific column in a table. It support approximate and exact matching and wildcards (* ?)
How to use SUM, SUMSQ, SUMIF and SUMIFS functions in Excel
Understanding SUMIF and SUMIFS functions in Excel is easier than you think and provides great flexibility and increased speed when performing quick analysis.
How to use PPMT function in Excel [step by step guide]
The tutorial shows how to use PPMT function in Excel to calculate and return the payment on the principal for a given period for an investment based on periodic, constant [...]
How to use IPMT function in Excel [step by step guide]
The tutorial shows how to use IPMT function in Excel to calculate the interest portion for a given period of a loan, mortgage, or investment. The function uses constant payments [...]
How to use COUNTIF function in Excel
Step by step instructions on how to use COUNTIF function in Excel. Download the example workbook to better understand how to use COUNTIF.
How to use PMT function in Excel [step by step guide]
The tutorial shows how to use PMT function in Excel to calculate the annuity for a loan or the cash flows for investments based on a fixed interest rate, number [...]