Latest Blog Posts

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

Reducing Balance EMI Calculator in Excel Sheet (Create with Easy Steps)

Assume you have secured a loan of $1,000 at the annual rate of 14.49%. You can repay the loan in 12 equated monthly installments (EMI). ...

Daily Income and Expense Sheet in Excel (Create with Detailed Steps)

Step 1 - Record Income and Expense Data Create a new worksheet named Dataset and make three columns named Date, Income, and Expense. ...

How to Calculate Income Tax on Salary with Example in Excel

In this article, we will demonstrate different methods to calculate Income Tax on Salary. To illustrate our methods, we'll use the following sample ...

How to Calculate Price of a Semi Annual Coupon Bond in Excel (2 Ways)

If you are looking for some special tricks to calculate the price of a semi-annual coupon bond in Excel, you've come to the right place. There are ...

How to Consolidate Data by Category in Excel?

Sometimes, we collect data in different worksheets. To merge them into a single worksheet, we can use the consolidation process. In the consolidation ...

[Solved]: Track Changes Not Showing in Excel (with Easy Fix)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Solve the “Excel Array Formula Not Showing Results” Problem (4 Solutions)

Dataset Overview To illustrate our solutions, we’ll work with a dataset containing four columns: Car, Unit Sold, Unit Price, and Revenue. Our goal ...

How to Calculate Clean Price of a Bond in Excel (3 Easy Ways)

Generally, on financial news sites, the clean price of a bond is the quoted price. The price doesn’t include accrued interest. The clean price is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo