In this post let’s see how to understand complex formulae by adding a comment in the formula. Few days back I met Kiran, a Friend of Mine. He works as an Analyst in one of the MNC’s and moved to Hyderabad recently due to a project. While we were discussing things related to our Job …
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 …
One of the improvements from Excel 2013 is every excel file opens in a new window. This feature is handy to quickly compare the data in different workbooks. However the issue comes with closing the workbooks at once. In previous versions of excel you can use Alt+F4 to close multiple excel files at once. This …
How to Close all Excel Files at once instantly – Excel Efficiency Tip Continue Reading »
By default only one seventh of the commands are visible on the ribbon due to which you need to switch between tabs to use multiple options which consumes time. The solution for this problem is to have all the commands which we use frequently at one place. Is it possible to have all our frequently …
Customize Quick Access Toolbar (QAT) in Excel – The Efficiency Booster Continue Reading »
