| 001 Creating function procedures.en.srt | 16 KB | ||
| 001 Creating function procedures.mp4 | 195.7 MB | ||
| 001 Creating variables.en.srt | 8.1 KB | ||
| 001 Creating variables.mp4 | 85.6 MB | ||
| 001 Explore the Visual Basic for Application coding Editor interface.en.srt | 3.2 KB | ||
| 001 Explore the Visual Basic for Application coding Editor interface.mp4 | 41.4 MB | ||
| 001 Introduction to lecture and review of previous lecture.en.srt | 2.1 KB | ||
| 001 Introduction to lecture and review of previous lecture.mp4 | 19.7 MB | ||
| 001 Introduction to section.en.srt | 1 KB | ||
| 001 Introduction to section.mp4 | 4.9 MB | ||
| 001 Introduction.en.srt | 2.6 KB | ||
| 001 Introduction.mp4 | 17.7 MB | ||
| 001 Introduction_ What we are going to learn in this section.en.srt | 1.5 KB | ||
| 001 Introduction_ What we are going to learn in this section.mp4 | 3.6 MB | ||
| 001 Section introduction.en.srt | 2 KB | ||
| 001 Section introduction.mp4 | 11.9 MB | ||
| 001 The anatomy of arrays.mp4 | 49.8 MB | ||
| 001 Understanding the sequence of events.mp4 | 12.4 MB | ||
| 002 A practical demonstration of UserForm modal and non-modal modes.en.srt | 9.5 KB | ||
| 002 A practical demonstration of UserForm modal and non-modal modes.mp4 | 46.8 MB | ||
| 002 Array versus regular variables compared.en.srt | 3.6 KB | ||
| 002 Array versus regular variables compared.mp4 | 18 MB | ||
| 002 Creating your first VBA code.en.srt | 4.3 KB | ||
| 002 Creating your first VBA code.mp4 | 19.5 MB | ||
| 002 Defining data types.en.srt | 12.9 KB | ||
| 002 Defining data types.mp4 | 40.6 MB | ||
| 002 Enabling VBA Developer tab in the Ribbon.en.srt | 1.6 KB | ||
| 002 Enabling VBA Developer tab in the Ribbon.mp4 | 8.3 MB | ||
| 002 Inserting UserForms in VBA projects.en.srt | 4.1 KB | ||
| 002 Inserting UserForms in VBA projects.mp4 | 19.5 MB | ||
| 002 Overview of VBA events_ Understanding event sequence.mp4 | 52.5 MB | ||
| 002 Testing custom functions.en.srt | 6.5 KB | ||
| 002 Testing custom functions.mp4 | 30.2 MB | ||
| 002 Types of VBA errors.en.srt | 819.2 B | ||
| 002 Types of VBA errors.mp4 | 3.7 MB | ||
| 002 Working with worksheet ranges_ Copying ranges.en.srt | 5.8 KB | ||
| 002 Working with worksheet ranges_ Copying ranges.mp4 | 19.3 MB | ||
| 003 A closer look of static and dynamic arrays.en.srt | 17 KB | ||
| 003 A closer look of static and dynamic arrays.mp4 | 67.2 MB | ||
| 003 Adding toolbar buttons.mp4 | 22.6 MB | ||
| 003 Calling standard modules from event handler procedures.mp4 | 25 MB | ||
| 003 Function procedures, function scope and setting reference from other workbooks.en.srt | 23.2 KB | ||
| 003 Function procedures, function scope and setting reference from other workbooks.mp4 | 92.4 MB | ||
| 003 L1_Macro_Exercise.xlsm | 10.8 KB | ||
| 003 Managing strings.en.srt | 21.8 KB | ||
| 003 Managing strings.mp4 | 90 MB | ||
| 003 More discussion on copying ranges.mp4 | 50.3 MB | ||
| 003 Progress bar demo application.en.srt | 10.8 KB | ||
| 003 Progress bar demo application.mp4 | 48.3 MB | ||
| 003 Recording a macro.en.srt | 4 KB | ||
| 003 Recording a macro.mp4 | 18 MB | ||
| 003 Trapping errors.en.srt | 6.7 KB | ||
| 003 Trapping errors.mp4 | 28.8 MB | ||
| 003 We learn of the different control types on the Toolbox.en.srt | 6.8 KB | ||
| 003 We learn of the different control types on the Toolbox.mp4 | 38.4 MB | ||
| 004 Adding Form Controls.en.srt | 5.1 KB | ||
| 004 Adding Form Controls.mp4 | 19.4 MB | ||
| 004 Copy a variable size range_ The CurrentRange method of the Range object.mp4 | 57.2 MB | ||
| 004 Event handler procedures that use arguments.mp4 | 50.7 MB | ||
| 004 Executing function procedures.mp4 | 101.9 MB | ||
| 004 Looping within arrays.en.srt | 6.6 KB | ||
| 004 Looping within arrays.mp4 | 24 MB | ||
| 004 Using the Err object_ An example.en.srt | 6.1 KB | ||
| 004 Using the Err object_ An example.mp4 | 29.5 MB | ||
| 004 Using the Multipage control to develop a Books application.en.srt | 29.1 KB | ||
| 004 Using the Multipage control to develop a Books application.mp4 | 182.8 MB | ||
| 004 Using the Properties Window to adjust properties of controls.en.srt | 8.2 KB | ||
| 004 Using the Properties Window to adjust properties of controls.mp4 | 37.6 MB | ||
| 004 View and analyze recorded macro code.en.srt | 7.4 KB | ||
| 004 View and analyze recorded macro code.mp4 | 33.1 MB | ||
| 005 Calling function in worksheet formulas.en.srt | 10.5 KB | ||
| 005 Calling function in worksheet formulas.mp4 | 56.2 MB | ||
| 005 Edit a recorded macro code.mp4 | 70.2 MB | ||
| 005 EditingMacroExercise.xlsm | 14.2 KB | ||
| 005 Examples of VBA error handling techniques.en.srt | 10.3 KB | ||
| 005 Examples of VBA error handling techniques.mp4 | 53.6 MB | ||
| 005 Naming controls.en.srt | 3.1 KB | ||
| 005 Naming controls.mp4 | 16.6 MB | ||
| 005 Tips for working with ranges.en.srt | 7.8 KB | ||
| 005 Tips for working with ranges.mp4 | 34.6 MB | ||
| 005 Understanding Excel's object hierarchy.mp4 | 52 MB | ||
| 005 Using the Erase() function.en.srt | 2.3 KB | ||
| 005 Using the Erase() function.mp4 | 9.4 MB | ||
| 005 Workbook-level events.en.srt | 2.8 KB | ||
| 005 Workbook-level events.mp4 | 15 MB | ||
| 006 Demonstrate using custom function in conditional formatting rule.en.srt | 10.5 KB | ||
| 006 Demonstrate using custom function in conditional formatting rule.mp4 | 56.2 MB | ||
| 006 Displaying forms.en.srt | 5.1 KB | ||
| 006 Displaying forms.mp4 | 28.1 MB | ||
| 006 How to identify various types of ranges such as the first empty cell in a column.en.srt | 4 KB | ||
| 006 How to identify various types of ranges such as the first empty cell in a column.mp4 | 29.4 MB | ||
| 006 Identify worksheet ranges.en.srt | 18.2 KB | ||
| 006 Identify worksheet ranges.mp4 | 83 MB | ||
| 006 Record macros using Absolute and Relative modes and compare results.en.srt | 8.3 KB | ||
| 006 Record macros using Absolute and Relative modes and compare results.mp4 | 52.5 MB | ||
| 006 RelativeReferencingExercise.xlsm | 14.3 KB | ||
| 006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.en.srt | 13.6 KB | ||
| 006 Using the Redim and Redim Preserve statements; defining a two-dimensional array.mp4 | 51.3 MB | ||
| 006 Workbook-level events example coding.en.srt | 5.3 KB | ||
| 006 Workbook-level events example coding.mp4 | 28.7 MB | ||
| 007 A closer look at function arguments.mp4 | 27.9 MB | ||
| 007 How to properly addressing cells and ranges on a worksheet.mp4 | 102.6 MB | ||
| 007 Managing lists using the ListBox and the ComboBox controls.mp4 | 67.9 MB | ||
| 007 Range selection examples.en.srt | 2.6 KB | ||
| 007 Range selection examples.mp4 | 12.8 MB | ||
| 007 Saving your macro-enabled workbook.en.srt | 4.8 KB | ||
| 007 Saving your macro-enabled workbook.mp4 | 32.7 MB | ||
| 007 Worksheet-level events example.mp4 | 25.3 MB | ||
| 008 EXERCISES1.docx | 14.6 KB | ||
| 008 Example of a single argument function.en.srt | 3.4 KB | ||
| 008 Example of a single argument function.mp4 | 16.9 MB | ||
| 008 Exercise2.docx | 120.1 KB | ||
| 008 Exercise3.docx | 13.9 KB | ||
| 008 Trusting workbook to avoid security issues.en.srt | 4.6 KB | ||
| 008 Trusting workbook to avoid security issues.mp4 | 38.8 MB | ||
| 008 Using the Resize property of the Range object to handle varying size ranges.mp4 | 79.8 MB | ||
| 008 Workbook_Activate example.mp4 | 24.9 MB | ||
| 008 invoice.txt | 512 B | ||
| 008 invoice1.txt | 1 KB | ||
| 009 Example of a two argument function.en.srt | 3.4 KB | ||
| 009 Example of a two argument function.mp4 | 16.9 MB | ||
| 009 L1_ExploringEditor.mp4 | 20 MB | ||
| 009 Prompting for user input.en.srt | 8 KB | ||
| 009 Prompting for user input.mp4 | 29.7 MB | ||
| 009 The NewSheet Event procedure.mp4 | 13.6 MB | ||
| 010 A look at the BeforeSave Event handler.en.srt | 4.1 KB | ||
| 010 A look at the BeforeSave Event handler.mp4 | 20.1 MB | ||
| 010 A mode advanced use of the InputBox function.en.srt | 9.5 KB | ||
| 010 A mode advanced use of the InputBox function.mp4 | 38.8 MB | ||
| 010 Functions that accept optional arguments.en.srt | 8.6 KB | ||
| 010 Functions that accept optional arguments.mp4 | 36 MB | ||
| 011 Arrays revisited_ Functions that return arrays.en.srt | 4.9 KB | ||
| 011 Arrays revisited_ Functions that return arrays.mp4 | 20.1 MB | ||
| 011 More discussion on the InputBox function, populating cells with InputBox values.en.srt | 8.8 KB | ||
| 011 More discussion on the InputBox function, populating cells with InputBox values.mp4 | 39.4 MB | ||
| 011 The Deactivate event.mp4 | 18.1 MB | ||
| 012 Functions that accept infinite number of arguments.en.srt | 5.5 KB | ||
| 012 Functions that accept infinite number of arguments.mp4 | 19.9 MB | ||
| 012 Pausing macro for range selection.en.srt | 5.2 KB | ||
| 012 Pausing macro for range selection.mp4 | 26 MB | ||
| 012 The BeforePrint event procedure.en.srt | 3.4 KB | ||
| 012 The BeforePrint event procedure.mp4 | 18 MB | ||
| 013 Counting selected cells.en.srt | 7 KB | ||
| 013 Counting selected cells.mp4 | 47.5 MB | ||
| 013 The WorksheetChange event.mp4 | 33.7 MB | ||
| 013 We learn how to provide descriptions of our function and its arguments.en.srt | 8.6 KB | ||
| 013 We learn how to provide descriptions of our function and its arguments.mp4 | 58.5 MB | ||
| 014 Determining types of selected range_ single cell, contiguous range of cells etc.en.srt | 4.9 KB | ||
| 014 Determining types of selected range_ single cell, contiguous range of cells etc.mp4 | 15.6 MB | ||
| 014 The BeforeRightClick event.mp4 | 38.8 MB | ||
| 015 Code to check for existence of a worksheet in a workbook.en.srt | 1.2 KB | ||
| 015 Code to check for existence of a worksheet in a workbook.mp4 | 6 MB | ||
| 015 WritingMacros.docx | 17.2 KB | ||
| 016 Accessing the parents of an Excel object.mp4 | 23.2 MB | ||
| 017 Opening files to extract data for worksheets using Application.GetOpenFilename().en.srt | 9.5 KB | ||
| 017 Opening files to extract data for worksheets using Application.GetOpenFilename().mp4 | 43.9 MB | ||
| 018 ManagingStrings.docx | 13.8 KB | ||
| 018 Saving a file.en.srt | 921.6 B | ||
| 018 Saving a file.mp4 | 6 MB | ||
| 019 Creating Data Forms based on data in a worksheet.mp4 | 45.5 MB | ||
| 024 REDIM PRESERVE EXERCISE.docx | 43.5 KB | ||
| 037 ArrayExercises.docm | 350.8 KB | ||
| 037 FunctionProcedureExercise.docx | 16.7 KB | ||
| 051 Event handler exercises.docm | 87.1 KB | ||
| 051 SelectionChangeExercise.docm | 227.9 KB | ||
| 051 ValidateCode.docm | 88.3 KB | ||
| 063 range selections.xlsm | 71.9 KB | ||
| 086 Sub Procedure And Array Exercise.docx | 279.9 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 170 total files | |||
Professional Excel VBA - Udemy
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.34 GB | Duration: 10h 4m
Excel VBA for higher productivity
What you'll learn
You will be able to harness the power of VBA language to automate data processing and develop full featured Excel programs. Everything you need to build large and small Excel applications
Go beyond recording simple macros
Dynamically manipulate workbooks, worksheets and arrays
Transfer data to and from spreadsheet for manipulation
Master the most important ActiveX controls such as Frame, MultiPage, List Box using VBA
Develop fully functional VBA application to sort and re-arrange worksheets in any workbook
Description
Beginning with macro recording, we guide you step by step to learn and develop your VBA skills that are guaranteed to take your Excel VBA skills to the next level . At the end of the course you will have the foundational skills and knowledge to build automated data processing VBA routines and develop full featured Excel applications. This course is for you if you daily use Excel to manipulate data and wish to take a break from such mundane tasks and start utilizing the power of Excel macros and VBA automation. If you intend to take on full VBA development as a career, and you are prepared to work hard and not be afraid to explore, you will receive a solid foundational skills to help you in this journey. This course is full of examples and hands-on exercises. We tackle the most important concepts of VBA programming such as Workbook and Worksheet event-level programming. We explore the use of ActiveX controls with examples and projects. We believe that if you are ready to work hard, we have provided you with the tools and foundational skills and knowledge to build on as you explore the interesting world of VBA programming for higher productivity
Who this course is for:
For people wanting to make the transition from data by day Excel data manipulation to automated data processing with VBA for increased productivity
People looking for solid skills to build on as future VBA developers
SCREENSHOTS
If You Need More Courses, kindly Visit and Support Us -->> https://FreeCourseWeb.com
Thank You.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
[ FreeCourseWeb ] Udemy - VideoScribe Expert Training - Producing Professional Videos Posted by
freecoursewb in Other
|
541.5 MB | freecoursewb | 5 years | 0 | 0 |
|
[ FreeCourseWeb ] Udemy - Professional Psychotherapy Diploma Course - CBT Practitioner Posted by
freecoursewb in Other
|
1.7 GB | freecoursewb | 5 years | 1 | 0 |
|
[ FreeCourseWeb ] Udemy - Creating a Professional LinkedIn Profile (2021) Posted by
freecoursewb in Other
|
881.3 MB | freecoursewb | 5 years | 0 | 0 |
|
[ FreeCourseWeb ] Udemy - Building a Professional Reputation Using LinkedIn (2021) Posted by
freecoursewb in Other
|
1.1 GB | freecoursewb | 5 years | 0 | 0 |
| 3.2 GB | freecoursewb | 5 years | 0 | 0 |
All Comments