User Posts: ASM Arman
0
How to Reduce the Size of Formula Bar in Excel (3 Methods)
0

Whiles writing large formulas in Excel or presenting an Excel worksheet to a group of audiences, you might need to increase the size of the formula bar for ...

0
[Fixed]: Excel Formula Not Showing Correct Result (8 Methods)
0

While using formulas in Excel, you might not get the result you expect the formula will return, or sometimes the formula will even throw an error. Getting such ...

0
How to Remove Used Items from Drop Down List in Excel (2 Methods)
0

While working with data validation in Excel, you might need to remove used items from the drop-down list to avoid assigning an item in the list twice. For ...

0
How to Create a Drop Down List with Unique Values in Excel (4 Methods)
0

While working with categorical information in Excel i.e., products of different categories, you might need to create a drop-down list with unique values from ...

1
How to Calculate First Day of Previous Month in Excel (2 Methods)
1

If you are working with dates in Excel, you might need to find out the first day of the month before the current month you are working with. In Excel, you can ...

0
How to Count Unique Values Based on Criteria in Another Column in Excel
0

If you are working on different categories of information in an Excel worksheet, you might need to find out and count all the unique values of the categories ...

0
How to Convert Number to Text and Keep Trailing Zeros in Excel (4 Ways)
0

While converting numbers to text in Excel, you will find that Excel removes the trailing zeros after the decimal point of a number. There is a simple solution ...

0
How to Copy Conditional Formatting to Another Cell in Excel (2 Methods)
0

If you use specific conditional formatting to highlight cells based on some specific conditions, you might want to copy the conditional formatting to another ...

0
How to Group Cells with Same Value in Excel (3 Methods)
0

If you are working with data with different categories or have cells with the same value in your Excel worksheet, then you might need to group the cells with ...

0
How to Select a Range of Cells in Excel Formula (4 Methods)
0

While using formulas in Excel, we have to insert a specific range of cells to make the formula work or get the desired result. In this tutorial, I will show ...

0
Excel VBA: Get Cell Value from Another Workbook without Opening
0

If you are working with different Excel files that contain the same type of information i.e, information of the employees from different departments of a large ...

0
How to Remove Blanks from List Using Formula in Excel (4 Methods)
0

While working with a list of any kind i.e, a list of products or a list of employees you might come across a lot of blank cells in it. While such blank cells ...

1
Excel Advanced Filter: Apply “Does Not Contain” (2 Methods)
0

You can use the Does Not Contain feature of Advance Filter to filter out the rows that do not contain a specific text or multiple texts. In this tutorial, I ...

0
How to Undo Delete Sheet in Excel (3 Methods)
0

Sometimes you might accidentally delete the worksheet or even the whole workbook you are working on. This could be a disaster if you are working with important ...

0
How to Delete Columns without Losing Formula in Excel (3 Easy Steps)
0

If your datasheet contains both formulas and values, you need to apply some techniques to delete the contents or the cell values in a column or a range without ...

Browsing All Comments By: ASM Arman

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo