In this article let us understand about the Excel COLUMN Function. The Formula Syntax of Column Function in Excel. What is Excel Column Function The purpose of Excel Column function is to know or get the column number for a given cell or range. This function returns the column number(s) depending on the input. Note …
In this article let us understand about the Excel Row Function. The Formula Syntax of Row Function in Excel. What is Excel Row Function The purpose of Excel Row function is to know or get the row number for a given cell or range. This function returns the row number(s) depending on the input. Note …
Do you mouse while using excel. Do you know that in few scenarios using mouse is better than using keyboard. Surprised !!!. Let us see the different situations/ scenarios where mouse works better than keyboard. Learn the double click tricks in excel Many Excel Users will be eager to learn keyboard shortcuts to work fast …
Must know Excel Double Click Tricks – Work Faster with Excel Continue Reading »
When working on excel, there will be instances where you need to select multiple cells or ranges at once. We do that by selecting the area with a mouse or using the combination of Shift and Control key shortcuts. However, the challenge here comes when you need to select multiple cells or ranges at once …
Quick way to Select Multiple Cells or Ranges at once Continue Reading »
Match function is one the most important and widely used functions in Excel. In this post let us see how to use the Match Function in excel. Syntax of Match function and few examples on how to use the Match function in excel. What is MATCH Function in Excel Match Function in Excel is under …
How to use MATCH Function in Excel – Syntax and Examples Continue Reading »
The Index function in Excel is one of the most used functions in excel. It is categorized under Lookup and Reference functions. In this article we will see and learn How to use and Syntax along with few examples. What is Index Function in Excel The excel INDEX function returns a value or the reference …
INDEX Function in Excel – How to use with Examples Continue Reading »
The other day I had a conversation with one of my friends who uses excel regularly. We are discussing on some random things in excel. The discussion went around customization of default options in excel. He is bored of looking at the same color options in excel which are set by default specially with the …
How to Change Color of Gridlines in Excel – Fun Tip Continue Reading »
