Latest Blog Posts

Excel VBA: If Cell Contains Value Then Return a Specified Output

In the sample dataset of examination record for Sunflower Kindergarten school, the blank cells mean that the student was absent for that particular ...

How to Subtract Time in Excel -10 Methods

Method 1. Subtracting Time between Two Cells to Get the Elapsed Time The following dataset contains the ‘Entry Time’ & ‘Exit Time’. ...

How to Calculate the Accrued Interest on a Fixed Deposit in Excel – 3 Methods

  This is the sample dataset. It showcases Fixed Deposit (P), Annual Rate (r), Interest accrued per Year (n) and Years elapsed (t). To ...

Car Loan Calculator in Excel Sheet

Are you going to buy a car with a bank loan and worried about the loan-related calculation? You have come to the right place. We hope this article ...

How to Use the Exponential Growth Formula in Excel (2 Methods)

Method 1 - Using the Excel GROWTH Formula Description The GROWTH function in Excel predicts future exponential growth based on existing data. ...

How to Freeze the Top 3 Rows in Excel (3 Methods)

  Method 1 - Using the Freeze Panes Command to Freeze the Top 3 Rows Steps: Select the 4th row. Go to the View tab and click on Freeze ...

How to Calculate Dividend Growth Rate in Excel (2 Methods)

While doing stock valuation, you need to find the dividend growth rate for accomplishing a better decision. Interestingly, you can compute the growth ...

How to Print Selected Area in Excel (2 Examples)

You will need to print Worksheets on a number of occasions. There are times, however, when publishing the entire report is unnecessary, resulting in ...

How to Hide Rows Based on Cell Value in Excel (5 Methods)

We have a Sales dataset consisting of columns Order Date, Region, Product, and Quantity. We want to use any of the cell values in the column to hide ...

How to Use Profit and Loss Percentage Formula in Excel (4 Ways)

In this article we will cover several simple and effective ways to use a profit and loss percentage formula in Excel. To demonstrate our methods, ...

VBA to Customize Row Height in Excel (6 Methods)

In this article, we will show you how to customize row height in Excel with a VBA macro, including how to set new row heights, change row height for ...

How to Print Graph in Excel (5 Ways)

We have a data table of two columns called the Yearly Revenue Increment. If we plot a stacked column chart of it, it looks like the following: ...

How to Repeat a Number Pattern in Excel (5 Methods)

Suppose you have the following dataset: Method 1 - Use a Keyboard Shortcut to Repeat a Number Pattern Steps (Single Repeated Cell): ...

How to Apply a Percentage Formula in Multiple Cells in Excel – 5 Methods

The sample dataset showcases Salesman, Product, and Net Sales of a company.   Method 1 - Using the Excel Division Symbol and the ...

How to Calculate the Credit Card Interest in Excel – 3 Steps

To calculate the interest on a credit card you need to know the Current Balance, Minimum Payment Percentage, and Annual Interest Rate. This is the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo