Why Weeknum Function Returns Wrong Value ?
This year WEEKNUM Function returns wrong value if you are using it as usual. Because Excel considers the week containing 1st of January as week...
Tagged: excel functions
Volatile Functions in Excel
There are some functions that can generate a different result with each recalculation even when none of its arguments changed. Let’s see what the volatile...
Excel Formula Exercises 1
I am starting a new series of posts for you to sharpen your skills with Excel formulas. Each post will include 4-5 excel formula exercises...
Time Value of Money
This post is a explainatory post for Financial Functions of Excel. In order to understand some of the financial functions, you need to have a...
Using Excel Functions
Excel has a very wide array of functions for your use in various calculations. These functions are grouped into several titles. You may find a...
