Excel AutoFill using Fill handle or keyboard shortcut
The Excel fill handle is a very quick way to copy text items or a series of values in a range. This feature is known as AutoFill. With the [...]
April 2019
How to do a Double lookup in Excel (Two-way lookup)
What is a double lookup in Excel? Two-way lookup or double lookup is simply a formula that looks in both vertical and horizontal directions simultaneously, in order to find [...]
Over 10 Actionable VLOOKUP Examples Explained
As we all know, the best way to learn something is to get your hand on it, make mistakes and learn from them. As they say, practice makes man [...]
December 2018
Excel Filter Data: the complete guide
Excel filter refers to displaying only the rows that match a certain criterion while hiding the other rows. Filtering allows you to limit the data in a display so [...]
Stock Items in Tally ERP 9 – How to Create or Alter
This guide is part of my Tally inventory management series. In the first guide, I talked a lot about Tally inventory management including the features that made it outstanding. [...]
November 2018
Tally Inventory Management Part II: Stock Categories
This guide is Tally inventory management Part II. In the first guide, I talked a lot about Tally inventory management including the features that made it outstanding. One of [...]
How to Maintain inventory in tally ERP 9 (Part I): Stock Groups
Inventory management is one of the toughest business activity for small and growing businesses. Not only do you need to physically care for the stuff, but you also have [...]