Live Virtual Learning

"If" statements are used to define logical true/false operations of a statement requiring several possible outcomes. If the input condition is true, it will perform a specific result and if the condition is false, it will perform a different result. The input to the IF statement uses conditional statements such as Greater Than or Less Than. It will then make the necessary true/false decisions. This automated decision process will reduce human errors and increase overall accuracy. Another technique to perform many decisions in a single command are the Select Case statements which will also be covered. In this chapter, you will learn about "If" structure, Math operators, Comparison operators, Logical operators, and Select Case statements.Video Series Part 35- This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.Higher Quality Video: www.elearnlogic.com/media/excel365-5-ch6a.mp4- Click + Rumble if the video was helpful.- Click Subscribe so you won’t miss out on any new videos.- Click the Share button so you can help others expand their skills.Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.Courseware: Excel 365 – Visual Basic For ExcelThe courseware is available on Amazon at: https://www.amazon.com/dp/1979929076Chapter 6 - "If" Statements"If" statements are used to define logical true/false operations of a statement requiring several possible outcomes. If the input condition is true, it will perform a specific result and if the condition is false, it will perform a different result. The input to the IF statement uses conditional statements such as Greater Than or Less Than. It will then make the necessary true/false decisions. This automated decision process will reduce human errors and increase overall accuracy. Another technique to perform many decisions in a single command are the Select Case statements which will also be covered. In this chapter, you will learn about "If" structure, Math operators, Comparison operators, Logical operators, and Select Case statements.Section 1 - If StatementsThis section will review IF statements to make decisions that may require two or more resulting answers. The logical parameters used include Greater Than, Less Than, Greater Than or Equal To, Less Than or Equal To, Equal To, and Not Equal To. We can also use this mathematical operation to adjust a result such as Multiplication, Division, Addition, Subtraction, Exponentiation, or String Concatenation. The AND operator will only be true if all conditions are true and the OR will be true if any of the conditions are true. IF statements can be nested within an IF statement to evaluate many possible results. The code structure will always start with the word IF and end with END IF. The GOTO command is used to break or jump out of the middle of an operation under certain conditions. The following concepts will be covered: Operators, Assignment, Arithmetic Operators, Comparison Operators, Logical Operators, "IF" Structure, Nested IF, End IF Goto, and Else In.This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: [email protected]

Variables are the basic building blocks in any programming language and will provide a way to store information to be used later in a routine. You will learn the Variable structure, math operations, data types, and various problems that may be encountered. Variables can be declared in routine, in the module, or the variable storage can be accessed from a different module. Arrays are a way to store multiple values in a single register and this chapter will review ways to extract these values.Video Series Part 34- This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.Higher Quality Video: www.elearnlogic.com/media/excel365-5-ch5.mp4- Click + Rumble if the video was helpful.- Click Subscribe so you won’t miss out on any new videos.- Click the Share button so you can help others expand their skills.Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.Courseware: Excel 365 – Visual Basic For ExcelThe courseware is available on Amazon at: https://www.amazon.com/dp/1979929076Chapter 5 - VariablesVariables are the basic building blocks in any programming language and will provide a way to store information to be used later in a routine. You will learn the Variable structure, math operations, data types, and various problems that may be encountered. Variables can be declared in routine, in the module, or the variable storage can be accessed from a different module. Arrays are a way to store multiple values in a single register and this chapter will review ways to extract these values.Section 1 - Variable StructureThese are temporary storage locations for information to be used at a later time. The data will remain in a storage location until new data overrides current information. Each Variable will be declared using a dimension statement that follows the form of “Dim i As Integer.” The Variable name will be declared using a specific Variable type, once the defined text and numeric values can be assigned to a storage location. The following concepts will be covered: Variables, Variable Name Rules, Dimension, Set Object Variable, Datatypes, Text, Numbers, Date, Boolean, Byte, Integer, Long, Decimal, String, Currency, Datatype, and Assignments.Section 2 - Global DeclarationsGlobal Declarations are defined on top of the Module and can be used for multiple subroutines. The following Global Declarations will be covered: Public Variable, Private Variable, Private Sub, Const Variable, Static Variable, Parenthesis Around An Option, Declare Above, Global Scope, Public, and Private.Section 3 - VB ArraysArrays are a collection of data that have the same data type (called the base type). They are grouped into a single Array Variable, with a single Array name. This section will review the different techniques used to extract information out of an Array. The following concepts will be covered:Declaring Array, Split Function, Join Function, Redim, Preserve, LBound, UBound, and IsArray.This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: [email protected]

Loops will provide the ability to repeat operations in order to perform necessary repetitive tasks. This will allow you to search for information on a sheet, identify what is present, and evaluate data in order to make a decision. The FOR Loop will run for a specific set of times and you must determine upfront the number of cells before manipulating them. The DO Loop is better suited for cell manipulation because you can loop until you find a blank record.Video Series Part 38- This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.Higher Quality Video: www.elearnlogic.com/media/excel365-5-ch8.mp4- Click + Rumble if the video was helpful.- Click Subscribe so you won’t miss out on any new videos.- Click the Share button so you can help others expand their skills.Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.Courseware: Excel 365 – Visual Basic For ExcelThe courseware is available on Amazon at: https://www.amazon.com/dp/1979929076Chapter 8 - Loop Control StructuresLoops will provide the ability to repeat operations in order to perform necessary repetitive tasks. This will allow you to search for information on a sheet, identify what is present, and evaluate data in order to make a decision. The FOR Loop will run for a specific set of times and you must determine upfront the number of cells before manipulating them. The DO Loop is better suited for cell manipulation because you can loop until you find a blank record.Section 1 - For LoopsThe FOR Loop is used for looping through an explicit number, counting until it reaches the end. In order to loop through cells or an Array you will need to extract the exact number of intervals desired. Once you have the counter number, you can loop through it either forward, backward, or skip every other number. The following concepts will be covered: For Next Loop, Loop Counter, Debug.Print, Step by 2, Count Backward, and Looping Over.Section 2 - Do LoopsDO Loops are probably the best loop style when dealing with cell manipulation. The looping will be open-ended until it meets a specific condition. You can place the Until or While parameter either after the DO statement or at the ending statement LOOP. An Exit DO statement can be placed anywhere in the middle of the DO Loop to break or exit out at any time. The following concepts will be covered: Do Loop, Do While Loop, and Do Until.Section 3 - Do WhileYou can use a DO While Loop to process the cells while a certain condition is present. However, when a condition changes it will stop. An Exit DO statement can be placed anywhere in the middle of the DO Loop to break or exit out at any time. The following concepts will be covered: Do While 1, Do While 2, and Do Exit Do.Section 4 - While Wend LoopsA While Wend Loop structure is similar to a DO Loop. When the condition is True, the Macro Loops. When the condition is False, the Loop stops. This technique is not often used, however, it is important to know the format of this function in case it is in the existing code.This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: [email protected]