Latest Blog Posts

How to Change Comma in Excel to Indian Style (with Easy Steps)

Similar to how India uses the 2, 2, 3 system of number value accounting for lakhs, the U.S. uses 3, 3, 3 for millions. We will show you how to change ...

How to Calculate Percentage Completed Based on Dates in Excel: 4 Methods

A starting and an ending date are needed. We’ll use the TODAY function for the current date. You can input any date. To illustrate, we’ll use the ...

How to Calculate the Prorated Salary in Excel – 3 Methods

  The dataset showcases Employee name, Joining Date, and Ending Date. Method 1 - Using the YEARFRAC Function to Calculate the ...

How to Create a Barcode Scanner to Track Check-in & Check-out Times in Excel (Step-by-Step)

  Step 1: Insert a Command Button in Excel Define a cell where you will put the input barcode. Here, I will put it in cell C4. Create a ...

How to Create Budget and Expense Tracker in Excel

Looking for ways to create a budget and expense tracker in Excel? Then, this is the right place for you. We can keep track of the budget, actual ...

How to Draw a Cash Flow Diagram in Excel (Easy Steps)

Introduction to Cash Flow Diagrams Cash flow diagrams represent cash transactions over time. They’re commonly used in finance, engineering, ...

How to Calculate Utilization Percentage in Excel: 3 Methods

Method 1 - Calculate Utilization Percentage of Working Hours ✍️ Steps: Select a cell (i.e. C6) where you want to get the utilization percentage ...

How to Cap Percentage Values Between 0 and 100 in Excel (3 Methods)

What Is Cap Percentage? Cap percentage can be defined as a percentage limit in which your dataset percentage will be contained. For example, you ...

How to Change the Decimal Separator in Excel -7 Methods

The Decimal Separator The decimal separator (also known as the radix character) is used to separate the integer and fractional parts of a number. It ...

How to Create a Salary Increase Matrix in Excel

What Is a Salary Increase Matrix? A salary increase matrix, also known as a merit increase matrix or merit matrix, is a mathematical grid used ...

How to Add 1 Hour to Time in Excel (7 Examples)

Example 1 - Applying Conventional Formula   Steps: Enter the following formula in Cell D5. =C5+(1/24) Press Enter and use ...

Leave Salary Calculation in Excel (With Easy Steps)

Step 1 - Creating the Dataset The dataset for the Leave Salary Calculation should include the employee names and a few quantities like Total working ...

How to Create Convertible Bond Pricing Model in Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. I will show ...

How to Calculate Savings Percentage in Excel: 3 Easy Methods

Method 1 - Utilizing Percent Style Button Step 01: Calculate Fraction of Discount Create a new column named Savings Percentage, as shown in the ...

How to Calculate Lag Time in Excel (2 Methods)

What Is Lag Time? Lag Time or Time Lag is a delay between two successive tasks, whereas the later task should start as soon as the earlier task ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo