Live Virtual Learning

Live Virtual Learning Contact information, map and directions, contact form, opening hours, services, ratings, photos, videos and announcements from Live Virtual Learning, Computer training school, Lehi, UT.

Learn Adobe Acrobat, InDesign, Photoshop, Illustrator, Microsoft Visio, Crystal Reports, from any computer from anywhere, and an instructor comes to you via the Internet!

03/27/2022

In this video, we will review design strategies and tools associated with Power BI. The following include the Tools that will enhance the overall process of Power BI:
Power BI Desktop - This is used to Filter data from the database, relationships between tables, as well as develop Visual Reports.
Power BI Edge Webview2 - Power BI Desktop will work with most supported browsers, but you will see performance improvements by using Microsoft Edge WebView2 Runtime.
Power BI Pro Web Service - This will post or publish Visual Reports in order to share them via the Internet. This product will also build a Dashboard from Visual Reports.
Power BI for Mobile - This will provide access to Visual Reports and Dashboards on a Smart Device or Tablet.
Power BI Publisher For Excel - This is built into Excel and allows you to publish charts, PivotTables, and other objects to Power BI Pro Web Service.
Power BI Data Gateway - This will connect Power BI Pro Web Service directly to a data source located on a network (enterprise mode), or to a local data source (personal mode).
Power BI Report Builder - This is a Visual Report tool that creates page size layouts (paginated reports) and can contain multiple pages.
Power BI Developer Tools - There is a wide range of Developer Tools available for Power BI.

01/27/2021

"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 36- 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-ch6b.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 - PivotTable And PivotChart"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 2 - Select Case StatementsIn this section, we will address situations where you might have many resulting values and a nested IF statement may be too complicated or difficult to use. A Select Case statement will perform many decisions in a single command. Select Case statements can also be nested under a case logical statement, but this practice is often avoided to reduce complications. The following will be covered: Select Case, Case Variations, Case Else, and Nested Select.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]

01/26/2021

"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]

01/26/2021

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]

01/26/2021

This video is probably the most important and contains the most used features of Visual Basic. In order to manipulate a cell, you need to identify its position using the Range command. Then, you can apply an operation to manipulate the cells. This operation is used in all code at some point. Furthermore, in order to manipulate a cell, you can use options such as Cut/Copy/Paste, Paste Special, update the value of the cell, delete it, or clear it out. You can also manipulate data by row or column using various commands. Aplying the Offset and xlDown properties will allow the system to find a specific group of data.Video Series Part 32- 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-ch3-sec3.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 3 - Cell ManipulationThis chapter is probably the most important and contains the most used features of Visual Basic. In order to manipulate a cell, you need to identify its position using the Range command. Then, you can apply an operation to manipulate the cells. This operation is used in all code at some point. Furthermore, in order to manipulate a cell, you can use options such as Cut/Copy/Paste, Paste Special, update the value of the cell, delete it, or clear it out. You can also manipulate data by row or column using various commands. Applying the Offset and xlDown properties will allow the system to find a specific group of data.Section 3 - Column And Row TechniquesOften, you may want to manipulate rows or columns as a group in order to Delete, Clear, Cut/Copy/Paste, or use the Paste Special capabilities. Some of these commands can be used for specific operations such as in the Delete process. Therefore, it is important to understand the correct command sequence. The following commands will be covered: Columns/Rows Object, Column/Row Property, Select Columns/Row, EntireRow, and EntireColumn.Section 4 - Cell Offset, xlDown, CurrentRegion, And Address.This is the concluding set of commands that will start at a specific cell and move or offset to a different location based on a set of criteria. You might want to move to the end of the database or move to the next column. The Select Sheet command is unique in that it will only work with a specific set of defined commands. The following concepts will be covered: Offset Property, xlDown, CurrentRegion, Address Property, Text Property, and Select Sheet.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]

01/26/2021

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]

Address

Lehi, UT
84043

Telephone

+18013766687

Website

Alerts

Be the first to know and let us send you an email when Live Virtual Learning posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category