This article explains about creating and using drop down list in excel using data validation. Why in survey’s we will see options are limited (majority of the cases) where in the user can choose his/ her option from the available list of options. The answer is simple and well known. An organized/ properly formatted data …
Drop Down List in Excel – How to create and use using Data Validation Continue Reading »
Excel is not a typing program as it is majorly used to work with numbers and analyzing data. However all your efforts go in vain if there are typos or spelling mistakes in the representation of data. This comes as a challenge for many users to identify and correct the spelling mistakes or typos in …
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 »
We know that every cell in the spreadsheet has a unique name by default. This name is nothing but the combination of the row number and the name of the column. Now the question is can I have my own name(s) assigned to a cell/ a group of cells (range) instead of the default name …
How to Create and Use Named Ranges in Excel Continue Reading »
In this post, let us see how to open same excel file in multiple windows to review or preview the changes before saving it. Read this Article on MEDIUM What is the need to Open Same Excel File in Multiple Windows / Instances As an Analyst, I will be working on bigger data sets which …
How to Open / View Same Excel File in Multiple Windows – Excel Efficiency Tip Continue Reading »
