Excel VBA Introduction Course | Complete Beginner Guide to Excel Automation -

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

عدد الدروس : 146 عدد ساعات الدورة : 84:36:31 شهادة معتمدة : نعم التسجيل في الدورة للحصول على شهادة

للحصول على شهادة

1- التسجيل
2- مشاهدة الكورس كاملا
3- متابعة نسبة اكتمال الكورس تدريجيا
4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك

A structured Excel VBA introduction course covering VB Editor, macros, debugging, cells, worksheets, workbooks, and automation basics.

قائمة الدروس

1 - Excel VBA Introduction Part 1 - Getting Started in the VB Editor

2 - Excel VBA Introduction Part 2 - Writing Your First VBA Macro

3 - Excel VBA Introduction Part 3 - What to do When Things Go Wrong (Errors and Debugging)

4 - Excel VBA Introduction Part 4 - Buttons, Toolbars and Keyboard Shortcuts

5 - Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)

6 - Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets

7 - Excel VBA Introduction Part 7 - Workbooks

8 - Excel VBA Introduction Part 8 - Variables

9 - Excel VBA Introduction Part 9 - Object Variables

10 - Excel VBA Introduction Part 10 - Message Boxes

11 - Excel VBA Introduction Part 11.1 - Input Boxes

12 - Excel VBA Introduction Part 11.2 - Application.InputBox

13 - Excel VBA Introduction Part 12 - With Statements

14 - Excel VBA Introduction Part 13 - If Statements

15 - Excel VBA Introduction Part 14 - Select Case Statements

16 - Excel VBA Introduction Part 15 - Do Until and Do While Loops

17 - Excel VBA Introduction Part 15a - Find and FindNext

18 - Excel VBA Introduction Part 16 - For Next Loops

19 - Excel VBA Introduction Part 17 - For Each Loops

20 - Excel VBA Introduction Part 18 - Creating Functions

21 - Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)

22 - Excel VBA Introduction Part 20.1 - Event Procedures

23 - Excel VBA Introduction Part 20.2 - Application Events

24 - Excel VBA Introduction Part 21 - User Forms

25 - Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)

26 - Excel VBA Introduction Part 23 - Text Files (FileSystemObjects)

27 - Excel VBA Introduction Part 24 - File Dialogs

28 - Excel VBA Introduction Part 25 - Arrays

29 - Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum)

30 - Excel VBA Introduction Part 27.1 - Creating Word Documents

31 - Excel VBA Introduction Part 27.2 - Creating and Updating Linked Word Tables

32 - Excel VBA Introduction Part 28.1 - Creating PowerPoint Presentations

33 - Excel VBA Introduction Part 29.1 - Creating Outlook Emails

34 - Excel VBA Introduction Part 29.2 - Outlook Email Events

35 - Excel VBA Introduction Part 29.3 - Outlook Emails using the Word Editor

36 - Excel VBA Introduction Part 29.4 - Inserting Pictures in Outlook Emails

37 - Excel VBA Introduction Part 29.5 - Copying Emails from the Outlook Inbox

38 - Excel VBA Introduction Part 29.6 - Referring to a Named Outlook Folder

39 - Excel VBA Introduction Part 29.7 - Looping Through all Outlook Folders

40 - Excel VBA Introduction Part 29.8 - Saving Attachments from an Outlook Folder

41 - Excel VBA Introduction Part 29.9 - Finding Outlook Emails using Filters

42 - Excel VBA Introduction Part 29.10 - Getting Emails from another Outlook Account

43 - Excel VBA Introduction Part 29.11 - Sending Emails from another Outlook Account

44 - Excel VBA Introduction Part 29.12 - Filtering Outlook Items using Restrict

45 - Excel VBA Introduction Part 29.13 - DASL Filters in Outlook

46 - Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database

47 - Excel VBA Introduction Part 31 - ADO (ActiveX Data Objects) Modifying Data with Recordsets

48 - Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)

49 - Excel VBA Introduction Part 33 - Creating Add Ins

50 - Excel VBA Introduction Part 34 - Type Declarations (User-Defined Types)

51 - Excel VBA Introduction Part 35 - Class Modules

52 - Excel VBA Introduction Part 36 - Using Class Modules in Other Projects

53 - Excel VBA Introduction Part 37 - Custom Collections

54 - Excel VBA Introduction Part 38 - Typed Collections

55 - Excel VBA Introduction Part 39 - Dictionaries

56 - Excel VBA Introduction Part 40 - Disabling Screen Updates

57 - Excel VBA Introduction Part 41 - Saving as a PDF

58 - Excel VBA Introduction Part 43.1 - ByRef and ByVal

59 - Excel VBA Introduction Part 43.2 - ByRef and ByVal (When to use Parentheses)

60 - Excel VBA Introduction Part 44 - Making Excel Talk

61 - Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell

62 - Excel VBA Introduction Part 46 - Querying Web Pages using Query Tables

63 - Excel VBA Introduction Part 47.1 - Browsing to Websites and Scraping a Web Page

64 - Excel VBA Introduction Part 47.2 - Scraping Website Tables and Clicking Links

65 - Excel VBA Introduction Part 47.3 - Internet Explorer vs XML HTTP Request

66 - Excel VBA Introduction Part 47.4 - Logging in to a Website with Windows Security

67 - Excel VBA Introduction Part 47.5 - Basic HTTP GET and POST Requests

68 - Excel VBA Introduction Part 48 - Web Scraping Across Multiple Pages

69 - Excel VBA Introduction Part 49 - Downloading Files from Websites

70 - Excel VBA Introduction Part 50.1 - Introduction to Charts in VBA

71 - Excel VBA Introduction Part 50.2 - Embedding Charts in Worksheets

72 - Excel VBA Introduction Part 50.3 - Conditional Formatting by Value in Charts

73 - Excel VBA Introduction Part 50.4 - Highlighting Min and Max Values in a Chart

74 - Excel VBA Introduction Part 50.5 - Formatting Bubble Charts by Bubble Size

75 - Excel VBA Introduction Part 50.6 - Data Labels in Scatter Charts

76 - Excel VBA Introduction Part 51.1 - Introduction to Pivot Tables in VBA

77 - Excel VBA Introduction Part 51.2 - Pivot Tables using an Access Database

78 - Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database

79 - Excel VBA Introduction Part 51.4 - Pivot Tables and Consolidation Ranges

80 - Excel VBA Introduction Part 51.5 - PowerPivot Data Models

81 - Excel VBA Introduction Part 51.6 - Pivot Charts

82 - Excel VBA Introduction Part 51.7 - Pivot Table Slicers

83 - Excel VBA Introduction Part 51.8 - Pivot Table Date Fields and Timelines

84 - Excel VBA Introduction Part 52.1 - Introduction to Shapes

85 - Excel VBA Introduction Part 52.2 - Formatting Shapes

86 - Excel VBA Introduction Part 52.3 - Adding Text to Shapes

87 - Excel VBA Introduction Part 53.1 - Working with Strings

88 - Excel VBA Introduction Part 53.2 - Splitting Strings

89 - Excel VBA Introduction Part 53.3 - The Join Function and Concatenating Strings

90 - Excel VBA Introduction Part 53.4 - Replacing Strings

91 - Excel VBA Introduction Part 53.5 - Converting the Case of Text

92 - Excel VBA Introduction Part 53.6 - The Asc and Chr Functions

93 - Excel VBA Introduction Part 54.1 - The IIf Function

94 - Excel VBA Introduction Part 54.2 - The Switch Function

95 - Excel VBA Introduction Part 55.1 - Working with Dates

96 - Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver

97 - Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets

98 - Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files

99 - Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries

100 - Excel VBA Introduction Part 56.5 - Basic ADO Commands

101 - Excel VBA Introduction Part 56.6 - ADO Commands and Parameters

102 - Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO

103 - Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome

104 - Excel VBA Introduction Part 57.2 - Basic Web Scraping with Selenium and Google Chrome

105 - Excel VBA Introduction Part 57.3 - Using Different Web Browsers with Selenium

106 - Excel VBA Introduction Part 57.4 - Finding Web Elements in Selenium

107 - Excel VBA Introduction Part 57.5 - Implicit and Explicit Waits in Selenium

108 - Excel VBA Introduction Part 57.6 - Working with Multiple Tabs in Selenium

109 - Excel VBA Introduction Part 57.7 - Using Select Drop Down Lists in Selenium

110 - Excel VBA Introduction Part 57.8 - Printing in Google Chrome using Selenium

111 - Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements

112 - Excel VBA Introduction Part 58.2 - SQL for Excel Files - Sorting Rows in a Query

113 - Excel VBA Introduction Part 58.3 - SQL for Excel Files - Selecting the Top N Rows

114 - Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows

115 - Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query

116 - Excel VBA Introduction Part 58.6 - SQL for Excel Files - Text Criteria and the Like Operator

117 - Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns

118 - Excel VBA Introduction Part 58.8 - SQL for Excel Files - Conditional Functions

119 - Excel VBA Introduction Part 58.9 - SQL for Excel Files - Nulls in Expressions

120 - Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions

121 - Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions

122 - Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions

123 - Excel VBA Introduction Part 58.13 - SQL for Excel Files - Grouping Rows

124 - Excel VBA Introduction Part 58.14 - SQL for Excel Files - Criteria in the Having Clause

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

126 - Excel VBA Introduction Part 58.16 - SQL for Excel Files - Basic Union Queries

127 - Excel VBA Introduction Part 58.17 - SQL for Excel Files - Union Queries with Total Rows

128 - Excel VBA Introduction Part 58.18 - SQL for Excel Files - Union Queries from Multiple Files

129 - Excel VBA Introduction Part 58.19 - SQL for Excel Files - Inner Joins

130 - Excel VBA Introduction Part 58.20 - SQL for Excel Files - Outer Joins

131 - Excel VBA Introduction Part 58.21 - SQL for Excel Files - Constructing Full Outer Joins

132 - Excel VBA Introduction Part 58.22 - SQL for Excel Files - Join Worksheets from Multiple Files

133 - Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side

134 - Excel VBA Introduction Part 58.24 - SQL for Excel Files - Consolidate Worksheets with Derived Tables

135 - Excel VBA Introduction Part 58.25 - SQL for Excel Files - Basic Subqueries

136 - Excel VBA Introduction Part 58.26 - SQL for Excel Files - Nested Subqueries

137 - Excel VBA Introduction Part 58.27 - SQL for Excel Files - Correlated Subqueries

138 - Excel VBA Introduction Part 58.28 - SQL for Excel Files - Inserting Data into an Existing Sheet

139 - Excel VBA Introduction Part 58.29 - SQL for Excel Files - Select Data into a New Sheet or Workbook

140 - Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data

141 - Excel VBA Introduction Part 58.31 - SQL for Excel Files - Split a Table into Separate Sheets

142 - Wise Owl Answers - How do I list all properties of a file using VBA?

143 - Excel VBA Introduction Part 57.1 (Oct 2023) - Getting Started with Selenium Basic and Google Chrome

144 - Wise Owl Answers - How do I add Videos to PowerPoint Slides with VBA?

145 - Wise Owl Answers - How do I make a VBA event work in every workbook?

146 - Wise Owl Answers - How do I speed up calculations in Excel VBA?

عن الدورة

This Excel VBA Introduction Course is a complete beginner-friendly training designed to help you understand how to automate tasks in Microsoft Excel using Visual Basic for Applications (VBA). It is structured to take you step by step from zero knowledge to essential programming concepts used in real Excel automation.

The course begins with getting started in the VB Editor, where you learn how to open and navigate the VBA development environment inside Excel. You will then move on to writing your first VBA macro, giving you hands-on experience with basic automation.

Next, you will explore error handling and debugging, learning how to identify and fix common mistakes in your code. This helps you build confidence when working with VBA scripts.

The course also covers buttons, toolbars, and keyboard shortcuts, which improve productivity and make automation easier to execute.

A key section focuses on selecting and working with cells, including Range, Cells, ActiveCell, End, and Offset methods. These tools are essential for controlling Excel data programmatically.

You will also learn how to work with worksheets, charts, sheets, and workbooks, giving you a full understanding of Excel’s structure. Finally, the course introduces VBA fundamentals needed for writing efficient automation scripts.

By the end, you will be able to create

دورات ذات صلة

Canva Complete Course: Social Media Design and Workflow Mastery

Canva Complete Course: Social Media Design and Workflow Mastery

Human Resource Management (HRM) Complete Course – HR Basics to Advanced Practices

Human Resource Management (HRM) Complete Course – HR Basics to Advanced Practices

Introduction to Human Resource Management – Lecture 01

Introduction to Human Resource Management – Lecture 01

Strategic Human Resource Management (HRM) Diploma Course

Strategic Human Resource Management (HRM) Diploma Course

Advanced Human Resource Management (HRM) Course – Strategy, Talent & Analytics

Advanced Human Resource Management (HRM) Course – Strategy, Talent & Analytics

Human Resource Management (HRM) Complete Course

Human Resource Management (HRM) Complete Course

Complete HRMS FlowHCM Training Course – From Attendance to Payroll & Recruitment

Complete HRMS FlowHCM Training Course – From Attendance to Payroll & Recruitment

Complete BambooHR Employee Training Course

Complete BambooHR Employee Training Course