Tips and Tricks

Today, we are going to learn a beneficial thing which is to lock the cells containing Formulas in a workbook so that no co-worker or… Read Article

Excel is a potent tool where we can maintain our data. Today, we would learn about how to hide or unhide the cell content or… Read Article

It is elementary to design a calendar in excel in just three steps. We can make the calendar using the SEQUENCE Function. We would use… Read Article

When working with excel spreadsheets, there are times when we see that the column headers are named using numbers and not letters. This actually makes… Read Article

When we import data from other sources, then it is not necessary that it is in a clean format. Removing blank rows or cells from… Read Article

The previous article covered the basics of adding and customizing Data Bars. Today we will learn how to define the min and max values of… Read Article

Previously we have learned the basics of conditional formatting. Today we would learn an important part of conditional formatting. Data Bars in Excel are very… Read Article

In the previous article, we learned the implemented fundamentals of Conditional Formatting and how to use color scales. Today, we will learn how to manage… Read Article

In the previous blog, we learned the basics of conditional formatting. Today we would learn how to apply multiple conditional formatting rules on the same… Read Article

Conditional Formatting is a very fascinating topic in excel. It might seem confusing to some people but is one of the straightforward things to learn.… Read Article

Today, we are going to learn a very interesting topic. Conditional Formatting is used to format the cells based on some condition. Color Scales are… Read Article

The Date and time in Excel are stored as decimal numbers. There are times when we need to calculate the total number of hours between… Read Article