Effective Rate of Return in Excel
Learn how to calculate the effective rate of return in Excel. The Effective Annual Return (EAR) is the annual rate per year of an investment taking into consideration …
Multiple Criteria XLOOKUP
Learn how to use XLOOKUP with multiple criteria in Excel. In our example, we will show how you can use the XLOOKUP Function with multiple criteria. The functionality …
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. …
Use FLASH FILL In Excel
Learn how to use the FLASH FILL feature in Excel. Flash Fill quickly looks at similar cells and automatically picks up commonalities. Let’s look at the following data …
Calculate Shipping Days Left in a Month
Quickly learn how to calculate the number of shipping days left in a month using a simple formula in Excel. Does your job require you ship packages or …
Single Cell Text List with Dynamic Response
Dealing with a single cell text list can be challenging in Excel. You cannot use VLOOKUP or XLOOKUP as search functions to returns results. Additionally, depending on the …
Set Negative values to Zero
When working in Excel, it may be required to set negative values to zero. For example, if you are trying to determine how much positive income you generated …
How to use the CAMERA Tool in Excel
Learn how to use the Camera tool in Excel. Unlike most tools in Excel, the Camera tool is not very well known. In fact, in order to use …
Add Camera Tool to the Quick Access Toolbar
https://youtu.be/yrxelE1bXk4 Adding the Camera tool to the Quick Access Toolbar The Camera tool allows you to select a range of cells and literally insert a live picture into …
Insert Picture Into Cell in Excel
Learn how to add images to cells in Excel. Also use them with a filter. In order to get started, you need to have specific images you would …