IF Function

How to Put 0 in Excel in Front of Numbers (5 Handy Methods)

While working on an Excel worksheet, you may see that Excel doesn’t allow 0 before any numbers. So, you can’t make a column with the same number of ...

How to Keep Track of Invoices and Payments in Excel (3 Ideal Examples)

The article shows how to keep track of invoices and payments in excel. It’s pretty important for daily activities in a shop or market. Keeping track ...

Convert Fraction to Decimal in Excel (2 Simple Approaches)

When working with numbers and calculations, it is a common thing to get fractions or decimals as results. Sometimes it happens that, the result is ...

Fill Down to Next Value in Excel (5 Easy Methods)

In many usages of Excel, we sometimes encountered random empty cells in the Excel worksheet. In most of the cases because their uppermost non-blank ...

How to Drag Formula Horizontally with Vertical Reference in Excel

Sometimes you might need to drag the formula horizontally with the vertical reference. In other words, you have to utilize the Fill Handle Tool for ...

How to Make an Eisenhower Matrix Template in Excel (With Easy Steps)

This tutorial will be a step-by-step guideline to make an Eisenhower Matrix template in Excel. The Eisenhower Matrix is very useful to fix the ...

How to Reduce Decimals in Excel (10 Easy Methods)

The article will show you 10 effective and easy methods on how to reduce decimals in Excel. Sometimes, you may have repeating decimals or irrational ...

How to Create a Recruitment Tracker in Excel (Download Free Template)

If you are looking for some special tricks to create a recruitment tracker in Excel, you've come to the right place. There is one way to create a ...

How to Keep Track of Customer Payments in Excel (With Easy Steps)

Having a payment tracker template is fundamental in all sorts of business that contains Customer Payments. The invoice number, date of payment, ...

How to Set Decimal Places in Excel with Formula (5 Effective Ways)

This tutorial will explain how to set decimal places in Excel with a formula. Sometimes, we may need to get values up to a fixed decimal place. For ...

How to Track Multiple Projects in Excel (Download Free Template)

On a regular day, A project manager has to manage multiple projects at once. Tracking those projects could be tedious if they are not organized ...

How to Create a Task Tracker in Excel (Download Free Template)

Although there is no direct tool to track tasks in Excel, we can use a combination of different functions and formulas to create a dynamic task ...

How to Track Stocks in Excel (Download Free Template)

Many people invest in the stock market to profit from their idle money. Almost every country has a stock exchange office in their big cities for the ...

How to Maintain Store Inventory in Excel (Step by Step Guide)

For checking the performance of your business, you might have needed to maintain store inventory. It’s quite difficult to handle such type of report ...

How to Create Student Database in Excel (With Easy Steps)

Databases can reliably handle a huge amount of data and information. They contain levels of data that'd be incomprehensible on a worksheet since they ...

ExcelDemy
Logo