Excel VBA -Learn Visual Basic macros (Beginner to Advanced)

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

Become a Guru in Microsoft Excel macros (VBA) to automate your tasks, reports, dashboards and analysis with Visual Basic

1. Introduction

1.1 01.SettingUp.pptx

1.2 MacShortcuts.pdf

1. Introduction

2. L02 Important How to choose the lessons for your level!

2. My First Macro ()

1.1 02.MyFirstMacro.pptx

1.2 2.firstmacro completed.zip

1.3 2.firstmacro todo.zip

1.4 Icons.xlsx

1. Material For the Section.html

2. L01 Basic Set up and Introduction to VBE ()

3. L02 Copy Paste And Save your code ()

4.1 Icons.xlsx

4. L03 Forget your fear and write your first macro ()

5.1 Icons.xlsx

5. L04 Run your Macro 10 Ways ()

6. L05 Use ChatGPT to write your code! ()

7. L06 Code Color, Useful Shortcuts And Basic Debugging ()

8. L07 Useful shortcuts And Debugging techniques ()

3. Referencing and Copy Paste ()

1.1 03.CellRefCopyPaste.pptx

1.2 3.referencing and copy paste completed.zip

1.3 3.referencing and copy paste todo.zip

1. Material for the section.html

2. L01 Cell Referencing, Row Height And Column Width ()

3. L02 Common Properties And Methods related to Cells ()

4. L03 Finding Last RowLast Column in dataset ()

5. L04 Select Data, Get the address And Delete Data ()

6. L05 Part 1 Formatting with VBA ()

7. L05 Part 2 Trick to extract RGB from a color ()

8. L06 Sheet Referencing ()

9. L07 Workbook Referencing ()

10. L08 Copy Paste(Special) ()

11. L09 Resize a Range ()

12.1 Template.xlsx

12. L10 Mini Project Part 1- Sort Data and generate a report using a template ()

13.1 Template.xlsx

13. L10 Mini Project Part 2- Sort Data and generate a report using a template ()

14.1 Icons.xlsx

14. L11 Mini Project - Report Analyzer ()

4. Data Object Model ()

1.1 04.DataObjectModel.pptx

1. Material for the section.html

2. L01 The Excel Object Model ()

3. L02 Object Properties ()

4. L03 Object Methods ()

5. L04 Dont Memorize -Different ways to get find Objects, Properties And Methods()

5. Menus And Toolbar Walkthrough ()

1.1 05.menutoolbarwalkthrough completed.zip

1.2 05.menutoolbarwalkthrough todo.zip

1. Material for the section.html

2. L01 File And Edit Menus ()

3. L02 View Menu ()

4. L03 Insert, Format, Debug And Run Menus ()

5. L04 Tools Menu ()

6. Variables And Formulas ()

1.1 06.VariablesFormulas.pptx

1.2 6.variables and_formulas_completed.zip

1.3 6.variables and_formulas_todo.zip

1. Material for section.html

2. L01 Intro to Variables And Types ()

3. L02 Declaring Variables - best practices ()

4. L03 Object Variables ()

5. L04 Variable Scope - Rock Paper Cisor Game ()

6. L05 Order of Preference in Calculations ()

7. L06 Convert to a different Data Type ()

8. L07 Formulas ()

9. L08 Mini Project Expense Report ()

7. Macro Recording ()

1.1 07.MacroRecording.pptx

1.2 7.macrorecording completed.zip

1.3 7.macrorecording todo.zip

1. Material for section.html

2. L01 Macro Recorder ()

3. L02 R1C1 Notation ()

4. L03 Practical use of Macro Recorder to automate Task ()

5. L04 Absolute vs Relative Reference in Recording ()

8. Looping through Objects, Conditional And Logical Operators ()

1.1 08.ComparaisonThroughLoopingCondLogOps.pptx

1.2 8.comparaisonthroughloopincondlogops completed.zip

1.3 8.comparaisonthroughloopincondlogops todo.zip

1. Material for section.html

2. L01 With End With ()

3. L02 For Each In...Next ()

4. L03 If Statement with ProtectUnprotect Sheet ()

5. L04 And Or Logical Operators ()

6. L05 Like Operator ()

7. L06 IsNumeric ()

8. L07 Select Case ()

9. Interacting with Users ()

1.1 09.InteractionWithUser.pptx

1.2 9.interactionwithuser completed.zip

1.3 9.interactionwithuser todo.zip

1. Material for section.html

2. L01 MsgBox Deep Dive ()

3. L02 InputBox ()

4. L03 Get a Range of Cells with InputBox ()

5. L04 Mini Project - Identify the winners ()

10. Looping ()

1.1 10.looping completed.zip

1.2 10.looping todo.zip

1.3 10.Looping.pptx

1. Material for section.html

2. L01 Use For Next Loop to filter Data ()

3. L02 Reverse For Next Loop ()

4. L03 Do Until Do While Do ()

5. L04 Do Loop with InputBox ()

6. L05 Find 1 Match ()

7. L06 Find Multiple Matches ()

8. L07 Timer to Measure Code RunTime ()

9. L08 Stop an infinite Loop ()

10. L09 While Loop with a new way to find last row in dataset ()

11. L10 Mini Report with Loops ()

11. Improving your code And Error Handling ()

1.1 11.improvingyourcode completed.zip

1.2 11.improvingyourcode todo.zip

1.3 11.ImprovingYourCode.pptx

1. Material for section.html

2. L01 Error Handling ()

3. L02 Speed up your code ()

4. L03 Modular Coding ()

5. L04 Passing Arguments (Byval vs ByRef) to Procedures And Procedure Scope ()

12. Text Manipulation ()

1.1 12.textmanipulation completed.zip

1.2 12.textmanipulation todo.zip

1.3 12.TextManipulation.pptx

1. Material for section.html

2. L01 Overview + Left, Right, Mid ()

3. L02 Replace ()

4. L03 Instr ()

5. L04 Check if string is empty ()

6. L05 Pitfall to avoid with Trim and Change Case of String ()

7. L06 Mini Project - Extract Ratings ()

13. Date Manipulation ()

1.1 13.DateManipulation.pptx

1.2 13.dates completed.zip

1.3 13.datesmanipulation todo.zip

1. Material for section.html

2. L01 Overview and basic date functions ()

3. L02 Play with Date, Time and Use YearFrac ()

4. L03 Number of days between dates (Simple subtraction And Networkdays) ()

5. L04 Number of MonthsYears between dates - Datediff and DateDif ()

6. L05 Mini Project - Fill the calendar ()

14. Create your own Excel function ()

1.1 14.yourownfunction completed.zip

1.2 14.yourownfunction todo.zip

1.3 14.YourOwnFunction.pptx

1. Material for section.html

2. L01 Overview and your first custom function ()

3. L02 Move your function under a category a provide definitions to the user()

4. L03 Mini Project - Find the Expiry date ()

5. L04 Function example - How to manipulate text ()

6. L05 Run Functions from Subs Other functions ()

7. L06 Optional Parameters in Functions ()

15. Arrays ()

1.1 15.arrays completed.zip

1.2 15.arrays todo.zip

1.3 15.Arrays.pptx

1. Material for section.html

2. L01 One-Dimension Array ()

3. L02 Dynamic Sized Arrays ()

4. L03 Keep your existing values when Rediming your array ()

5.1 15 04.2DimArrays

5. L04 Multidimensional Arrays ()

6. L05 Variant Array ()

7. L06 Mini Project - Generate Sub Reports by City ()

16. Files and Folders ()

1.1 16.filefolders todo.zip

1.2 16.filesfolders completed.zip

1.3 16.FilesFolders.pptx

1.4 SampleFolder.zip

1. Material for section.html

2. L01 Check if File Folder Exists and Create a new folder ()

3. L02 Allow user to select the file to open via dialog box ()

4. L03 Picking a Folder with FileDialog ()

5. L04 Save your files in different formats ()

6. L05 Open statement for more control over txt file ()

7. L06 Copy paste data into CSV file with custom delimiter ()

8. L07 Mini Project - Create a consolidated scorecard from selected files ()

17. How to deal with Excel Tables And Pivot Tables ()

1.1 17.exceltablespivot completed.zip

1.2 17.exceltablespivot todo.zip

1.3 17.ExcelTablesPivot.pptx

1. Material for section.html

2. L01 Crash course on Excel Tables ()

3. L02 Pivot Table VBA theory and Trick to get the right code-no memorizing ()

4. L03 Pivot Table Main activities ()

18. Interacting with Other Applications ()

1.1 18.2Template.docx

1.2 18.interactingwithotherapps completed.zip

1.3 18.interactingwithotherapps todo.zip

1.4 18.InteractingWithOtherApps.pptx

1. Material for section.html

2. L01 Create a PDF File from your excel sheets ()

3. L02 Manipulate Word from VBA ()

4. L03 Create a Presentation on PowerPoint from VBA ()

5. L04 Create automatic Emails with attachments from VBA ()

19. Sheet Controls ()

1.1 19.sheetcontrols completed.zip

1.2 19.sheetcontrols todo.zip

1.3 19.SheetControls.pptx

1.4 VariableValueForKeyMouseEvents.xlsx

1. Material for section.html

2. L01 Button Properties + Difference between ActiveX and Form controls ()

3.1 VariableValueForKeyMouseEvents.xlsx

3. L02 Button Key Press Events Capture keys pressed - ActiveX ()

4.1 VariableValueForKeyMouseEvents.xlsx

4. L03 Button Key Press Event Capture Control, Shift and Alt - ActiveX ()

5.1 VariableValueForKeyMouseEvents.xlsx

5. L04 Button Mouse Over Event - ActiveX ()

6.1 VariableValueForKeyMouseEvents.xlsx

6. L05 Button Simulate a Mouse Leave Event - ActiveX ()

7.1 19 06.FormControlRecap

7.2 VariableValueForKeyMouseEvents.xlsx

7. L06 Button Write in Shape - Form Controls + Recap of what we learned ()

8. L07 Textbox - ActiveX Additional Properties ()

9. L08 Textbox - Form Controls Properties ()

10.1 VariableValueForKeyMouseEvents.xlsx

10. L09 Textbox - ActiveX Tricks Part 1 (Tabbing, Change and Focus Events) ()

11.1 VariableValueForKeyMouseEvents.xlsx

11. L10 Textbox - ActiveX Tricks Part 2 (Restrict user inputs) + recap ()

12. L11 Checkbox - ActiveX Properties and Example ()

13. L12 Checkbox - Form Control Properties and Example

14. L13 Option Button ActiveX - Grouping and example ()

15. L14 Option Button - Form Control Grouping and example ()

16. L15 Option Button and Checkbox Recap ()

17. L16 Spin Buttons - ActiveX And Form Control Properties and example ()

18. L17 Labels - ActiveX And Form Control Practical use cases ()

19. L18 Combo box - ActiveX And Form Control Additional properties ()

20. L19 Combo box - ActiveX Main activities ()

21. L20 Combo box - Form Control Main activities ()

22. L21 List box -Active And Form Control Additional properties ()

23. L22 List box - ActiveX Main activities ()

24. L23 List box - Form Control Main activities ()

25. L24 Scroll bar Quick overview ()

20. Userforms ()

1.1 20.userforms completed.zip

1.2 20.userforms todo.zip

1.3 20.Userforms.pptx

1.4 employee1.zip

1.5 noimage.zip

1. Material for section.html

2. L01 Intro to UserForms + a look at a new control! ()

3. L02 UserForms Property ()

4. L03 Button Aesthetic trick ()

5. L04 Is TabStrip right for our mini project ()

6. L05 Use Multipage to set up the form in a professional way ()

7. L06 Using a Frame to Group Option buttons automatically ()

8. L07 Dont forget to initialize your form ()

9. L08 Initialize Combo Box ()

10. L09 Initialize List Box ()

11. L10 Tab it the right way! ()

12.1 Website to resize your image.html

12. L11 Wow your stakeholders with an Image ()

13. L12 Validate the Userform data entry or you might be in trouble ()

14. L13 Save your data ()

15. L14 Edit Form Set up ()

16. L15 Dynamic Search Box ()

17. L16 Get info form Database into the form ()

18. L17 Saving edited data ()

21. Charts ()

1.1 21.charts completed.zip

1.2 21.charts todo.zip

1.3 21.Charts.pptx

1. Material for section.html

2. L01 Chart Intro ()

3. L02 Easiest way to create and modify a chart ()

4. L03 Animate your chart to wow your audience ()

5. L04 Load your chart into a UserForm ()

22. Workbook and worksheet events ()

1.1 22.events completed.zip

1.2 22.Events.pptx

1.3 Section17Dashboardtocopy.xlsx

1. Material for section.html

2. L01 Workbook events ()

3. L02 Worksheet events ()

4. L03 Intersect to trigger an action only on certain cells ()

5. L04 Reset a dependent dropdown menu ()

6. L05 Use the BeforePrint event to fix your header issues ()

23. Quizz

1. Final Question.html

53,700 تومان

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

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

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

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