Category: Excel

Find out a few VBA macros to split Excel sheets into multiple worksheets and check out whether there are other options to do this.

Looking for how to use Excel SUMIF + VLOOKUP together? In this article, you’ll learn how these two useful functions can be combined in a single formula!

Learn how to use the Excel SUMIF and SUMIFS functions with date criteria. Examples and common uses for are included.

There are several ways to extract data from Excel: you can use functions and formulas, filters, and even data integration solutions for automated data extraction. Find out the details.

Learn different methods to consolidate data in Excel from rows, ranges, worksheets, and workbooks. Easy to follow steps for Excel data consolidation.

Learn the options for how to implement the IMPORTRANGE equivalent for Excel in a native way or with a third-party solution.

VLOOKUP formula example and explanation of how to compare two columns in Excel using the VLOOKUP function.

VLOOKUP formula example and explanation of how to vlookup for two values in Excel.

We explain different types of Excel VLOOKUP wildcard. We also share examples for each wildcard and explain how to troubleshoot any issues.

Excel XLOOKUP is a function that makes a look up to the left or to the right, top to bottom or bottom to top, and allows for wildcards.