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 »
Importance of Excel is increasing day by day as many jobs are demanding knowledge of Excel. Excel is an ocean with many features, options, commands and functions each of them designed to perform a specific task. It is always easy to swim across the ocean once you understand and have an idea about the basic …
Excel Basics – Understanding the Spreadsheet – A Beginners Guide Continue Reading »
Read this article on MEDIUM Microsoft Excel (MS-Excel) the name which do not need any introduction. This is one of the applications that is widely in use for all time since inception. Almost close to 40 years and still running. According to me, it is one of the most powerful and important applications to date. The …
What is the Importance of Excel – Why to learn Continue Reading »
