KatzDownload.com

9.78 GB | 59min 57s | mp4 | 1280X720  | 16:9
Genre:eLearning |Language:English

Files Included :
1  What are we going to Learn - A quick walk-through.mp4 (44.37 MB)
10  Your question - What is personal MacroWorkbook.mp4 (134.39 MB)
2  What is VBA and why we need it - Do you need  it.mp4 (86.31 MB)
3  Get familiar with VBA Editor important options - Our first step.mp4 (97.26 MB)
4  Record, Edit and Run your first macro - Know from zero level.mp4 (161.79 MB)
5  Sheet and Cells Commands with Debug of a program - Fundamentals.mp4 (142.58 MB)
6  Recording Macro Fundamentals and Mistakes - Important thing to understand.mp4 (94.87 MB)
7  How to go to last row and Data Selection right approach- static and Dynamic.mp4 (124.25 MB)
8  Project -Data Compile from sheets - its Super fun and practical lecture.mp4 (254.34 MB)
1  Declare Variables and Data Types and Errors you may face.mp4 (258.3 MB)
2  Variant and String Data types with exercises - Fundamentals.mp4 (192.22 MB)
3  Scope of a Variable with Call keyword - Local, module and Public  Global.mp4 (245.9 MB)
4  Option Explicit and Interview preparation.mp4 (85.87 MB)
1  For Next Loop - First step.mp4 (134.35 MB)
10  What is IF with ElseIf & IF without Elseif - Meaning & Difference - Just awesome.mp4 (150.56 MB)
11  Select with End Select - What is it and benefits.mp4 (45.94 MB)
2  For next with more offset and more variations - Super Fun.mp4 (86.99 MB)
3  Print numbers using Cells command and learn why it is important to know.mp4 (36.88 MB)
4  Exercise for you - Make loop diagonally - Print numbers.mp4 (43.32 MB)
5  How to Reverse a Loop - Become a Master now in Loops forever.mp4 (48.45 MB)
6  Mastery over Sub Loops - Loop inside Loop -Achieve  Magnificent level.mp4 (110 MB)
7  IF statements in VBA - Full in-depth discussion is on.mp4 (227.81 MB)
8  Quiz for you - Use IF with Loops on Real Data.mp4 (256.21 MB)
9  Do While Loop begins.mp4 (360.62 MB)
1  Begin with Workbook Commands.mp4 (351.32 MB)
10  More Advance Project  - Data Compile with more conditions.mp4 (630.08 MB)
11  Interview question Solved  Advance Loops with IFs - Incredible learning.mp4 (160.34 MB)
2  ThisWorkbook and ActiveWorkbook difference - Interview question.mp4 (331.34 MB)
3  Know what is a Class and its methods and properties- fundamentals.mp4 (330.75 MB)
4  Define own Objects using Set Keyword - A new level for you.mp4 (387.86 MB)
5  How to use Worksheet , Range and Workbook Classes - TIme to do practical.mp4 (276.91 MB)
6  Collection Loops begins - Work with Sheets.mp4 (111.19 MB)
7  PROJECT - import all sheets names using collection loop.mp4 (113.4 MB)
8  Super Advance Project - Data Compile - It cannot be better than this.mp4 (169.36 MB)
9  Our second Collection Loop - Deal with Workbooks now.mp4 (156.07 MB)
1  How to Define and Fill Arrays - Why we need Arrays.mp4 (117.5 MB)
2  Dynamic Arrays.mp4 (140.35 MB)
3  Preserve function in Arrays - Take your skills to a new level.mp4 (334.26 MB)
4  How to use Two or Multi Dimensional Arrays.mp4 (527.6 MB)
5  Project for you- More confidence and more clarity.mp4 (218.09 MB)
6  Challenge Lookup made simple with Arrays- Super Advance.mp4 (727.73 MB)
1  Begin with UDF- User Defined Function.mp4 (164.36 MB)
2  More examples of UDF.mp4 (534.35 MB)
3  How to use SPLIT Function- Powerful.mp4 (175.08 MB)
4  Inbuilt TEXT functions - len, ucase,lcase,strReverse.mp4 (136.59 MB)
5  Text Inbuilt functions Left Right Find Mid.mp4 (71.82 MB)
6  Vlookup Project.mp4 (88.93 MB)
7  Challenge - VLOOKKUP and MATCH functions in VBA.mp4 (133.99 MB)
8  Date functions in VBA.mp4 (77.66 MB)
9  UDF Advance Challenge Vlookup -  Find any instance of Lookup.mp4 (119.25 MB)]
Screenshot