What-If Analysis in Excel
What-if analysis is the process of changing input values to see how the changes affect other output data. What-if analysis is a powerful tool in Excel.
What-If Analysis in Excel Read More »
Excel
Data Analysis in Excel
Using Excel is a great way to start data analysis. Excel can handle large data sets with tools like pivot tables, pivot charts, and regression analysis.
Data Analysis in Excel Read More »
Financial Functions in Excel
Excel has 55 financial functions to solve financial problems. Excellent financial analysis requires using many financial functions in Excel. These functions use time value of money (TVM) calculations to solve many financial problems.
Financial Functions in Excel Read More »
Text Functions in Excel
Excel text functions add, extract, and edit text. Excel has over 30 text functions to edit, format, and clean data. It is so much more than number crunching.
Text Functions in Excel Read More »
Logical Functions in Excel
There are eleven logical functions in Excel. They include IF, AND, OR, TRUE, FALSE, and NOT functions. These help analysts make decisions.
Logical Functions in Excel Read More »
Creating Graphs in Excel
Excel can display several types of graphs to visualize data. There are at least 26 different graph types in Excel.
Creating Graphs in Excel Read More »