Latest Blog Posts

How to Change Case in Excel Sheet (8 Quick Methods)

While working in Microsoft Excel we might find different cases like lowercase, and uppercase in different cells. Sometimes you will find upper and ...

How to Make Office Expense Sheet in Excel (with Easy Steps)

Here's an overview of how a sample office expense sheet might look. You can customize this template later. How to Make an Office Expense ...

How to Make a Family Budget in Excel (2 Effective Ways)

The article will show you how to make a family budget in Excel. Excel is a very useful tool to calculate mathematical problems in a very efficient ...

Excel VBA: Turn Off Auto Calculate

In this article, I’ll show you how you can turn off auto calculate using in Excel. Excel VBA: Turn Off Auto Calculate (Quick View) Sub ...

How to Calculate BMI in Excel (2 Methods)

BMI Calculation BMI stands for Body Mass Index. It’s a simple method that uses height and weight to determine a person’s body status. By calculating ...

How to Separate Address in Excel Using Formula (With Easy Steps)

We have the following dataset which contains some addresses. We will separate the address into parts separated by comma. Step 1 - Merge ...

Excel Change to Proper Case Without Formula (6 Easy Ways)

Looking for ways to know how you can change to proper case without formula in Excel? Then, this is the right place for you. Here, you will find 6 ...

How to Check Edit History in Excel Online: 5 Methods

Method 1 - Save Excel Workbook in Onedrive Save the workbook in Onedrive following the procedure below: Turn on the Autosave option in the ...

Create Home Loan EMI Calculator in Excel Sheet with Prepayment Option

What Is Home Loan EMI? EMI stands for Equated Monthly Installment, which is the amount of money that you need to pay monthly on a home loan. The ...

How to Make a Household Budget in Excel (With Easy Steps)

A planned life is a secure life. We love to plan our life. But most often it does not get along with our plans. We plan again considering the ...

How to Group Data in Excel Chart: 2 Suitable Methods

Method 1 - Group Adjusting Lineup of Source Data in Excel Chart STEPS: Select the whole data in range B4:D11. Go to the Insert tab on the ...

How to Automatically Calculate the Percentage in an Excel Spreadsheet – 2 Methods

Method 1 - Using an Excel Formula to Automatically Calculate the Percentage 1.1 Using the Conventional Percentage Formula The dataset showcases the ...

How to Make Personal Expense Sheet in Excel (with Easy Steps)

If you are looking for some easy and effective tricks to make a personal expense sheet in Excel then you are in the right place. Every person must ...

How to Calculate Bond Price with Negative Yield in Excel (2 Easy Ways)

People need to calculate the Bond Price considering the future value of the Bond. Some of the Bonds have the risk of having a Negative Yield. If you ...

How to Calculate Simple Interest and Compound Interest in Excel (2 Ways)

  What Is Simple Interest? Simple Interest doesn’t compound. In other words, Simple Interest is the interest calculated on the principal ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo