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 …
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 »
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 »
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 »
Can we select and filter data with a single click in excel. As expected, the answer is YES. In this post let us see how to do it. Filter is one of the well-known and most widely used function in excel. The basic way filter operates is identifying the value from the multiple values in …
Filter Data with a Single Click – Excel Efficiency Tip Continue Reading »
In this post let’s see how to Change Column Name from Alphabets to Numbers in Excel. Need to Change Column Name from Alphabets to Numbers We know that in excel rows are numbered and columns are named alphabetically. (Know More about excel terminology). However, when using few formulae (like vlookup) where we need to refer …
How to Change Column Name from Alphabets to Numbers in Excel Continue Reading »
