Functions

What if you are working in a big workbook with huge data in different worksheets and you want to find a particular text or a… Read Article

In our previous blogs, we had learned about various types of cell formatting options and the number formatting in Excel. Also, we learned about how… Read Article

While working with cells in Microsoft Excel, you may have come across various pre-defined cell formats that you can use to format the numbers, etc.… Read Article

In one of our previous blogs, we learned various ‘Format Cells’ options available in Excel. One of the formatting options was the Excel ‘Number’ Format.… Read Article

The Format Cells feature in Excel allows the user to change the properties of the cell in Excel. There are many properties that a cell… Read Article

In this blog, we would learn what is a custom list in Excel and how to create a new custom list. We would also learn… Read Article

Let us do one small activity before we start. Select any of the cells and write (c) i.e. the character c within parenthesis and press… Read Article

In this blog, we would learn how to use the Sparkline feature in Excel. A sparkline is just like a chart that we create in… Read Article

In this blog, we would learn how to merge columns in Excel. We would go through multiple ways including the formula to merge columns in… Read Article

Most of the time, while working with Excel, you would be using either numbers or text in a cell. But do you know you can… Read Article

In this blog, we would learn all about the Hyperlink feature in Excel. Hyperlink feature allows you to create a link to some location in… Read Article

Many a time, while working with huge excel data across multiple worksheets, you may sometimes need to merge and consolidate those data and bring them… Read Article