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 »
Let it be a beginner or an excel expert Excel Keyboard Shortcuts is one of the most interesting/ favorite part of any (every) user. Why? Why to learn Excel Keyboard Shortcuts The answer is pretty simple. For Multiple reasons. Makes work easier enabling you to work more fast and accurate in the excel environment there …
Excel Keyboard Shortcuts – Must Know – Improve Your Productivity And Efficiency 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 »
When working with excel, at times we require to use the same data/ formula in multiple sheets in Excel. Instead of doing it the boring way, i.e. manually going to each sheet and making the changes, Is there a simple way to use the data/ formula in multiple sheets. In this post, let us see …
The other day I went to meet my Friends who recently joined as a data analyst. By the time I reached his home he was with his laptop and was working on some project. He has an excel file with Multiple sheets (close to 30) and he is working with formulae to navigate across multiple …
