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 »
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 »
