[TutsNode.com] - Learn Advanced Excel VBA for Automation

  01 Excel Macros for Beginner

   001 Why Learn Excel Macros_.en.srt

   003 Activate Developer tab in Excel.en.srt

   004 Saving a Macro-enabled Excel WorkBook (XLSM).en.srt

   005 Excel Macro Security Settings.en.srt

   006 Excel Developer Tab - Essential Buttons.en.srt

   007 Head and Tail of a Excel Macros (Sub Procedure and User Defined Function).en.srt

   008 Click Here button to run a Excel Macros.en.srt

  02 Hands on Learning on Macros

   009 Excel Macros - Record and Run.mp4

   010 Excel Macros - Viewing the code.mp4

   011 Excel Macro-free vs. Macro-enabled Workbook.mp4

   012 Visual Basic Editor (VBE) - Excel VBA.mp4

   013 Personal Macro Workbook.mp4

   014 Ways to Run a Macros (Excel VBA).mp4

  03 Learn to use Google search to automate your tasks without coding

   015 Using Google to locate useful Excel VBA codes - Part 1.mp4

   016 Using VBE and Macro Recorder to customize Excel Macro Code.mp4

   017 Using Google to locate useful Excel VBA codes - Part 2.mp4

  04 OBJECTS, PROPERTIES & METHODS in Excel Macros

   018 Objects, Properties, Values, Methods and Parameters - Part 1.mp4

   019 Objects, Properties, Values, Methods and Parameters - Part 2.mp4

  05 WORKSPACE in Excel Macros

   020 Code Color and Activating Edit Toolbar with Comments in Excel Macros.mp4

   021 Edit Toolbar - Indent & Bookmark in Excel Macros.mp4

   022 Excel Macros Code writing shortcuts including Intellisense.mp4

   023 Testing the Excel Macro Code.mp4

   024 Immediate Window - Part 01.mp4

  06 Understanding RANGE & CELLS OBJECT in Excel Macros

   025 Range Selection - Method 1.mp4

   026 Range Selection - Method 2 and 3.mp4

   027 Advantage of Range Selection - Method 2 and 3.mp4

   028 Range Selection (Rows and Columns) - Method 4.mp4

   029 Assigning values to selected range of cells in Excel.mp4

   030 Exercise 1 - Assigning values to selected range of cells in Excel.mp4

   031 Exercise 2- Assigning values to selected range of cells in Excel.mp4

   032 Multiple Range Selection - Method 5.mp4

   033 Multiple Range Selection - Method 6.mp4

   034 RangeSelectionWays - Others.mp4

  07 ABSOLUTE vs RELATIVE REFERENCE in Excel Macros

   035 Offset - Excel Basics.mp4

   036 Using Relative Reference in Excel Macros.mp4

  08 RANGE NAVIGATION in Excel Macros

   037 Navigating between a Range of cells - Part 1A.mp4

   038 Navigating between a Range of cells - Part 2.mp4

   039 Navigating between a Range of cells - Part 3.mp4

   040 Exercise - Finding Last Row Number in Excel.mp4

   041 Exercise 2 - Finding Last Column Number in Excel.mp4

   042 Exercise 3 - Finding Last Column Number in Excel.mp4

  09 Variable Declaration in Excel Macros

   043 Variable Declaration in Excel Macros Part 1.mp4

   044 Variable Declaration in Excel Macros Part 2.mp4

   045 Private Macros vs Public Macros Part 1.mp4

   046 Private Macros vs Public Macros Part 2.mp4

   047 OptionExplicit in Excel Macros.mp4

   048 Difference - DIM vs. SET in Excel Macros.mp4

  10 Loops in Excel Macros

   049 For Next in Excel Macros.mp4

   050 If Else End If nested within For Next - Excel Macros.mp4

   051 Do While in Excel Macros.mp4

   052 Do Until in Excel Macros.mp4

   053 For Each Next in Excel Macros.mp4

   054 If End If nested within For Each Next - Excel Macros.mp4

   055 Excel Macros Exercise - Do While and Loop Counter.mp4

   056 With End With - Excel Macros Example 1.mp4

   057 With End With - Excel Macros Example 2.mp4

   058 Select Case - Demonstration in Excel Macros.mp4

   059 Excel Macros Select Case - Explanation.mp4

  11 OPTIMIZING EXCEL VBA CODE EFFICIENCY

   060 Speed up the Macros code running - Part 1.mp4

   061 Speed up the Macros code running - Part 2.mp4

   062 Speed up the macros code running - Part 3.mp4

  12 Events in Excel Macros

   063 Introduction to Events in Excel Macros.mp4

   064 Excel Macros Events - Workbook_Open and Worksheet_Activate.mp4

   065 Excel Macros Exercise 1 - Tracking Workbook Opens.mp4

   066 Excel Macros Exercise 2 - Tracking Workbook Save.mp4

   067 Excel Macros Event - Worksheet_BeforeDoubleClick.mp4

   068 Excel Macros Event - Worksheet_Change.mp4

   069 Excel Macros Event - Worksheet_Calculate.mp4

   070 Pivot Table - Refresh - WorkSheetActivate in Excel Macros.mp4

  13 Excel Macros Input Box

   071 Introduction to InputBox in Excel Macros.mp4

   072 Excel Macros Input Box - Part 1.mp4

   073 Excel Macros Input Box - Part 2.mp4

   074 Excel Macros Input Box - Part 3.mp4

   075 Excel Macros Input Box - Part 4.mp4

  14 Message Box in Excel VBA

   076 Introduction to MsgBox in Excel VBA.mp4

   077 Excel VBA MsgBox - Part 1.mp4

   078 Excel VBA MsgBox - Part 2.mp4

   079 Excel VBA MsgBox - Part 3.mp4

   080 Excel VBA MsgBox - Part 4.mp4

  15 Insert button under Developer Tab

   081 Excel VBA Form Controls vs ActiveX Controls.mp4

   082 Mouse Move Event with Application Status bar in Excel Macros.mp4

  16 User Form in Excel VBA

   083 Introduction to User Form in Excel VBA.mp4

   084 Excel Macros User Form - Basics.mp4

   085 Excel Macros Exercise on User Form- Part 1 of 4.mp4

   086 Excel Macros Exercise on User Form- Part 2 of 4.mp4

   087 Excel Macros Exercise on User Form- Part 3 of 4.mp4

   088 Excel Macros Exercise on User Form- Part 4 of 4.mp4

   089 Excel Macros Option Button - Part 1.mp4

   090 Excel Macros Option Button - Part 2.mp4

   091 Introduction - Multi Page in Excel Maros.mp4

   092 Multi Page in Excel Macros - Part 1.mp4

   093 Multi Page in Excel Macros - Part 2.mp4

   094 Multi Page in Excel Macros - Part 3.mp4

   095 Check Box in Excel Macros.mp4

   096 Check Box in Excel Macros - Method 1.mp4

   097 Check Box in Excel Macros - Method 2.mp4

  17 UDF in Excel Macros

   098 UDF Introduction.mp4

   099 UDF Example 1 - ScoreResult with IF END IF.mp4

   100 UDF Example 2 - CellComments.mp4

   101 UDF Samples - Series A.mp4

   102 UDF Samples - Series B.mp4

 TutsNode.com.txt