Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns
Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions
Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions
Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query
Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator
Excel VBA Introduction Part 58.9 - SQL for Excel Files - Nulls in Expressions
Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions
Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins
Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data
Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files
Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions
Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries
Excel VBA Introduction Part 58.29 - SQL for Excel Files - Select Data into a New Sheet or Workbook
Excel VBA Online Course - 2.1.1 Selecting Single Cells
Excel VBA Online Course - 2.2.2 Selecting an Entire List
Working with Power Pivot, Pivot Tables, and DAX in VBA | Pt. 3
Introduction to SQL Programming for Excel Users Part 19 - More CASE WHEN
029 Joining on Multiple Fields
insert Data to Database
Python | Openpyxl | Macro enabled files