Excel Templates

How to Perform Interest Rate Swap Calculation in Excel

Step 1 - Set Up the Format We'll use the following information: Notional Amount - This is the original swap amount for both ...

How to Create a Calendar with Time Slots in Excel (Easy Steps)

We will create a calendar for 1 week for ease of understanding. However, you will get the monthly calendar in the downloadable excel file. ...

How to Create Project Management Calendar in Excel

When we work on any project, it’s very important to create a schedule for different tasks. A calendar for project management can help a lot in this ...

How to Create an Event Calendar in Excel (with Easy Steps)

An Excel Event Calendar is a tool that tracks and schedules events, meetings, and appointments in a calendar format. It can be a useful tool for ...

How to Perform Pipeline Design Calculations in Excel (2 Examples)

Method 1 - Finding Pipe Diameter for Pipeline Design Calculations Steps: Enter the given data. Use the following formula to find the ...

How to Create an Automatic Schedule Generator in Excel (Easy Steps)

Step 1 - Prepare the Dataset Dataset Selection: Assume we have a dataset named “Project Timeline of ABC Multipurpose Bridge.” However, feel ...

How to Create Pipeline Chart in Excel (2 Easy Ways)

We have the sales number of different stores of a product arranged in descending order. We will use this data to create the pipeline chart. ...

How to Create Social Security Break Even Calculator in Excel: 6 Methods

Method 1 - Insert Primary Information Insert basic information to compare two ages and 100% benefits in the dataset. Method 2 - ...

How to Create Monthly Duty Roster Format in Excel

To create a monthly duty roster in Excel, first we'll create a roster template, then fill the roster for a specific month into this remplate as an ...

How to Make an Effort Estimation Sheet in Excel: 4 Easy Methods

Method 1 - Using Parametric Estimation Steps: Enter the following formula in cell G5. =C5/(D5*E5*F5) Drag the Fill Handle tool ...

How to Create an Attendance Roster in Excel (with Easy Steps)

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employees’ ...

How to Create Weekly Duty Roster Format in Excel

Let's take a sample dataset that represents the roster format of a company. Step 1 - Insert Staff Details Insert 3 sub-headers ...

How to Do Kernel Density Estimation in Excel (with Detailed Steps)

What Is Kernel Density Estimation? The kernel density estimation is the process of estimating the probability density function for random values. ...

How to Create Project Pipeline in Excel: 2 Suitable Methods

Method 1 - Creating Project Pipeline Manually in Excel Step 1: Create Table for Project Pipeline Write all required terms that are important to ...

How to Create Test Cases for an ATM Machine in Excel – 3 Steps

Step 1: Setting Up Format Create the following fields - Test Scenario: The test scenario for the test cases. Tester: The person ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo