Latest Blog Posts

How to Calculate Operating Cash Flow Using Formula in Excel

Operating cash flow quantifies the cash generated by a company from its core operations over a given time frame. As Microsoft Excel implements ...

How to Apply Top and Bottom Border in Excel (3 Efficient Ways)

In this Excel tutorial, we will explain how to apply Top and Bottom border. In the image below, the cells on the left don't have borders, but on ...

How to Concatenate Email Addresses in Excel – 4 Methods

This is the sample dataset. Method 1 - Using the Ampersand to Concatenate Email Addresses in Excel Steps: In C11, enter the ...

How to Convert Text to Columns Without Overwriting in Excel

Frequently, we need to convert text to columns in Excel in our day-to-day tasks. In fact, Microsoft Excel is an excellent tool to perform this task. ...

How to Create a Rent Payment Spreadsheet in Excel (Step-by-Step)

  We have the data of an owner with 5 shops rented by different renters. We will calculate the rents for October 2022 from the shops. Below ...

How to Generate 2D Barcode in Excel (with Easy Steps)

Microsoft Excel can help your business's inventory management and barcode management procedures by acting as a barcode formulator and converting ...

How to Calculate Percentage of Completion in Excel (3 Methods)

We have a dataset with some Dates, Tasks that need to be completed, and their Status, explaining whether they are completed. We will calculate the ...

How to Create Proforma Invoice for Advance Payment in Excel

In this article, we will describe in detail how to create a proforma invoice for advance payment in Excel. A Proforma invoice is used to request ...

Calculate 5 Year CAGR Using Formula in Excel: 7 Ways

Method 1 - Using Arithmetic Formula Steps: Go to the C12 cell >> and enter the formula given below. =(C10/C5)^(1/5)-1 The C5 ...

How to Calculate Compound Interest in Excel in Indian Rupees

In this tutorial, I am going to show you 5 easy methods to calculate compound interest in Excel in Indian rupees. You can use these methods even in ...

How to Concatenate Rows in Excel with Comma (4 Easy Methods)

We'll use the following example where we have a list of G-7 countries in 7 rows (B5 to B11). We'll put the entire list in a single cell, with the ...

How to Rename a Sheet Without Using Mouse in Excel (2 Ways)

While working in Excel, we often have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. For ...

How to Add a Comment on a Graph in Excel (3 Easy Methods)

We will consider a dataset of Sales of ABC Traders from B4 to C10. We will add a chart and add a comment on it. Method 1 - Adding a ...

How to Create Quarterly Comparison Chart in Excel: 5 Easy Methods

Method 1 - Use Pie Chart for One Set of Quarterly Data Comparison Steps: Select the range B4:C8. Go to the Insert Choose a pie- chart. ...

How to Use Comparison Bar Chart in Excel (2 Practical Examples)

Example 1 - Year-over-Year Comparison with a Bar Chart We have the data for goals scored by famous footballers in the 2016/17 and 2015/16 seasons. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo