How to Calculate Antilog in Excel (Easy Formula)
Logarithmic functions are often used when dealing with exponential values in your data. So when you have a log function, you might probably need to find the antilog at some …
Formulas
10 Best Excel Books (that will make you an Excel Pro)
When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, you can also consider using Excel books …
How to Compare Two Columns in Excel (using VLOOKUP & IF)
When you’re working with data in Excel, sooner or later you will have to compare data. This could be comparing two columns or even data in different sheets/workbooks. In this …
How to Remove Formulas in Excel (and keep the data)
Watch Video – How to Remove Formulas in Excel Sometimes you may want to remove formulas from the worksheets but keep the data. It is also recommended to remove formulas …
Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples
If you want to test more than one condition then you need to use the If statement. The “If Statement” is used in many programming languages. The Excel users also …
How to Remove Dashes (-) in Excel?
Sometimes, you may get data (text or numbers) that have dashes (or hyphens) in it. If you want to remove these dashes in Excel, you can use a couple of …
What does $ (dollar sign) mean in Excel Formulas?
If you have worked with Excel formulas, I am sure you have noticed that sometimes there is a $ symbol as a part of the cell references. If you’re wondering …
How to use Excel If Statement with Multiple Conditions Range [AND/OR]
To perform complicated and powerful data analysis, you need to test various conditions at a single point in time. The data analysis might require logical tests also within these multiple …
How to Print Row Numbers in Excel (3 Easy Ways)
When printing out an Excel worksheet, we usually just need to see the data. We don’t really care much for the location of the data, neither do we want to …
How to Sum Positive Numbers in Excel – Easy Formula
For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …
How to Count Negative Numbers in Excel – Easy Formula
Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …
How to Convert Date to Day of Week in Excel (3 Easy Ways)
When working with date-specific information, there might be instances where you need to find the day of the week corresponding to a date. For example, instead of the date, you …