Select/Jump/Goto Specific Sheet Directly in a workbook – Efficiency Tip

The other day I went to meet my Friend 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 […]

How to use INDIRECT function in Excel

There are hundreds of functions in MS-Excel. There are a few of them which are used very frequently and INDIRECT function is one among them. Indirect function is categorized as lookup/ reference function. Today let’s know the importance of indirect function and see how to use Indirect function and its usage in different scenarios. As […]

Excel Double Click Tricks – Work Faster with Excel

Many Excel Users will be eager to learn keyboard shortcuts to work fast in Excel. There are some areas where mouse is a better choice instead of using a keyboard (like moving/ editing shapes, data in cells in etc.). Learning of mouse usage along with the keyboard shortcuts will make you much more efficient and […]

Close multiple Excel Files instantly (Excel 2013) – Excel Efficiency Tip

One of the improvements in 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 […]