Excel made easy

Database of Excel tips and tutorials.

Latest Excel Tips and Tutorials

Calculating the Principal and Interest on a Loan

Calculating the principal and interest on a loan in Excel involves using a few simple formulas. Here’s a step-by-step tutorial:

New Excel Features in 2023

Microsoft Excel has been a mainstay of data analysis for decades, and it continues to evolve with each passing year. In 2023, Microsoft has introduced a range of …

New Excel Features in 2023 Read More »

OFFSET Function in Excel

Learn how to use the offset function in Excel for efficient data manipulation.

Use VBA code to calculate Compound Annual Growth Rate

You can use VBA code to calculate compound annual growth rate in Excel. Let’s start by looking at the following code. To use the function in a worksheet, …

Use VBA code to calculate Compound Annual Growth Rate Read More »

Use VBA and XLOOKUP together!

Learn how to use VBA and XLOOKUP Function together. In this example, the VBA macro will prompt the user to enter a search value, and then use the …

Use VBA and XLOOKUP together! Read More »

Learn about XLOOKUP

Learn how to use the XLOOKUP function in Excel. See for yourself why this new function makes Excel that much easier.

XLOOKUP with Multiple Criteria
Perform an XLOOKUP with multiple Criteria using concatenate features in Excel
XLOOKUP Horizontal Lookup
With XLOOKUP, you no longer have to use the very limited HLOOKUP function.
XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently!
Fix XLOOKUP #SPILL Error
Learn to easily fix an XLOOKUP #SPILL Error in Excel.