Use XLOOKUP with multiple sheets
To use XLOOKUP with multiple sheets, you can specify the sheet name followed by an exclamation point (!) in front of the cell range. For example, if you …
Excel Basics
Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.
Advanced Xlookup and VBA Equations
Advanced Xlookup and VBA equations in Excel can include complex conditional statements, loops, and custom functions to perform more complex calculations and manipulations. Here are a few examples: …
Xlookup Equation to Compare Text
Let’s look at the following Xlookup equation to compare text in Excel. In this formula, value to look up is the text you want to compare, range to …
Quick History of Microsoft Excel 1987 to 2023
Learn the detailed history of Microsoft Excel. Microsoft Excel is a spreadsheet software program developed by Microsoft Corporation. It was first released for the Macintosh in 1985 and …
Freeze Column or Row in Excel
Learn to freeze a column or row in Excel. Go to “Toolbar Ribbon” and Select “View” – “Freeze Panes“ This brings up 3 options: Freeze Panes – Allows …
Relative Reference in Excel
Relative Reference in Excel points to a cell or range of cells. However, this is pointed to cell is not locked like an absolute referenced cell. In Excel, …