Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Arrays and Loop
This video explains how to store some numbers in an array and then use a loop to print the amount of cells in the spreadsheet. This clip is from the chapter "Arrays" of the series "The Ultimate Excel VBA Course - Learn and Master VBA...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Arrays
This video explains arrays where you can store more than one value under the same name. This clip is from the chapter "Arrays" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This video explains arrays, loops,...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Do Loop
This video explains the Do Loop that allows the user to repeat a certain process in a macro. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - For Each Loop
This video explains the For Each loop that is normally used with collections and arrays, which helps you run one or more loops to cycle through. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - For Loop
This video explains the For loop that enables you to loop through a range of cells with just a few codes lines until the condition is met, and the code moves onto the next line of code. This clip is from the chapter "Loops with VBA" of...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - String Exercise
This video explains an exercise where you have a product code on a spreadsheet that is in the wrong format, and you have been given certain conditions as to how the output should look like after applying all you have learnt in this...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Mid Function
This video explains the mid function, which is used to grab characters from a string of text; it has three parts: the string to search, the starting position, and the number of characters to grab. This clip is from the chapter "String...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - The Left and Right Functions
This video explains the left and right functions, which will help us chop a string. The left function will help chop the characters from the start of the string and the right function will help chop the character from the end of the...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - InStr, InStrRev, and StrReverse
This video explains Instr and InstrRev, where Instr is looking from the start to the end, while InstrRev is looking from the end of the string to the beginning. The StrReverse returns a string by reversing the original string supplied....
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Excel VBA Replace
This video explains how to use the replace function to change the incorrect word. This clip is from the chapter "String Functions" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains strings in...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Trim, Len, and Space
This video explains three different functions: Trim, which is used to trim unwanted space from the text; the Len function is used to get the number of characters the string has; and the Space function is useful for formatting output and...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Changing Case
This video explains L case or U case; as the name suggests, these are used to change the letters into lowercase or uppercase. This clip is from the chapter "String Functions" of the series "The Ultimate Excel VBA Course - Learn and...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - With and End With
This video explains a new object called With and End With, where you can perform a series of statements on a specified object without specifying the name of the object multiple times. This clip is from the chapter "VBA Conditional...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Select Case
This video explains select case statements, which is an alternative way to write If and Else if statements and help you have a more understandable code. This clip is from the chapter "VBA Conditional Statements" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - VBA Practice Conditional Operators
This video is a practice session on conditional operators where if a person scores 85 and above, we will want to grade an A along with changing the background color of the cell. This clip is from the chapter "VBA Conditional Statements"...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Conditional Operators
This video explains the various conditional operators such as =, <, >, <=, >=, <>, and so on. This clip is from the chapter "VBA Conditional Statements" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Else and ElseIf
This video explains Else and ElseIf variables in Excel VBA using an example where you can add an Else part that tells VBA what happens if the opening line returns False. This clip is from the chapter "VBA Conditional Statements" of the...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - If Statements
This video explains If statements in Excel VBA using an example where if the input is less than 10, the condition will be satisfied or else it won't show an output. This clip is from the chapter "VBA Conditional Statements" of the series...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Other Excel VBA Variable Types
This video explains the other Excel VBA variable types such as As long, As Single, As Double, and As Currency. The difference between all these data types is how many digits they can hold. This clip is from the chapter "Mastering...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multiply and Divide
This video explains how to multiply and divide in Excel VBA. This clip is from the chapter "Mastering Variables in VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This video explains variables in VBA using...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Addition and Subtraction
This video explains how to add and subtract in Excel VBA. This clip is from the chapter "Mastering Variables in VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This video explains variables in VBA using...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Variable Practice
This video is a practice session on variables where you will declare the variable and store a value to it and read the string that was contained in it. This clip is from the chapter "Mastering Variables in VBA" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Variables
This video explains variables in VBA that help store things in memory. Variables can be of different types such as integers or strings. In VBA, you will need to declare every variable you are going to use. This clip is from the chapter...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Resize Property
This video explains the resize property that is available in VBA to change or resize the range of cells from the active cell as needed. This clip is from the chapter "Introduction" of the series "The Ultimate Excel VBA Course - Learn and...