If you are a Microsoft Excel regular user, think how many formulas you are building a day. You need time and focus to build formulas correctly. This article brings you some good tips that aid you to improve productivity and save time with Excel formula. Note: This post is created with 2013 version of Microsoft … Read more
When you are working with a set of a related data set, the easiest way to manage and analyze them is to use the table feature. By using Excel tables, you can manage data in the table rows and columns independently from the data on the outside of the table on the worksheet. You may … Read more
If you are using Microsoft Excel regularly, knowing the following simple yet powerful 10 methods you can save your time and will help you work faster. 01. Edit the active cell (F2) Use the F2 key to edit the active cell and put the insertion point at the end of its contents. For example, as … Read more
Conditional formatting is one of basic style for visualizing a set of data using color ranges without changing the data set into a chart or graph. Human mind recognizes the colors for various information. As an example; Green for “OK/good” and Red for “No/bad”. The basic concept of Conditional formatting is to recognize the values … Read more