How to Use the XLOOKUP Function in Excel (with Examples)

How to Use the XLOOKUP Function in Excel (with Examples)

Use the Excel XLOOKUP Function to Look Up Data (and Why It's Better than VLOOKUP) by Avantix Learning Team | Updated June 27, 2026 Applies to: Microsoft® Excel® 2021, 2024 and 365 (Windows) The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function...
How to Lock Cells in Excel (3 Ways)

How to Lock Cells in Excel (3 Ways)

Easily Lock Cells in Excel Worksheets by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 or 365 (Windows) It's easy to lock cells in Excel to protect data or formulas. This is typically a two-step process. First,...
How to Stop or Control Green Error Checking Markers in Excel

How to Stop or Control Green Error Checking Markers in Excel

Turn Off or Customize Error Checking Options (and Markers) in Excel by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) In Microsoft Excel, errors are flagged by default with a small green marker or...
How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

Protect Worksheets and Workbooks in Excel by Avantix Learning Team | Updated January 25, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 or 365 (Windows) You can password protect worksheets and workbooks in Excel. If you want to prevent other users from...
How to Zoom In and Out Excel (6 Ways with Shortcuts)

How to Zoom In and Out Excel (6 Ways with Shortcuts)

Zoom In and Out in Excel Using Keyboard Shortcuts, the Ribbon and the Status Bar by Avantix Learning Team | Updated June 30, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can save alot of time by learning how to quickly zoom in and...

Pin It on Pinterest