How can I create a macro in Excel?

A macro helps to automate tasks that you do repeatedly in excel. Take it as an algorithm with a set of instructions to follow and can be run several times.…

Comments Off on How can I create a macro in Excel?

How to calculate the sum of filtered cells

When one wants to hide data from the view, excel has a filter option that filters data in the worksheet. This also data into the filtered and the visible. It…

Comments Off on How to calculate the sum of filtered cells

How to look up a value after multiple criteria

Looking up a value in a table using one criteria is simple. You use a simple VLOOKUP formula. Things are much different when you want to use more than one…

Comments Off on How to look up a value after multiple criteria

How to copy an entire row in excel to another worksheet

In excel, you can move or copy entire rows to the destined sheets. (From the source sheet). You can copy entire rows automatically with automatic workflow. ​Steps on how to…

Comments Off on How to copy an entire row in excel to another worksheet

How to save Excel as a Read-only

We activate the Read-only feature in a workbook when we do not want any sensitive information modified by other end-users. The feature protects your whole workbook from being edited or…

Comments Off on How to save Excel as a Read-only

How to graph Excel data

Microsoft Excel is one of the most user-friendly and useful data management tools. It is used worldwide by most organizations to record, analyze and interpret data. It offers a lot…

Comments Off on How to graph Excel data

How to separate numbers and texts in Excel

When working in Microsoft Excel, you may encounter a situation where a cell's text is all jumbled up. Such a cell will contain numbers and texts, making it hard to…

Comments Off on How to separate numbers and texts in Excel

How to merge Excel files into one

You have several Excel files that make it harder for you to access data. You keep switching between different opened files, and this process takes a lot of your time.…

Comments Off on How to merge Excel files into one

How to make an Inventory List in Excel

Any retailer, salesperson, and wholesaler have to have an inventory management system. Keeping track of stocks without the help of professional software can be very tedious. Most people will look…

Comments Off on How to make an Inventory List in Excel

How to use true and false functions in Excel

Microsoft Excel is an excellent tool often used to keep track of data and other useful records. Among the various capabilities entailed in excel is the use of function and…

Comments Off on How to use true and false functions in Excel