[ FreeCourseWeb.com ] Professional Excel VBA - Udemy

mp4   Hot:51   Size:3.34 GB   Created:2022-05-21 03:20:34   Update:2024-11-24 15:59:47  

File List

  • Get Bonus Downloads Here.url 183 B
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/001 Introduction.en.srt 2.59 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/001 Introduction.mp4 17.75 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/002 Enabling VBA Developer tab in the Ribbon.en.srt 1.55 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/002 Enabling VBA Developer tab in the Ribbon.mp4 8.29 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/003 L1_Macro_Exercise.xlsm 10.76 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/003 Recording a macro.en.srt 4.05 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/003 Recording a macro.mp4 18.02 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/004 View and analyze recorded macro code.en.srt 7.42 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/004 View and analyze recorded macro code.mp4 33.1 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/005 Edit a recorded macro code.mp4 70.24 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/005 EditingMacroExercise.xlsm 14.16 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/006 Record macros using Absolute and Relative modes and compare results.en.srt 8.28 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/006 Record macros using Absolute and Relative modes and compare results.mp4 52.54 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/006 RelativeReferencingExercise.xlsm 14.3 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/007 Saving your macro-enabled workbook.en.srt 4.81 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/007 Saving your macro-enabled workbook.mp4 32.73 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 EXERCISES1.docx 14.59 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 Exercise2.docx 120.12 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 Exercise3.docx 13.91 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 Trusting workbook to avoid security issues.en.srt 4.57 KB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 Trusting workbook to avoid security issues.mp4 38.78 MB
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 invoice.txt 508 B
    ~Get Your Files Here !/01 Getting started with macros. Recording, editing and saving macros/008 invoice1.txt 994 B
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/001 Explore the Visual Basic for Application coding Editor interface.en.srt 3.21 KB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/001 Explore the Visual Basic for Application coding Editor interface.mp4 41.36 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/002 Creating your first VBA code.en.srt 4.34 KB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/002 Creating your first VBA code.mp4 19.49 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/003 Adding toolbar buttons.mp4 22.64 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/004 Adding Form Controls.en.srt 5.15 KB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/004 Adding Form Controls.mp4 19.44 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/005 Understanding Excel's object hierarchy.mp4 52.02 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/006 Identify worksheet ranges.en.srt 18.24 KB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/006 Identify worksheet ranges.mp4 83 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/007 How to properly addressing cells and ranges on a worksheet.mp4 102.64 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/009 L1_ExploringEditor.mp4 19.95 MB
    ~Get Your Files Here !/02 Getting started with writing VBA Code and explore the VBE interface/015 WritingMacros.docx 17.19 KB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/001 Creating variables.en.srt 8.09 KB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/001 Creating variables.mp4 85.63 MB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/002 Defining data types.en.srt 12.91 KB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/002 Defining data types.mp4 40.58 MB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/003 Managing strings.en.srt 21.76 KB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/003 Managing strings.mp4 90.04 MB
    ~Get Your Files Here !/03 Summary of last section and fundamentals of variables and data types/018 ManagingStrings.docx 13.82 KB
    ~Get Your Files Here !/04 VBA programming with Arrays/001 The anatomy of arrays.mp4 49.76 MB
    ~Get Your Files Here !/04 VBA programming with Arrays/002 Array versus regular variables compared.en.srt 3.55 KB
    ~Get Your Files Here !/04 VBA programming with Arrays/002 Array versus regular variables compared.mp4 17.97 MB
    ~Get Your Files Here !/04 VBA programming with Arrays/003 A closer look of static and dynamic arrays.en.srt 17.04 KB
    ~Get Your Files Here !/04 VBA programming with Arrays/003 A closer look of static and dynamic arrays.mp4 67.18 MB
    ~Get Your Files Here !/04 VBA programming with Arrays/004 Looping within arrays.en.srt 6.61 KB
    ~Get Your Files Here !/04 VBA programming with Arrays/004 Looping within arrays.mp4 24.05 MB
    ~Get Your Files Here !/04 VBA programming with Arrays/005 Using the Erase() function.en.srt 2.32 KB
    ~Get Your Files Here !/04 VBA programming with Arrays/005 Using the Erase() function.mp4 9.37 MB
    ~Get Your Files Here !/04 VBA programming with Arrays/006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.en.srt 13.61 KB
    ~Get Your Files Here !/04 VBA programming with Arrays/006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.mp4 51.3 MB
    ~Get Your Files Here !/04 VBA programming with Arrays/024 REDIM PRESERVE EXERCISE.docx 43.5 KB
    ~Get Your Files Here !/05 Creating function procedures/001 Creating function procedures.en.srt 15.96 KB
    ~Get Your Files Here !/05 Creating function procedures/001 Creating function procedures.mp4 195.71 MB
    ~Get Your Files Here !/05 Creating function procedures/002 Testing custom functions.en.srt 6.49 KB
    ~Get Your Files Here !/05 Creating function procedures/002 Testing custom functions.mp4 30.24 MB
    ~Get Your Files Here !/05 Creating function procedures/003 Function procedures, function scope and setting reference from other workbooks.en.srt 23.2 KB
    ~Get Your Files Here !/05 Creating function procedures/003 Function procedures, function scope and setting reference from other workbooks.mp4 92.37 MB
    ~Get Your Files Here !/05 Creating function procedures/004 Executing function procedures.mp4 101.86 MB
    ~Get Your Files Here !/05 Creating function procedures/005 Calling function in worksheet formulas.en.srt 10.55 KB
    ~Get Your Files Here !/05 Creating function procedures/005 Calling function in worksheet formulas.mp4 56.2 MB
    ~Get Your Files Here !/05 Creating function procedures/006 Demonstrate using custom function in conditional formatting rule.en.srt 10.55 KB
    ~Get Your Files Here !/05 Creating function procedures/006 Demonstrate using custom function in conditional formatting rule.mp4 56.21 MB
    ~Get Your Files Here !/05 Creating function procedures/007 A closer look at function arguments.mp4 27.88 MB
    ~Get Your Files Here !/05 Creating function procedures/008 Example of a single argument function.en.srt 3.45 KB
    ~Get Your Files Here !/05 Creating function procedures/008 Example of a single argument function.mp4 16.9 MB
    ~Get Your Files Here !/05 Creating function procedures/009 Example of a two argument function.en.srt 3.45 KB
    ~Get Your Files Here !/05 Creating function procedures/009 Example of a two argument function.mp4 16.89 MB
    ~Get Your Files Here !/05 Creating function procedures/010 Functions that accept optional arguments.en.srt 8.58 KB
    ~Get Your Files Here !/05 Creating function procedures/010 Functions that accept optional arguments.mp4 36 MB
    ~Get Your Files Here !/05 Creating function procedures/011 Arrays revisited_ Functions that return arrays.en.srt 4.93 KB
    ~Get Your Files Here !/05 Creating function procedures/011 Arrays revisited_ Functions that return arrays.mp4 20.14 MB
    ~Get Your Files Here !/05 Creating function procedures/012 Functions that accept infinite number of arguments.en.srt 5.53 KB
    ~Get Your Files Here !/05 Creating function procedures/012 Functions that accept infinite number of arguments.mp4 19.9 MB
    ~Get Your Files Here !/05 Creating function procedures/013 We learn how to provide descriptions of our function and its arguments.en.srt 8.62 KB
    ~Get Your Files Here !/05 Creating function procedures/013 We learn how to provide descriptions of our function and its arguments.mp4 58.48 MB
    ~Get Your Files Here !/05 Creating function procedures/037 ArrayExercises.docm 350.79 KB
    ~Get Your Files Here !/05 Creating function procedures/037 FunctionProcedureExercise.docx 16.67 KB
    ~Get Your Files Here !/06 Working with VBA Events/001 Understanding the sequence of events.mp4 12.37 MB
    ~Get Your Files Here !/06 Working with VBA Events/002 Overview of VBA events_ Understanding event sequence.mp4 52.51 MB
    ~Get Your Files Here !/06 Working with VBA Events/003 Calling standard modules from event handler procedures.mp4 24.96 MB
    ~Get Your Files Here !/06 Working with VBA Events/004 Event handler procedures that use arguments.mp4 50.75 MB
    ~Get Your Files Here !/06 Working with VBA Events/005 Workbook-level events.en.srt 2.8 KB
    ~Get Your Files Here !/06 Working with VBA Events/005 Workbook-level events.mp4 15.05 MB
    ~Get Your Files Here !/06 Working with VBA Events/006 Workbook-level events example coding.en.srt 5.26 KB
    ~Get Your Files Here !/06 Working with VBA Events/006 Workbook-level events example coding.mp4 28.67 MB
    ~Get Your Files Here !/06 Working with VBA Events/007 Worksheet-level events example.mp4 25.27 MB
    ~Get Your Files Here !/06 Working with VBA Events/008 Workbook_Activate example.mp4 24.89 MB
    ~Get Your Files Here !/06 Working with VBA Events/009 The NewSheet Event procedure.mp4 13.58 MB
    ~Get Your Files Here !/06 Working with VBA Events/010 A look at the BeforeSave Event handler.en.srt 4.14 KB
    ~Get Your Files Here !/06 Working with VBA Events/010 A look at the BeforeSave Event handler.mp4 20.07 MB
    ~Get Your Files Here !/06 Working with VBA Events/011 The Deactivate event.mp4 18.06 MB
    ~Get Your Files Here !/06 Working with VBA Events/012 The BeforePrint event procedure.en.srt 3.36 KB
    ~Get Your Files Here !/06 Working with VBA Events/012 The BeforePrint event procedure.mp4 17.98 MB
    ~Get Your Files Here !/06 Working with VBA Events/013 The WorksheetChange event.mp4 33.7 MB
    ~Get Your Files Here !/06 Working with VBA Events/014 The BeforeRightClick event.mp4 38.75 MB
    ~Get Your Files Here !/06 Working with VBA Events/051 Event handler exercises.docm 87.06 KB
    ~Get Your Files Here !/06 Working with VBA Events/051 SelectionChangeExercise.docm 227.88 KB
    ~Get Your Files Here !/06 Working with VBA Events/051 ValidateCode.docm 88.28 KB
    ~Get Your Files Here !/07 VBA error handling techniques/001 Section introduction.en.srt 2.03 KB
    ~Get Your Files Here !/07 VBA error handling techniques/001 Section introduction.mp4 11.9 MB
    ~Get Your Files Here !/07 VBA error handling techniques/002 Types of VBA errors.en.srt 768 B
    ~Get Your Files Here !/07 VBA error handling techniques/002 Types of VBA errors.mp4 3.7 MB
    ~Get Your Files Here !/07 VBA error handling techniques/003 Trapping errors.en.srt 6.72 KB
    ~Get Your Files Here !/07 VBA error handling techniques/003 Trapping errors.mp4 28.77 MB
    ~Get Your Files Here !/07 VBA error handling techniques/004 Using the Err object_ An example.en.srt 6.07 KB
    ~Get Your Files Here !/07 VBA error handling techniques/004 Using the Err object_ An example.mp4 29.49 MB
    ~Get Your Files Here !/07 VBA error handling techniques/005 Examples of VBA error handling techniques.en.srt 10.32 KB
    ~Get Your Files Here !/07 VBA error handling techniques/005 Examples of VBA error handling techniques.mp4 53.63 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/001 Introduction to lecture and review of previous lecture.en.srt 2.12 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/001 Introduction to lecture and review of previous lecture.mp4 19.71 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/002 Working with worksheet ranges_ Copying ranges.en.srt 5.77 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/002 Working with worksheet ranges_ Copying ranges.mp4 19.32 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/003 More discussion on copying ranges.mp4 50.34 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/004 Copy a variable size range_ The CurrentRange method of the Range object.mp4 57.15 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/005 Tips for working with ranges.en.srt 7.79 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/005 Tips for working with ranges.mp4 34.62 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/006 How to identify various types of ranges such as the first empty cell in a column.en.srt 3.97 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/006 How to identify various types of ranges such as the first empty cell in a column.mp4 29.37 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/007 Range selection examples.en.srt 2.57 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/007 Range selection examples.mp4 12.82 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/008 Using the Resize property of the Range object to handle varying size ranges.mp4 79.84 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/009 Prompting for user input.en.srt 7.96 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/009 Prompting for user input.mp4 29.66 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/010 A mode advanced use of the InputBox function.en.srt 9.55 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/010 A mode advanced use of the InputBox function.mp4 38.81 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/011 More discussion on the InputBox function, populating cells with InputBox values.en.srt 8.79 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/011 More discussion on the InputBox function, populating cells with InputBox values.mp4 39.43 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/012 Pausing macro for range selection.en.srt 5.17 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/012 Pausing macro for range selection.mp4 26.03 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/013 Counting selected cells.en.srt 6.97 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/013 Counting selected cells.mp4 47.5 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/014 Determining types of selected range_ single cell, contiguous range of cells etc.en.srt 4.87 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/014 Determining types of selected range_ single cell, contiguous range of cells etc.mp4 15.62 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/015 Code to check for existence of a worksheet in a workbook.en.srt 1.2 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/015 Code to check for existence of a worksheet in a workbook.mp4 5.99 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/016 Accessing the parents of an Excel object.mp4 23.18 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/017 Opening files to extract data for worksheets using Application.GetOpenFilename().en.srt 9.5 KB
    ~Get Your Files Here !/08 VBA Hands-on examples/017 Opening files to extract data for worksheets using Application.GetOpenFilename().mp4 43.85 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/018 Saving a file.en.srt 936 B
    ~Get Your Files Here !/08 VBA Hands-on examples/018 Saving a file.mp4 6.05 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/019 Creating Data Forms based on data in a worksheet.mp4 45.49 MB
    ~Get Your Files Here !/08 VBA Hands-on examples/063 range selections.xlsm 71.9 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/001 Introduction_ What we are going to learn in this section.en.srt 1.52 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/001 Introduction_ What we are going to learn in this section.mp4 3.64 MB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/002 Inserting UserForms in VBA projects.en.srt 4.07 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/002 Inserting UserForms in VBA projects.mp4 19.49 MB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/003 We learn of the different control types on the Toolbox.en.srt 6.75 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/003 We learn of the different control types on the Toolbox.mp4 38.36 MB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/004 Using the Properties Window to adjust properties of controls.en.srt 8.22 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/004 Using the Properties Window to adjust properties of controls.mp4 37.62 MB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/005 Naming controls.en.srt 3.1 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/005 Naming controls.mp4 16.61 MB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/006 Displaying forms.en.srt 5.1 KB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/006 Displaying forms.mp4 28.12 MB
    ~Get Your Files Here !/09 Using UserForms and Controls to provide interactivity/007 Managing lists using the ListBox and the ComboBox controls.mp4 67.93 MB
    ~Get Your Files Here !/10 Developing a VBA Application/001 Introduction to section.en.srt 1020 B
    ~Get Your Files Here !/10 Developing a VBA Application/001 Introduction to section.mp4 4.95 MB
    ~Get Your Files Here !/10 Developing a VBA Application/002 A practical demonstration of UserForm modal and non-modal modes.en.srt 9.52 KB
    ~Get Your Files Here !/10 Developing a VBA Application/002 A practical demonstration of UserForm modal and non-modal modes.mp4 46.78 MB
    ~Get Your Files Here !/10 Developing a VBA Application/003 Progress bar demo application.en.srt 10.82 KB
    ~Get Your Files Here !/10 Developing a VBA Application/003 Progress bar demo application.mp4 48.32 MB
    ~Get Your Files Here !/10 Developing a VBA Application/004 Using the Multipage control to develop a Books application.en.srt 29.12 KB
    ~Get Your Files Here !/10 Developing a VBA Application/004 Using the Multipage control to develop a Books application.mp4 182.82 MB
    ~Get Your Files Here !/10 Developing a VBA Application/086 Sub Procedure And Array Exercise.docx 279.88 KB
    ~Get Your Files Here !/Bonus Resources.txt 357 B

Download Info

  • Tips

    “[ FreeCourseWeb.com ] Professional Excel VBA - Udemy” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.