The conditional If statement is the heart of programming. It allows our macro to have multiple branches --- different pathways to take depending on a given condition. In this lesson, we explore the technical syntax for implementing an...

This video explains the concept of rolling restarts.
r/>
This clip is from the chapter "Elasticsearch Operations" of the series "Elasticsearch 7 and Elastic Stack - In Depth and Hands On".This section explains the concept of...

In this lesson, we take a look at the default values for the String, Long, Double and Boolean data types.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete...

There are two ways to "shut down" a UserForm: unloading, which clears all of its data and hiding, which hides it from the screen but preserves the user's inputs. In this lesson, we wire up our two Command Buttons to utilize these two...

Multiple If statements can quickly clutter up a procedure. The Select Case construct offers a convenient alternative. In this lesson, we'll explore the syntax for Select across a variety of examples.
r/>
This clip is from the...

The Application.ScreenUpdating property can be set to False to disable updates to the Excel interface. One way to optimize the speed of a macro is to turn the property off at the beginning of execution and reenable it at the end. In...

The NOT operator reverses a Boolean value. In this lesson, we use it to design our own implementation of Excel's bolding feature.
r/>
This clip is from the chapter "Conditionals" of the series "Excel VBA Programming–The...

Pumps are devices used to move liquids or slurries. Liquids are moved from higher pressure to lower pressure, and overcome this pressure by adding energy to a system. Pumps can be classified as either being positive...

In this lesson, we invoke the Workbooks.Add method to create a new workbook from scratch. We also pass it an optional Template argument to make a copy of an existing workbook.
r/>
This clip is from the chapter "Object Deep...

Learn to handle arguments.<br/<br/>>

This clip is from the chapter "Procedures" of the series "Excel VBA Programming–The Complete Guide".We look into variable scopes in procedures.

The Worksheet_SelectionChange event is triggered when the user navigates to a different cell with a spreadsheet. In this lesson, we react our first Excel event and also explore the ByVal keyword in the automatically generated...

Breakpoints force a procedure to halt execution at one or more specified lines. In this lesson, we practice enabling and disabling breakpoints in our code.
r/>
This clip is from the chapter "Debugging" of the series "Excel VBA...

Today you’ll find out why your IELTS results might be withheld.

A flowchart for reading the Key Signature

The Exit Sub keywords terminate a procedure prematurely, before it reaches its last line of code. It's an effective technique to combine with conditional logic --- proceed if all the pieces fall into place, exit otherwise. In this...

The CommandButton is a clickable button that trigger an event procedure. In this lesson, we add 3 buttons to our form -- Submit, Cancel and Hide.
r/>
This clip is from the chapter "User Forms" of the series "Excel VBA...

The On Error Go To keywords redirect the pathway of a procedure to a specially designated section. In this lesson, we set up an example and discuss why the Exit Sub keywords have to be used to avoid running into the code...

The VBA object includes many helper methods to assist the developer with common utility operations. In this lesson, we explore the LCase, UCase, Len, Trim, and InStr methods for working with strings.
r/>
This clip is from the...

The LBound and UBound methods return the smallest and greatest index positions of an array. In this lesson, we utilize these values to write a flexible, dynamic loop procedure.
r/>
This clip is from the chapter "Arrays" of the...

In this video, we'll look at stored Proc class.<br/<br/>>

This clip is from the chapter "Repository Pattern" of the series "The Complete Guide to ASP.NET Core MVC (.NET 5)".In this section, let's look at the repository pattern.

This video is a case study on the challenges you face if you don’t have a project management policy in place.
<
br/>
This clip is from the chapter "Case Studies" of the series "PMP® Certification Training".This section explains...

Learn more about calling procedure.<br/<br/>>

This clip is from the chapter "Procedures" of the series "Excel VBA Programming–The Complete Guide".We look into variable scopes in procedures.

The ListBox offers a way for the user to select more than one option. In this lesson, we enable this setting and configure our code to delete all the worksheets that a user selects from the list.
r/>
This clip is from the...

In this video, you will be performing the linear regression.
<
br/>
This clip is from the chapter "Statistical Analysis – Part 2 (Linear and Multiple Regression)" of the series "Complete SAS Programming Guide - Learn SAS and Become...