إنشاء حساب
الرئيسية
الكورسات
Business
Microsoft Excel VBA Introduction 🧑‍💻 Complete Beginner Guide to Excel Automation (Full Course)
Excel VBA Introduction Part 58.15 - SQL for Excel Files - Pivoting Data Crosstab Queries

Excel VBA Introduction Part 58.15 - SQL for Excel Files - Pivoting Data Crosstab Queries

Microsoft Excel VBA Introduction 🧑‍💻 Complete Beginner Guide to Excel Automation (Full Course)

محتوى الكورس

جميع الدروس
146 درس
13:21 Excel VBA Introduction Part 1 - Getting Started in the VB Editor
35:10 Excel VBA Introduction Part 2 - Writing Your First VBA Macro
18:20 Excel VBA Introduction Part 3 - What to do When Things Go Wrong (Errors and Debugging)
15:53 Excel VBA Introduction Part 4 - Buttons, Toolbars and Keyboard Shortcuts
59:45 Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)
40:19 Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets
14:42 Excel VBA Introduction Part 7 - Workbooks
37:28 Excel VBA Introduction Part 8 - Variables
21:16 Excel VBA Introduction Part 9 - Object Variables
16:34 Excel VBA Introduction Part 10 - Message Boxes
20:35 Excel VBA Introduction Part 11.1 - Input Boxes
40:13 Excel VBA Introduction Part 11.2 - Application.InputBox
08:49 Excel VBA Introduction Part 12 - With Statements
17:55 Excel VBA Introduction Part 13 - If Statements
13:55 Excel VBA Introduction Part 14 - Select Case Statements
23:07 Excel VBA Introduction Part 15 - Do Until and Do While Loops
22:58 Excel VBA Introduction Part 15a - Find and FindNext
22:11 Excel VBA Introduction Part 16 - For Next Loops
31:47 Excel VBA Introduction Part 17 - For Each Loops
19:57 Excel VBA Introduction Part 18 - Creating Functions
34:58 Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)
41:01 Excel VBA Introduction Part 20.1 - Event Procedures
17:38 Excel VBA Introduction Part 20.2 - Application Events
04:53 Excel VBA Introduction Part 21 - User Forms
48:33 Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)
51:33 Excel VBA Introduction Part 23 - Text Files (FileSystemObjects)
36:25 Excel VBA Introduction Part 24 - File Dialogs
00:24 Excel VBA Introduction Part 25 - Arrays
32:01 Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum)
58:33 Excel VBA Introduction Part 27.1 - Creating Word Documents
32:15 Excel VBA Introduction Part 27.2 - Creating and Updating Linked Word Tables
17:18 Excel VBA Introduction Part 28.1 - Creating PowerPoint Presentations
39:07 Excel VBA Introduction Part 29.1 - Creating Outlook Emails
33:45 Excel VBA Introduction Part 29.2 - Outlook Email Events
20:23 Excel VBA Introduction Part 29.3 - Outlook Emails using the Word Editor
11:49 Excel VBA Introduction Part 29.4 - Inserting Pictures in Outlook Emails
21:23 Excel VBA Introduction Part 29.5 - Copying Emails from the Outlook Inbox
15:38 Excel VBA Introduction Part 29.6 - Referring to a Named Outlook Folder
20:24 Excel VBA Introduction Part 29.7 - Looping Through all Outlook Folders
19:09 Excel VBA Introduction Part 29.8 - Saving Attachments from an Outlook Folder
22:09 Excel VBA Introduction Part 29.9 - Finding Outlook Emails using Filters
15:21 Excel VBA Introduction Part 29.10 - Getting Emails from another Outlook Account
06:39 Excel VBA Introduction Part 29.11 - Sending Emails from another Outlook Account
24:17 Excel VBA Introduction Part 29.12 - Filtering Outlook Items using Restrict
30:12 Excel VBA Introduction Part 29.13 - DASL Filters in Outlook
22:06 Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database
59:47 Excel VBA Introduction Part 31 - ADO (ActiveX Data Objects) Modifying Data with Recordsets
23:13 Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
16:24 Excel VBA Introduction Part 33 - Creating Add Ins
14:49 Excel VBA Introduction Part 34 - Type Declarations (User-Defined Types)
59:32 Excel VBA Introduction Part 35 - Class Modules
16:23 Excel VBA Introduction Part 36 - Using Class Modules in Other Projects
25:23 Excel VBA Introduction Part 37 - Custom Collections
15:46 Excel VBA Introduction Part 38 - Typed Collections
26:24 Excel VBA Introduction Part 39 - Dictionaries
13:02 Excel VBA Introduction Part 40 - Disabling Screen Updates
14:26 Excel VBA Introduction Part 41 - Saving as a PDF
26:12 Excel VBA Introduction Part 43.1 - ByRef and ByVal
17:03 Excel VBA Introduction Part 43.2 - ByRef and ByVal (When to use Parentheses)
17:00 Excel VBA Introduction Part 44 - Making Excel Talk
26:23 Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell
47:06 Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables
26:00 Excel VBA Introduction Part 47.1 - Browsing to Websites and Scraping a Web Page
48:48 Excel VBA Introduction Part 47.2 - Scraping Website Tables and Clicking Links
36:30 Excel VBA Introduction Part 47.3 - Internet Explorer vs XML HTTP Request
25:39 Excel VBA Introduction Part 47.4 - Logging in to a Website with Windows Security
52:39 Excel VBA Introduction Part 47.5 - Basic HTTP GET and POST Requests
00:08 Excel VBA Introduction Part 48 - Web Scraping Across Multiple Pages
09:12 Excel VBA Introduction Part 49 - Downloading Files from Websites
01:43 Excel VBA Introduction Part 50.1 - Introduction to Charts in VBA
50:55 Excel VBA Introduction Part 50.2 - Embedding Charts in Worksheets
14:19 Excel VBA Introduction Part 50.3 - Conditional Formatting by Value in Charts
15:02 Excel VBA Introduction Part 50.4 - Highlighting Min and Max Values in a Chart
16:59 Excel VBA Introduction Part 50.5 - Formatting Bubble Charts by Bubble Size
23:59 Excel VBA Introduction Part 50.6 - Data Labels in Scatter Charts
44:29 Excel VBA Introduction Part 51.1 - Introduction to Pivot Tables in VBA
26:34 Excel VBA Introduction Part 51.2 - Pivot Tables using an Access Database
05:37 Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database
28:43 Excel VBA Introduction Part 51.4 - Pivot Tables and Consolidation Ranges
08:38 Excel VBA Introduction Part 51.5 - PowerPivot Data Models
37:05 Excel VBA Introduction Part 51.6 - Pivot Charts
29:17 Excel VBA Introduction Part 51.7 - Pivot Table Slicers
44:01 Excel VBA Introduction Part 51.8 - Pivot Table Date Fields and Timelines
43:00 Excel VBA Introduction Part 52.1 - Introduction to Shapes
21:17 Excel VBA Introduction Part 52.2 - Formatting Shapes
36:27 Excel VBA Introduction Part 52.3 - Adding Text to Shapes
06:43 Excel VBA Introduction Part 53.1 - Working with Strings
46:57 Excel VBA Introduction Part 53.2 - Splitting Strings
34:42 Excel VBA Introduction Part 53.3 - The Join Function and Concatenating Strings
39:43 Excel VBA Introduction Part 53.4 - Replacing Strings
45:35 Excel VBA Introduction Part 53.5 - Converting the Case of Text
53:08 Excel VBA Introduction Part 53.6 - The Asc and Chr Functions
22:37 Excel VBA Introduction Part 54.1 - The IIf Function
25:10 Excel VBA Introduction Part 54.2 - The Switch Function
46:57 Excel VBA Introduction Part 55.1 - Working with Dates
22:11 Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver
46:10 Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets
43:34 Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files
21:25 Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries
37:21 Excel VBA Introduction Part 56.5 - Basic ADO Commands
55:25 Excel VBA Introduction Part 56.6 - ADO Commands and Parameters
39:38 Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO
12:32 Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome
05:39 Excel VBA Introduction Part 57.2 - Basic Web Scraping with Selenium and Google Chrome
17:46 Excel VBA Introduction Part 57.3 - Using Different Web Browsers with Selenium
33:00 Excel VBA Introduction Part 57.4 - Finding Web Elements in Selenium
48:01 Excel VBA Introduction Part 57.5 - Implicit and Explicit Waits in Selenium
36:58 Excel VBA Introduction Part 57.6 - Working with Multiple Tabs in Selenium
44:16 Excel VBA Introduction Part 57.7 - Using Select Drop Down Lists in Selenium
26:30 Excel VBA Introduction Part 57.8 - Printing in Google Chrome using Selenium
40:08 Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements
16:03 Excel VBA Introduction Part 58.2 - SQL for Excel Files - Sorting Rows in a Query
15:08 Excel VBA Introduction Part 58.3 - SQL for Excel Files - Selecting the Top N Rows
18:24 Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows
21:28 Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query
24:13 Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator
46:14 Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns
50:33 Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions
30:36 Excel VBA Introduction Part 58.9 - SQL for Excel Files - Nulls in Expressions
53:13 Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions
44:52 Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions
25:00 Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions
28:22 Excel VBA Introduction Part 58.13 - SQL for Excel Files - Grouping Rows
16:09 Excel VBA Introduction Part 58.14 - SQL for Excel Files - Criteria in the Having Clause
20:08 Excel VBA Introduction Part 58.15 - SQL for Excel Files - Pivoting Data Crosstab Queries
19:53 Excel VBA Introduction Part 58.16 - SQL for Excel Files - Basic Union Queries
28:59 Excel VBA Introduction Part 58.17 - SQL for Excel Files - Union Queries with Total Rows
12:48 Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files
30:24 Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner Joins
25:36 Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins
19:47 Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins
12:39 Excel VBA Introduction Part 58.22 - SQL for Excel Files - Join Worksheets from Multiple Files
24:22 Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side
24:08 Excel VBA Introduction Part 58.24 - SQL for Excel Files - Consolidate Worksheets with Derived Tables
25:54 Excel VBA Introduction Part 58.25 - SQL for Excel Files - Basic Subqueries
17:20 Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries
26:36 Excel VBA Introduction Part 58.27 - SQL for Excel Files - Correlated Subqueries
26:17 Excel VBA Introduction Part 58.28 - SQL for Excel Files - Inserting Data into an Existing Sheet
18:37 Excel VBA Introduction Part 58.29 - SQL for Excel Files - Select Data into a New Sheet or Workbook
26:13 Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data
18:23 Excel VBA Introduction Part 58.31 - SQL for Excel Files - Split a Table into Separate Sheets
12:19 Wise Owl Answers - How do I list all properties of a file using VBA?
06:35 Excel VBA Introduction Part 57.1 (Oct 2023) - Getting Started with Selenium Basic and Google Chrome
14:14 Wise Owl Answers - How do I add Videos to PowerPoint Slides with VBA?
16:53 Wise Owl Answers - How do I make a VBA event work in every workbook?
28:02 Wise Owl Answers - How do I speed up calculations in Excel VBA?