Learn all about Excel’s lookup & reference functions such as the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE function. Vlookup The VLOOKUP (Vertical lookup) function looks for a value…
To illustrate Excel’s most popular financial functions, we consider a loan with monthly payments, an annual interest rate of 6%, a 20-year duration, a present value of $150,000 (amount borrowed)…
To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the “:” (colon). You can also enter a date and a time…
Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If The IF function checks whether a condition is met, and…
The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells…