How to Remove Time from Date and Time in Excel
When using Excel, we will often find ourselves in a situation where we have to manipulate data. More often than not, these data…
Author: Harun Spahic
Excel: differences Between SUMPRODUCT, SUMIF, and SUMIFS
If you had an encounter with Excel in the past, you must have used some of the basic formulas that Excel has: SUM,…
Conditional Formatting in Excel
We already explained where the Conditional Formatting is located in Excel, and that it can be used to highlight cells or a range…
How to Create Calendar in Excel
Surely, you have been in a situation where you had to use date type in Excel. Among all the data that you can…
Use If with Values in a List in Excel
When we use the IF function for whatever reason, we need to have certain criteria that have to be met in order for…
How to Delete Pivot Table in Excel
So far, you surely know how to create a Pivot table in Excel. But, when you want to delete these data, you can…
How to Use If Function With Dates in Excel
You can often find yourself in a situation where you have certain dates in your data set and you want to compare them…
Find the Smallest and Largest Value in the Range in Excel
Suppose that we have an Excel table that has three columns: annual salary, loan amount, and loan duration. This table does not have…
Format Cells in Excel Based on the Condition or Content
There are a lot of times when you have a set of data in Excel, and you need to highlight certain figures, numbers,…
How to Use Find and Replace in Excel Formulas
We have all been in a situation where we realize that we have made the same error in a whole document, or a…
