In this article, I am going to discuss some possible cases when the formulas to compare dates are not working in Excel and devise some solutions to the ...

In this article, I will discuss some possible solutions to Excel Queries and Connections not working. Excel Queries and Connections is a powerful tool when it ...

In this article, I will show you how to create bar chart with Error Bars in Excel. While representing different scientific measurements and data in charts, it ...

In this article, I will show how to create floating cells in Excel. In many situations, we need to display a group of cells always floating on the screen while ...

In this article, I will show you how to use the Macaulay Duration formula in Excel. While performing many financial calculations, especially while dealing with ...

In this article, I will show you how to calculate standard deviation in Excel. In many situations, we need to calculate standard deviation whether performing ...

In this article, I will show you how to use the Advanced Filter with Wildcard in Excel. As we know, sometimes we need to use the Excel Advanced Filter feature ...

In this short tutorial, I will show you how to create an input dialog box through VBA in Excel. Fortunately, Excel has a built-in function named InputBox which ...

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employees’ daily ...

In this article, I will show you how to make a catalogue in Excel. As we know, a catalogue is a collection of items, organized systematically to make searching ...

In this article, I will show how to animate text in Excel. While working in Excel, we may need to add some animation effects to make the worksheet looks more ...

In this article, I will show you how to count words in Excel. While working in Excel, we may want to calculate the total number of words in a cell or in a ...

In this article, I will show how we can find intersection of two lists in Excel. While working in Excel, we may want to compare the elements of two lists and ...

In this article, I will show you how to use the VBA Union function in Excel. Among many other VBA functions, Union is a very useful one when it comes to ...

In this article, I will show you how to set an alarm clock in Excel. While working in Excel, we may want to remind ourselves of something important at a ...