Category: Excel

What If Analysis What-if analysis is the process of changing values to see how the changes affect other data. What-if analysis is a powerful tool of Excel. Breakeven analysis is a...

Excel can select a specific value from a long list of values. These are called lookup functions. The most important lookup functions are VLOOKUP and XLOOKUP. Retrieving Data with Lookup...

Excel has many special financial functions. This guide shows how to solve time value of money problems using financial functions in Excel. Time value of money (TVM) is the idea that money is worth...

Excel Text Functions Excel not only is good with numbers. Excel has many text functions. It is the most useful app for working with cleaning text from a database.  Text Capitalization...

Excel Logical Functions There are eleven logical functions in Excel. They include IF, AND, OR, and NOT functions. These help analysts make decisions. These logical functions are on the Formulas...

Excel can display several types of graphs to visualize data. There are at least 26 different graph types in Excel. Excel Graphs The following table shows the most common graphs in...