melih, Author at Beat Excel!

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...

If you ever had to create a series of numbers or a numbered list in Excel, you probably did so by dragging the fill handle...

With IFS Function you don’t need to deal with nested IF functions anymore. IFS is an if function that can take multiple conditions.

When one value on your chart is much higher than the rest, lower values on your chart might become unreadable. In this tutorial, you will...

I prepared this tutorial because there was a lot of requests for a tutorial about how to build Family Budget Template. You can understand the...

Here is a super easy way to highlight duplicates in Excel. With this procedure, you can highlight duplicates in 2-3 clicks.