IF Function

Excel Practice & Exercises with IF Function

This article contains seven Excel practice exercises related to the IF function. The problems are easy to solve, so you will only need a basic level ...

How to Apply Abbreviation Using Formula in Excel

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single ...

How to Use Money in Excel (with Easy Steps)

A crucial ability, effective money usage becomes even more crucial in terms of various trading, transactions, budget etc. In this article, we'll walk ...

How to Create Table from Another Table in Excel (3 Easy Ways)

Sometimes when dealing with Excel tables, we need to create a new table depending on requirements from the existing data. In this article, I'll ...

How to Randomize a List in Excel Without Duplicates (4 Ways)

Certainly, Microsoft Excel excels at arranging and manipulating data. Now, it is a well-known fact that Excel has numerous dedicated functions to ...

Ageing Formula with Current Date in Excel (4 Examples)

While working in Microsoft Excel sometimes we need to calculate age from the current date. This is mostly needed when we are determining the ages of ...

How to Add Tags in Excel (2 Simple Ways)

Tags are often used in Excel and are very useful for maneuvering data. They save time and are very efficient. In this article, we will show you how ...

How to Create Invoice in Excel with Database (with Easy Steps)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Encode Survey Data in Excel (with Easy Steps)

If you are looking for ways to encode survey data in Excel, then you are in the right place. Here, we will show 4 easy steps for doing this task. ...

How to Remove Rows Containing Identical Transactions in Excel

In many cases, we record transactions in Excel. And in various ways, we may include the same data in multiple rows which causes problems when we work ...

How to Create an Order Form in Excel (with Useful Steps)

If you are looking for how to create an order form in Excel, then you are in the right place. For international or any domestic business we need to ...

How to Consolidate Columns in Excel (Vertically and Horizontally)

You might frequently need to consolidate two or more columns into one. However, to meet your needs, you must combine them into one column. You could ...

How to Convert Decimal to Binary in Excel (3 Quick Methods)

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious calculations in the blink of an eye. In ...

How to Format Zip Code to 5 Digits in Excel (5 Easy Methods)

While working in Microsoft Excel sometimes we need to format zip code to 5 digits so that we can work more productively. If we change zip codes one ...

How to Reduce Decimal Places in Excel Permanently (5 Ways)

If you are looking for ways to reduce decimal places in Excel permanently, then you are in the right place. There are many easy ways to reduce ...

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo