Latest Blog Posts

How to Find Spearman Rank Correlation Coefficient in Excel (2 Ways)

In this article, you will learn 2 different ways to find the Spearman rank correlation coefficient in Excel. What Is Spearman Rank Correlation ...

How to Protect Excel File with Password (3 Quick Methods)

For a confidential workbook, we just need to protect it with a password for security purposes. Excel has several ways to do it easily. You can set ...

How to Create a Sales Report in Excel (6 Easy Steps)

Dataset Overview Let's create a sales report for a mobile shop by using three different datasets as shown below: Step 1 - Retrieve Product ...

How to Protect Formulas but Allow Copy in Excel (3 Simple Methods)

This tutorial will demonstrate how to protect Excel formulas but will allow you to copy them. Suppose, we will share our Excel file with other users. ...

Amortization Schedule with Balloon Payment and Extra Payments in Excel

  What Is an Amortization Schedule in Excel? An amortization schedule is a table-format repayment plan for monthly bills, loans, or a ...

How to Prevent Formula from Being Deleted in Excel: 3 Methods

Method 1 - Locking Cells to Prevent Formula from Being Deleted in Excel STEPS: Select a cell in your dataset and press Ctrl + A to select all ...

How to Share Excel File for Multiple Users

We have an Excel file named Sales Report of Frutis.xlsx and need to share the file with multiple users. Method 1 - Share the Excel File ...

How to Send Bulk Email from Outlook Using Excel (3 Ways)

We will use the sample list below and try to send emails to these email ids with the help of Excel, Outlook, Word, and Power Automate using 3 ...

How to Convert CSV to Excel with Columns (5 Methods)

  Method 1 - Applying Save As to Convert CSV Files to Excel with Columns We have opened our sample CSV file in Notepad. The data in the file ...

[Fix:] Excel Formula Not Working Returns 0

If your Excel formula not working returns 0, this article will help you to solve the problem. Here, we’ll describe 4 reasons that are responsible for ...

Excel Not Responding When Running Macros (9 Possible Solutions)

Overview Getting the following pop-up when running macros? Large files, internal code issues, and complicated macros are just a few things that can ...

How to Undo Changes in Excel after Save and Close (2 Methods)

Let's use a sample dataset that contains columns for Employee Name, Department, and Salary data. We'll make some changes and undo them after you've ...

Excel VBA: Unprotect Workbook with Password: 7 Practical Methods

Method 1 - Unprotect a Single Workbook with a Password in Excel VBA Task: Unprotect the workbook named workbook_1.xlsx inside the Exceldemy folder ...

How to Recover Corrupted Excel File (8 Possible Ways)

Method 1 - Using the Open and Repair Tool of Microsoft Excel STEPS:  Go to the File tab > Open. Set the file destination in the ...

How to Transpose Rows to Columns Based on Criteria in Excel (2 Ways)

Download the Practice Workbook Transpose Rows to Columns with Criteria.xlsm 2 Handy Approaches to Transpose Rows to Columns Based on ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo