Too many financial decisions are made without factoring in the time value of money. Whether providing financial planning advice related to a client’s retirement, advising a client about a business ...

There are many ways to find and retrieve data from a table or range based on a lookup value. In fact, because Microsoft often comes up with new, modernized alternatives, there are too many ways! So, ...

Excel is a spreadsheet with a lot of power. The software can be used to track inventory, track and calculate payroll and a myriad of other calculations. An Excel formula is generally composed of ...

Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Many Microsoft Excel sheets store date and time values. Sometimes the two values appear in the same cell, and sometimes they do not. If you work with dates and/or times, you need a good understanding ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...