Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query
Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions
Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns
Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements
Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator
Excel VBA Introduction Part 58.15 - SQL for Excel Files - Pivoting Data Crosstab Queries
Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows
Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data
Excel VBA Introduction Part 58.2 - SQL for Excel Files - Sorting Rows in a Query
Excel VBA Introduction Part 58.3 - SQL for Excel Files - Selecting the Top N Rows
Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins
Excel VBA Introduction Part 58.14 - SQL for Excel Files - Criteria in the Having Clause
Excel VBA Online Course - 4.1.1 Declaring Basic Variables
Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files
Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner Joins
Wise Owl Answers - How do I copy data without using copy and paste in Excel VBA?
Excel VBA Online Course - 4.1.3 Non Declared Variables
Integrate Excel, VBA and SQL. Simplified and powerful
Wise Owl Answers - How do I get data from a closed Excel file using VBA?
SQL query to assign values based on multiple criteria (case statement)