Mastering Excel VBA for the Real World

سرفصل های دوره

Embrace the Magic of Excel VBA Automation

1 - Introduction

1 - Introduction

2 - Getting Familiar with the VBA Editor

2 - Adding the Developer Tab

3 - Main Parts of the VBA Editor

4 - Adding the Edit Toolbar

3 - Using the Macro Recorder Functionality

5 - HR-File.xlsx

5 - Macros Macro Security

6 - Recording Macros Part I

7 - Recording Macros Part II

8 - Editing Macros

9 - Programming in VBA vs Recording Macros

9 - Programming-in-VBA-over-Macro-Recorder.pdf

4 - Building solid ground in Excel VBA

10 - Excel VBA Object Model

10 - Excel-VBA-Object-Model.pdf

11 - Workbooks Worksheets and Sheets Collections

11 - Workbooks-Worksheets-and-Sheets-Collections.pdf

12 - Workbooks Coding Lesson

13 - Sheets Worksheets Coding Lesson

14 - Range Object Coding Lesson

15 - Columns Rows and Cells Properties Coding Lesson

5 - Learning about VBA Operators

16 - Arithmetic Operators

16 - Excel-VBA-Operators.pdf

17 - Comparison Operators

18 - Logical Operators

19 - Concatenation Operators

6 - Data Types in VBA and Variables

20 - Excel VBA Data Types

20 - Excel-VBA-Data-Types.pdf

21 - Variables Coding Lesson

22 - Excel VBA Constants

23 - Option Explicit in VBA

7 - Font Object

24 - Font Object Coding Lesson

8 - With End With Statement

25 - With End With Statement

9 - Set Statement

26 - Set Statement

10 - Excel VBA BuiltIn Functions

27 - Format Function

28 - String Functions Part I

29 - String Functions Part II

30 - Date and Time functions Part I

31 - Date and Time functions Part II

32 - Excel VBA Round Function

11 - WorksheetFunction Object

33 - WorksheetFunction

12 - User Defined Functions

34 - User Defined Functions

35 - The Call Statement Calling Functions andor SubProcedures

13 - Protecting your Macros

36 - Protecting your Macros

14 - Excel VBA Key Methods

37 - RangeReplace Method

38 - RangeSort Method

39 - RangeRemove Duplicates Method

40 - RangeAutoFilter Method

41 - RangeFind Method

15 - Conditional Statements for Decision Making

42 - If Statement

43 - Nested If Statements

44 - Select Case Statement

45 - Nested Select Case Statements

16 - Excel VBA Loops

46 - Do While Loop

47 - Do Until Loop

48 - For Next Loop Part I

49 - For Next Loop Part II

50 - For Each Loop

17 - Automating Pivot Tables and Pivot Charts dynamically in VBA

51 - Automate Pivot Tables in VBA

52 - Automate Pivot Charts

18 - ArrayLists in Excel VBA

53 - Installing-Net-Framework-version-3.5.pdf

53 - VBA ArrayList Part I

54 - VBA ArrayList Part II

55 - VBA ArrayList Part III

19 - Excel VBA Dictionaries

56 - VBA Dictionaries Part I

57 - VBA Dictionaries Part II

58 - VBA Dictionaries Part III

20 - Automating Microsoft Word from Excel

59 - Microsoft Word Automation from Excel Part I

60 - Microsoft Word Automation from Excel Part II

21 - Working with csv Files in VBA

61 - Extract Data from another Workbook and save file as csv File

62 - Reading from csv File and convert it to a different Excel Extension

22 - Final HR File

63 - Final File.html

63 - final-hr-file.zip

23 - Error Handling and Err Object in VBA

64 - ErrorHandling.xlsx

64 - Error Handling

65 - Err Object and Error Handling

53,700 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training