Latest Blog Posts

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 ...

How to Change Sentence Case in Excel (6 Ideal Examples)

When you are working with addresses or customer/employee names, then you may need to change the sentence case into other cases. This article shows ...

How to Use Formula to Track Cell Changes in Excel (with Easy Steps)

In many cases, we may need to track the cell changes in Microsoft Excel. We can track cell changes using an Excel formula. This is a very convenient ...

How to Resolve an Excel Formula Not Working Unless Double-Clicking (5 Solutions)

Solution 1 - Formula Calculation Options Set to Manual Check if your Calculation Options are set to Manual. To change this: Go to Formulas, ...

Weight Loss Spreadsheet in Stones and Pounds

Tracking weight loss is essential for keeping fit. Fortunately, Microsoft Excel allows us to easily track our weight loss in a spreadsheet. With this ...

Excel VBA: Create a Progress Bar While Macro Is Running

Step 1 - Open the Visual Basic Window Press Alt + F11 to open the Visual Basic window. Step 2 - Insert a New UserForm Go to the ...

How to Print Barcode Labels in Excel – 4 Steps

Step 1 - Prepare Data The dataset showcases products and their price. Add a column with the heading “Barcode” and enter the values of the ...

How to Calculate EMI for Bike Loan in Excel (2 Easy Methods)

MS Excel is a powerful software. Here, we can perform many different mathematical operations. It provides numerous built-in functions which are ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo