• Login
  • Courses
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • VBA Code Generator
  • Contact

Power Spreadsheets

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

Excel VBA Select Case And Operator in 5 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel VBA Select Case And Operator

In this Excel VBA Select Case And Operator Tutorial, you learn how to create an Excel VBA Select Case And operator statement to conditionally execute a set of statements based on: An expression's value; and The And Operator. The Excel VBA Select Case And operator snippet template/structure you learn in this Tutorial is a specific application of more general Excel VBA Select … [Read more...]

Excel Nested XLOOKUP (Dynamic Lookup Value) in 7 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel Nested XLOOKUP (Dynamic Lookup Value)

In this Excel Nested XLOOKUP (Dynamic Lookup Value) Tutorial, you learn how to create an Excel nested XLOOKUP (dynamic lookup value) formula, where the lookup value for one XLOOKUP depends on the result of another XLOOKUP. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel Nested XLOOKUP (Dynamic Lookup Value) Tutorial is accompanied by … [Read more...]

Excel VBA Select Case Or in 5 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel VBA Select Case Or

In this Excel VBA Select Case Or Tutorial, you learn how to create an Excel VBA Select Case Or statement to conditionally execute a set of statements based on: An expression's value, and Whether this value matches any 1 of several values inside a single case expression (Value1 Or Value2 Or ... Or Value#). The Excel VBA Select Case Or snippet template/structure you learn in … [Read more...]

Excel XLookup Return All Matches in 3 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel XLookup return all matches

In this Excel XLookup Return All Matches Tutorial, you learn how to create an Excel XLookup return all matches formula. The Excel XLookup return all matches formula template/structure you learn below relies on the FILTER function. FILTER is available in Excel 2021 and later (including Excel 365). This Excel XLookup Return All Matches Tutorial is accompanied by an Excel workbook … [Read more...]

Excel VBA Select Case Range of Cells in 8 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel VBA Select Case Range of Cells

In this Excel VBA Select Case Range of Cells Tutorial, you learn how to create an Excel VBA Select Case range of cells statement to: Repeatedly execute a set of statements (including a nested Select Case statement) for each cell inside a range of cells; and (On each loop iteration) Conditionally execute a set of statements based on an expression's value. This Excel VBA Select … [Read more...]

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • …
  • 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–2023 PDS Intelligence Pte. Ltd. All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.