XLOOKUP Horizontal Lookup
Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform […]
XLOOKUP Horizontal Lookup Read More »
Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.
Learn to perform a horizontal lookup using XLOOKUP. With XLOOKUP, you no longer have to use the very limited HLOOKUP function. In the example below, we will perform […]
XLOOKUP Horizontal Lookup Read More »
What is Boolean logic in Excel? So, how do you use Boolean logic and how can it be used in Excel. Changes are you have heard this term
Boolean Logic in Excel Read More »
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
Effective Rate of Return in Excel Read More »
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
Multiple Criteria XLOOKUP Read More »
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.
Fix Data Validation Greyed Out Read More »
Learn how to use the FLASH FILL in Excel. Flash Fill quickly looks at similar cells and automatically picks up commonalities. Let’s look at the following data set.
Use FLASH FILL In Excel Read More »