Latest Blog Posts

How to Randomly Select a Winner in Excel (2 Methods)

Dataset Overview Let's assume we have the following dataset. Now we want to select a random winner from the list. Method 1 - Select a ...

What Is Radar Chart in Excel ( 2 Practical Examples)

Microsoft Excel has some built-in charts. The Radar Chart is one of them which is also known as the spider chart, polar chart, web chart, and star ...

How to Make Yes 1 and No 0 in Excel (2 Effective Methods)

Method 1 - Make Yes 1 and No 0 Using IF Function in Excel Steps: Click on cell D5. Enter the following formula and press Enter. ...

How to Count Negative Numbers in Excel (3 Easy Ways)

We often have negative numbers in our Excel dataset. Negative numbers can create a problem while calculating in Excel. So, it is important to count ...

Make Credit Card Payoff Calculator with Amortization in Excel

A credit card can be a blessing or a curse. It all depends on a person’s financial knowledge. This article will show you quick steps to create a ...

How to Create a List of Special Characters in Excel – 3 Methods

  The dataset below contains the Character Code of all special characters. Method 1 -  Using the CHAR Function to Create a List of ...

How to Make a Forest Plot in Excel (2 Methods)

What Is a Forest Plot? A Forest plot, also known as a blobbogram, is a graphical representation that displays the results of multiple studies in a ...

How to Forecast Cash Flow in Excel (with Detailed Steps)

  Step 1: Forecasting Total Cash Inflows     We will calculate each particular given's value in the following dataset. ...

Excel Conditional Formatting Icon Sets Based on Another Cell

It is sometimes necessary to format a lot of data in Excel in certain ways for better readability when dealing with a large amount of data. If you ...

How to Create Weekly Cash Flow Statement Format in Excel

Step 1 - Record Time Intervals for the Weekly Cash Flow Statement Let’s assume our cash entries will be made weekly. Select cell C4. Write ...

How to Create a Scoring System in Excel (With Easy Steps)

Step 1 - Input Data in Excel In this example, we’ll show the evaluation process of 3 employees in a certain company. You’ll see 4 criteria for ...

Up and Down Arrows in Excel Using Conditional Formatting

Having up and down arrows in the proper places of datasets makes them more presentable and visually pleasing. Excel's default arrow formatting ...

Conditional Formatting Icon Sets Based on Text in Excel

Consider the following dataset containing some students marks, with remarks on these marks. By using icon sets we can highlight these remarks easily. ...

How to Add Up and Down Arrows in Excel (4 Easy Ways)

In the dataset for this tutorial, you will find fields for the name of the Stock companies, yesterday’s closing price(YCP), Present Price, and the ...

How to Draw to Scale in Excel (2 Easy Ways)

We'll draw a simple floor plan to scale. Method 1 - Using Border Options to Draw to Scale in Excel Step 1 - Setting Up Row Height and Column ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo