In this video, the anatomy of the respiratory system is explained using cadavers as a visual aid. The procedure of tracheostomy is discussed, including the reasons why it may be required, the landmarks that need to be identified, and the...

ENGLISH VOCABULARY WORDS. Do you want to learn English? Are you looking for an English lesson on vocabulary and pronunciation? Learning English vocabulary and pronunciation are my specialties! In this video, I’ll teach you the precise...

In this lesson, we use the Workbooks. method to close every open workbook in Excel. We also configure the procedure to disable alerts temporarily to avoid halting execution.
r/>
This clip is from the chapter "Object Deep Dive"...

In this lesson, we'll explore some tips for writing cleaner and more elegant VBA code.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete Guide".In this section, we...

In this lesson, we'll explore the benefits of comments to the developer and practice writing them in the context of a procedure.
r/>
This clip is from the chapter "The Visual Basic Editor" of the series "Excel VBA...

A procedure is a grouped set of instructions / code that accomplishes some kind of goal. We'll also talk about some of the common syntactical errors made when writing out procedures. In this lesson, we'll dive into the syntax to...

Deleting rows from a spreadsheet can be a risky operation --- if moving downwards in direction, there's a risk that some rows will NOT be deleted. In this lesson, we explore iteration in reverse (from a larger number to a smaller one)...

The With - End With construct is a shorthand syntax that allows for multiple properties to be overwritten on an object. In this lesson, we practice modifying the Name, Size, Bold and Italic properties on the Font object.
r/>
...

In certain cases, VBA allows us to traverse the Excel object model in reverse --- from the bottom up. One such example is the Range.Worksheet property, which returns a Worksheet object that encloses a Range. In this lesson, we practice...

The F8 key allows us to step through the lines of a procedure step by step. In this lesson, we see how this functionality grants tremendous power when debugging a complex piece of code.
r/>
This clip is from the chapter...

If zero-based indexing is confusing, the Option Base 1 keywords at the top of a module force an array to start at an index position of 1. In this lesson, we enable this setting and see its results in a newly declared array.
r/>
...

In this lesson, we use the InputBox function to collect a new worksheet title from the user. The InputBox is a basic dialog box with a single text entry field, a prompt, a title, and OK / Cancel buttons.
r/>
This clip is from...

The Exit For keywords prematurely terminate a For loop. The Exit Sub keywords prematurely terminate a procedure. In this lesson, we practice implementing these concepts.
r/>
This clip is from the chapter "Iteration" of the...

This is a video of showing a fair and calm grievance procedure between an employee and their manager. The mediator listens to both sides, asks for evidence, and aims to find a solution that addresses the problem while ensuring the...

The Application.DisplayAlerts property is used to enable or disable user alerts in Excel. An alert is a dialog box that warns the user of an impending operation. It's a helpful feature but can be distracting when the user is executing...

The Worksheet.Copy method copies the contents of a worksheet to a new worksheet. When invoked with no arguments, it will create the copy in a brand new workbook. With either a Before or After argument, the copy will be placed in the...

The Immediate Window is a console or playground within the Visual Basic Editor that allows the developer to test out snippets of VBA code. The IW can be used to get or set property values, invoke object methods and more. In this...

The Worksheet_Activate event is triggered when the user navigates to a different worksheet. It can be used to provide the user with instructions or warnings. In this lesson, we write a quick procedure to MsgBox out the activated...

A dynamic array can be resized repeatedly throughout a procedure to hold a different number of elements. This can be helpful when we cannot predict an array size in advance. In this lesson, we use a dynamic array to contain a list of...

The For Each construct iterates over every single object in a collection. In this lesson, we practice iterating over the Workbooks and Worksheets collections.
r/>
This clip is from the chapter "Iteration" of the series "Excel...

Some event procedures feature a Cancel Boolean argument that can cancel a specific operation by being set to True in the body of the procedure. In this lesson, we try this out with the BeforePrint event procedure.
r/>
This clip...

The Workbook_Open event is triggered when a workbook is opened -- it can be an effective way to welcome a user or run a procedure. In this lesson, we utilize this feature in a new event procedure.
r/>
This clip is from the...

In this lesson, we explore the Date, Time and Now functions for retrieving the current date and/or time as well as the DateSerial function for generating a specific date in time.
r/>
This clip is from the chapter "Functions" of...

The Step keyword can iterate with a different increment or decrement after each cycle of the loop. In this lesson, we experiment with a syntax and write a procedure that colors every second row yellow.
r/>
This clip is from the...