• Login
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • Contact

Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

Excel XLOOKUP in Table in 4 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel XLOOKUP in Table

In this Excel XLOOKUP in Table Tutorial, you learn how to create an Excel XLOOKUP in Table formula to carry out an XLOOKUP inside an Excel Table. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel XLOOKUP in Table Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by … [Read more...]

Excel Convert Celsius to Fahrenheit in 3 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel Convert Celsius to Fahrenheit

In this Excel Convert Celsius to Fahrenheit Tutorial, you learn how to create an Excel convert Celsius to Fahrenheit formula. This Excel Convert Celsius to Fahrenheit Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below. Related Excel Training Materials and Resources This … [Read more...]

Excel XLOOKUP Between 2 Values in 4 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel XLOOKUP Between 2 Values

In this Excel XLOOKUP Between 2 Values Tutorial, you learn how to create an Excel XLOOKUP between 2 values formula. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel XLOOKUP Between 2 Values Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button … [Read more...]

Excel Convert Cm to Inches in 3 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel Convert Cm to Inches

In this Excel Convert Cm to Inches Tutorial, you learn how to create an Excel convert cm to inches formula. This Excel Convert Cm to Inches Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below. Related Excel Training Materials and Resources This Excel Convert Cm to Inches … [Read more...]

Excel IF XLOOKUP (for Error Handling) in 10 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel IF XLOOKUP (for Error Handling)

In this Excel IF XLOOKUP (for Error Handling) Tutorial, you learn how to create an Excel IF XLOOKUP (for error handling) formula, where you: Combine the XLOOKUP and IF functions; To handle (certain) potential errors (returned by XLOOKUP). The Excel IF XLOOKUP (for error handling) formula template/structure you learn below relies on the XLOOKUP and LET functions. XLOOKUP and … [Read more...]

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • …
  • 23
  • Next Page »

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA. Here are some of my most popular Excel Training Resources:

  1. Free Excel VBA Email Course
  2. Excel Macro Tutorial for Beginners
  3. Excel Power Query (Get and Transform) Tutorial for Beginners
  4. Excel Keyboard Shortcut Cheat Sheet
  5. Excel Resources
Terms and Conditions

Privacy Policy

Limit of Liability and Disclaimer of Warranty

Affiliate Disclosure

Copyright © 2015–2025 365 Power Labs All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.