In this lesson, we will introduce two popular Excel 2007 financial functions: the Payment function and the Future Value function. Excel has many financial functions, and if you are new to financial functions in Excel, the Payment and Future Value functions are excellent way to build a comfort level with these functions.
The Payment function is [...]
During in our previous tutorial, we discussed how to use the IF Statement. Let’s make it a little more complicated by using the Nested IF function in Excel. The Nested IF function extends the power of the IF statement, allowing you to create Excel reports and spreadsheets that are even more detailed and granular.
Creating logical [...]
The IF function in Excel 2007 is the single most powerful command for the non-programmer using Excel. It is a real powerhouse! Using the Excel IF functions offers a quick and easy method to create logical arguments with the end result of presenting and your analyzing your data from a different perspective.
Creating logical functions [...]
The Date and Time Function in Excel 2007 is easy to learn and a powerful tool. Using the Date and Time functions offers a quick way to calculate date and times between two different dates, even taking into account leap years. Click here to watch the free SimonSezIT.com Video Tutorial showing you these steps.
