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…
0 Comments
April 5, 2021
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…
April 5, 2021
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…
March 21, 2021
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…
March 21, 2021
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…
March 21, 2021
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.…
March 21, 2021
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…
March 21, 2021
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…
March 21, 2021
How to create a pivot table in Excel
Excel offers a lot of powerful features to use while working with spreadsheets. Pivot tables are among them. A pivot table allows the user to group large data sets accordingly.…
March 21, 2021
How to use Excel VLOOKUP
I am sure you must be wondering, "what is VLOOKUP and what exactly does it do in Excel?" Well, it turns out it is among the most popular functions in…
March 21, 2021
- 1
- 2
- 3
- 4
- …
- 21
- Go to the next page