Recent Blog Posts
Why VLOOKUP not working and how to solve it
Want to know why your VLOOKUP is not working? You are in the right place. This tutorial will help you learn why you are getting VLOOKUP errors in Excel [...]
How to Create Excel Data Entry Form
The built-in Excel data entry form is ideal for data entry tasks. It shines when you need to enter data which has been arranged in rows. It is a [...]
How to recover unsaved Excel file
Are you looking for a way to recover unsaved Excel file? It happens to people all the time. Maybe a system crash or you forgot and close the window [...]
How to show formulas in excel (and not Values)
How to show cell formulas in Excel is one of the frequently asked questions about formulas. As soon as you enter a formula in a cell, Excel shows the [...]
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 [...]
Excel AutoFill using Fill handle or keyboard shortcuts
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 Auto Fill. With [...]
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. [...]
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 [...]
