Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!
Aulas do Curso
(146 vídeos)
0 de 146 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Excel VBA Introduction Part 1 - Getting Started in the VB Editor
You may prefer the more up-to-date version of this video in our Excel VBA Online Course Playlist https://www.youtube.com…
1
Excel VBA Introduction Part 2 - Writing Your First VBA Macro
You may prefer the more up-to-date version of this video in our Excel VBA Online Course Playlist
https://www.youtube.com…
2
Excel VBA Introduction Part 3 - What to do When Things Go Wrong (Errors and Debugging)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
3
Excel VBA Introduction Part 4 - Buttons, Toolbars and Keyboard Shortcuts
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
4
Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
5
Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
6
Excel VBA Introduction Part 7 - Workbooks
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
7
Excel VBA Introduction Part 8 - Variables
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
8
Excel VBA Introduction Part 9 - Object Variables
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
9
Excel VBA Introduction Part 10 - Message Boxes
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
10
Excel VBA Introduction Part 11.1 - Input Boxes
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
11
Excel VBA Introduction Part 11.2 - Application.InputBox
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
12
Excel VBA Introduction Part 12 - With Statements
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
13
Excel VBA Introduction Part 13 - If Statements
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
14
Excel VBA Introduction Part 14 - Select Case Statements
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
15
Excel VBA Introduction Part 15 - Do Until and Do While Loops
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
16
Excel VBA Introduction Part 15a - Find and FindNext
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
17
Excel VBA Introduction Part 16 - For Next Loops
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
18
Excel VBA Introduction Part 17 - For Each Loops
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
19
Excel VBA Introduction Part 18 - Creating Functions
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
20
Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
21
Excel VBA Introduction Part 20.1 - Event Procedures
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
22
Excel VBA Introduction Part 20.2 - Application Events
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
23
Excel VBA Introduction Part 21 - User Forms
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
24
Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
25
Excel VBA Introduction Part 23 - Text Files (FileSystemObjects)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
26
Excel VBA Introduction Part 24 - File Dialogs
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
27
Excel VBA Introduction Part 25 - Arrays
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
28
Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
29
Excel VBA Introduction Part 27.1 - Creating Word Documents
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
30
Excel VBA Introduction Part 27.2 - Creating and Updating Linked Word Tables
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
31
Excel VBA Introduction Part 28.1 - Creating PowerPoint Presentations
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
32
Excel VBA Introduction Part 29.1 - Creating Outlook Emails
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
33
Excel VBA Introduction Part 29.2 - Outlook Email Events
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
34
Excel VBA Introduction Part 29.3 - Outlook Emails using the Word Editor
By Andrew Gould
https://www.wiseowl.co.uk - This video explains how to use the Word Editor of an email created in Outlo…
35
Excel VBA Introduction Part 29.4 - Inserting Pictures in Outlook Emails
By Andrew Gould
https://www.wiseowl.co.uk - This video explains how to write VBA code in Excel to insert a picture from…
36
Excel VBA Introduction Part 29.5 - Copying Emails from the Outlook Inbox
By Andrew Gould
https://www.wiseowl.co.uk - In this video you'll learn how to loop over the items in the Outlook Inbox …
37
Excel VBA Introduction Part 29.6 - Referring to a Named Outlook Folder
By Andrew Gould
https://www.wiseowl.co.uk - This video explains how to reference and loop over the items in a named fol…
38
Excel VBA Introduction Part 29.7 - Looping Through all Outlook Folders
By Andrew Gould
https://www.wiseowl.co.uk - This video explains how to loop over the folder and subfolder structure in …
39
Excel VBA Introduction Part 29.8 - Saving Attachments from an Outlook Folder
By Andrew Gould
https://www.wiseowl.co.uk - This video explains how to save the attachments from a collection of emails…
40
Excel VBA Introduction Part 29.9 - Finding Outlook Emails using Filters
By Andrew Gould
https://www.wiseowl.co.uk - in this video you'll learn how to use the Find method and filters in Outloo…
41
Excel VBA Introduction Part 29.10 - Getting Emails from another Outlook Account
By Andrew Gould
https://www.wiseowl.co.uk - Learn how to reference folders in multiple accounts in the same Outlook pro…
42
Excel VBA Introduction Part 29.11 - Sending Emails from another Outlook Account
By Andrew Gould
https://www.wiseowl.co.uk - This video briefly explains how to choose which account is used to send ema…
43
Excel VBA Introduction Part 29.12 - Filtering Outlook Items using Restrict
By Andrew Gould
Download the finished file here - https://www.wiseowl.co.uk/vba-macros/videos/vba-outlook/outlook-filte…
44
Excel VBA Introduction Part 29.13 - DASL Filters in Outlook
By Andrew Gould
Download file here https://www.wiseowl.co.uk/vba-macros/videos/vba-outlook/outlook-dasl-filter/
https:…
45
Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
46
Excel VBA Introduction Part 31 - ADO (ActiveX Data Objects) Modifying Data with Recordsets
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
47
Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
48
Excel VBA Introduction Part 33 - Creating Add Ins
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
49
Excel VBA Introduction Part 34 - Type Declarations (User-Defined Types)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
50
Excel VBA Introduction Part 35 - Class Modules
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
51
Excel VBA Introduction Part 36 - Using Class Modules in Other Projects
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
52
Excel VBA Introduction Part 37 - Custom Collections
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
53
Excel VBA Introduction Part 38 - Typed Collections
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
54
Excel VBA Introduction Part 39 - Dictionaries
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
55
Excel VBA Introduction Part 40 - Disabling Screen Updates
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
56
Excel VBA Introduction Part 41 - Saving as a PDF
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
57
Excel VBA Introduction Part 43.1 - ByRef and ByVal
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
58
Excel VBA Introduction Part 43.2 - ByRef and ByVal (When to use Parentheses)
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
59
Excel VBA Introduction Part 44 - Making Excel Talk
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
60
Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
61
Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
62
Excel VBA Introduction Part 47.1 - Browsing to Websites and Scraping a Web Page
TRY THE GOOGLE CHROME VERSION https://youtu.be/y7yWL0oCB3k
PLEASE NOTE: x-rates.com now uses https rather than http. Pl…
63
Excel VBA Introduction Part 47.2 - Scraping Website Tables and Clicking Links
By Andrew Gould
https://www.wiseowl.co.uk - In this video you'll learn how to write VBA code to click links on a webpag…
64
Excel VBA Introduction Part 47.3 - Internet Explorer vs XML HTTP Request
By Andrew Gould
NOTE: the URL used in this video no longer exists although similar pages are available on the same webs…
65
Excel VBA Introduction Part 47.4 - Logging in to a Website with Windows Security
By Andrew Gould
Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/login-windows-secur…
66
Excel VBA Introduction Part 47.5 - Basic HTTP GET and POST Requests
By Andrew Gould
Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/get-post-requests/
…
67
Excel VBA Introduction Part 48 - Web Scraping Across Multiple Pages
PLEASE NOTE: The design of the website used in this video has changed since the video was recorded. This means that the…
68
Excel VBA Introduction Part 49 - Downloading Files from Websites
PLEASE NOTE: The design of the website used in this video has changed since the video was recorded. This means that the…
69
Excel VBA Introduction Part 50.1 - Introduction to Charts in VBA
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
70
Excel VBA Introduction Part 50.2 - Embedding Charts in Worksheets
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
71
Excel VBA Introduction Part 50.3 - Conditional Formatting by Value in Charts
By Andrew Gould
https://www.wiseowl.co.uk - Looping over the points of a chart and testing the value of each should be …
72
Excel VBA Introduction Part 50.4 - Highlighting Min and Max Values in a Chart
By Andrew Gould
https://www.wiseowl.co.uk - In this video you'll learn how to highlight the minimum and maximum values …
73
Excel VBA Introduction Part 50.5 - Formatting Bubble Charts by Bubble Size
By Andrew Gould
https://www.wiseowl.co.uk - In this video you'll learn how to test the size of each bubble in a bubble …
74
Excel VBA Introduction Part 50.6 - Data Labels in Scatter Charts
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
75
Excel VBA Introduction Part 51.1 - Introduction to Pivot Tables in VBA
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
76
Excel VBA Introduction Part 51.2 - Pivot Tables using an Access Database
By Andrew Gould
Download the Excel workbook and Access database here https://www.wiseowl.co.uk/vba-macros/videos/vba-pi…
77
Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
78
Excel VBA Introduction Part 51.4 - Pivot Tables and Consolidation Ranges
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
79
Excel VBA Introduction Part 51.5 - PowerPivot Data Models
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
80
Excel VBA Introduction Part 51.6 - Pivot Charts
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
81
Excel VBA Introduction Part 51.7 - Pivot Table Slicers
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this lin…
82
Excel VBA Introduction Part 51.8 - Pivot Table Date Fields and Timelines
By Andrew Gould
Download the Excel workbook here https://www.wiseowl.co.uk/videos/excelvba/pivot-tables-introduction.ht…
83
Excel VBA Introduction Part 52.1 - Introduction to Shapes
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
84
Excel VBA Introduction Part 52.2 - Formatting Shapes
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
85
Excel VBA Introduction Part 52.3 - Adding Text to Shapes
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
86
Excel VBA Introduction Part 53.1 - Working with Strings
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
87
Excel VBA Introduction Part 53.2 - Splitting Strings
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
88
Excel VBA Introduction Part 53.3 - The Join Function and Concatenating Strings
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
89
Excel VBA Introduction Part 53.4 - Replacing Strings
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
90
Excel VBA Introduction Part 53.5 - Converting the Case of Text
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
91
Excel VBA Introduction Part 53.6 - The Asc and Chr Functions
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
92
Excel VBA Introduction Part 54.1 - The IIf Function
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
93
Excel VBA Introduction Part 54.2 - The Switch Function
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
94
Excel VBA Introduction Part 55.1 - Working with Dates
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this li…
95
Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver
Download the files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/ado-sqlserver-msoledbsql/
By…
96
Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets
Download the files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/ado-recordset-sql/
By Andrew…
97
Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files
Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/ado-execute-sql-query-file/
By A…
98
Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries
Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/ado-multiple-resultsets/
By Andr…
99
Excel VBA Introduction Part 56.5 - Basic ADO Commands
Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/ado-commands-sql/
By Andrew Goul…
100
Excel VBA Introduction Part 56.6 - ADO Commands and Parameters
Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/ado-parameters/
By Andrew Gould
…
101
Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO
By Andrew Gould
Download files here https://drive.google.com/open?id=1dZKAbIUq09WjKPB1gArKlixI1-78xz6c
https://www.wis…
102
Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you …
103
Excel VBA Introduction Part 57.2 - Basic Web Scraping with Selenium and Google Chrome
By Andrew Gould
You can download the completed file here https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-website…
104
Excel VBA Introduction Part 57.3 - Using Different Web Browsers with Selenium
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you …
105
Excel VBA Introduction Part 57.4 - Finding Web Elements in Selenium
By Andrew Gould
Completed code https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/find-elements-selenium/
…
106
Excel VBA Introduction Part 57.5 - Implicit and Explicit Waits in Selenium
By Andrew Gould
Download completed file here https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/implicit-e…
107
Excel VBA Introduction Part 57.6 - Working with Multiple Tabs in Selenium
See more web scraping videos here https://youtube.com/playlist?list=PLNIs-AWhQzcl3xKvF8sVL4sWRWICj_clM
If you'd like to…
108
Excel VBA Introduction Part 57.7 - Using Select Drop Down Lists in Selenium
By Andrew Gould
See more web scraping videos here https://youtube.com/playlist?list=PLNIs-AWhQzcl3xKvF8sVL4sWRWICj_clM
…
109
Excel VBA Introduction Part 57.8 - Printing in Google Chrome using Selenium
By Andrew Gould
See more web-scraping videos here https://youtube.com/playlist?list=PLNIs-AWhQzcl3xKvF8sVL4sWRWICj_clM
…
110
Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
111
Excel VBA Introduction Part 58.2 - SQL for Excel Files - Sorting Rows in a Query
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
112
Excel VBA Introduction Part 58.3 - SQL for Excel Files - Selecting the Top N Rows
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
113
Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
114
Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
115
Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
116
Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
117
Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
118
Excel VBA Introduction Part 58.9 - SQL for Excel Files - Nulls in Expressions
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
119
Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
120
Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
121
Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
122
Excel VBA Introduction Part 58.13 - SQL for Excel Files - Grouping Rows
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
123
Excel VBA Introduction Part 58.14 - SQL for Excel Files - Criteria in the Having Clause
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
124
Excel VBA Introduction Part 58.15 - SQL for Excel Files - Pivoting Data Crosstab Queries
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Worki…
125
Excel VBA Introduction Part 58.16 - SQL for Excel Files - Basic Union Queries
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
126
Excel VBA Introduction Part 58.17 - SQL for Excel Files - Union Queries with Total Rows
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
127
Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
128
Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner Joins
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
129
Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
130
Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
131
Excel VBA Introduction Part 58.22 - SQL for Excel Files - Join Worksheets from Multiple Files
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
132
Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
133
Excel VBA Introduction Part 58.24 - SQL for Excel Files - Consolidate Worksheets with Derived Tables
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
134
Excel VBA Introduction Part 58.25 - SQL for Excel Files - Basic Subqueries
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
135
Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
136
Excel VBA Introduction Part 58.27 - SQL for Excel Files - Correlated Subqueries
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
137
Excel VBA Introduction Part 58.28 - SQL for Excel Files - Inserting Data into an Existing Sheet
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
138
Excel VBA Introduction Part 58.29 - SQL for Excel Files - Select Data into a New Sheet or Workbook
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
139
Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
140
Excel VBA Introduction Part 58.31 - SQL for Excel Files - Split a Table into Separate Sheets
By Andrew Gould
Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBA…
141
Wise Owl Answers - How do I list all properties of a file using VBA?
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you c…
142
Excel VBA Introduction Part 57.1 (Oct 2023) - Getting Started with Selenium Basic and Google Chrome
By Andrew Gould
Excel VBA Getting Data from Websites playlist https://youtube.com/playlist?list=PLNIs-AWhQzcl3xKvF8sVL4…
143
Wise Owl Answers - How do I add Videos to PowerPoint Slides with VBA?
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you c…
144
Wise Owl Answers - How do I make a VBA event work in every workbook?
By Andrew Gould
This video shows you how to use VBA in Excel to enable application-level events which will run in any w…
145
Wise Owl Answers - How do I speed up calculations in Excel VBA?
By Andrew Gould
Download files here https://www.wiseowl.co.uk/vba-macros/blogs/vba/variables-arrays/array-calculations/…