Amortization Schedule in Excel
This example shows you how to create an Amortization Schedule in Excel for a loan. In this email, we will look at an auto loan where we finance …
Excel Basics
Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.
Combo Box in Excel with Form Control
A Combo Box in Excel is a drop-down list, you can select a value from the list. There are multiple ways you can add a combo box in …
XLOOKUP with Multiple Criteria
In order to perform an XLOOKUP with multiple Criteria, you need to concatenate the lookup values and arrays. In our example, this is achieved by using “&” between …
Calculate Steel Pricing by hundredth weight (CWT)
Learn how to quickly calculate steel pricing by hundredth weight (CWT) using the following formula. For a quicker option, download the demonstration file. Quickly download the spreadsheet: Calculate …
Calculate Steel Pricing by hundredth weight (CWT) Read More »
Password Protect Excel Sheets
Learn how to quickly password protect an Excel Sheet. In Excel, you can quickly set password protection to any document. When a user, including yourself, opens the protected …
Fix Data Validation Greyed Out
Have you ever run across the Data Validation box Greyed out in Excel? The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet. …