Kazam Raza Blog

I have an Excel workbook with more than 30 sheets. I want these sheets to be sorted in alphanumerically order. Following is the macro that has resolved the issue.

Read more Sort Worksheets Alphanumerically by Name Using VBA

Logical test means a condition when evaluated by computer whose result/outcome is true or false, there is no third option, for example if a student secures more than 45 marks it is considered as pass otherwise fail.

In Excel a single IF function (IF(logical_test, value_if_true, value_if_false)) evaluate only one logical test at one time, if we have more than one conditions/logical tests, then we use AND function or OR function along with IF Function.

Read more What is logical test in excel?

Sometimes we need start date and end date of a month for our financial model. We can solve this problem by using EOMONTH Function.

Read more How to Get Start Date end Date of a Month Form a Date