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...

In this lesson, we continue our exploration of additional datetime functions on the VBA helper object including Year, Month, Day, Hour, Minute, and Second. We also dive into the Weekday, WeekdayName and MonthName functions to discover...

In this lesson, we dive deeper into the MsgBox method including its Buttons and Title parameter. We modify the aesthetics of the alert, including the clickable buttons and the information icon.
r/>
This clip is from the chapter...

The aim of this video is to explore how to work with fill handle and custom lists.
r/>
This clip is from the chapter "Excel 2019 Beginners: Formatting Worksheets" of the series "The Complete Excel Guide: Beginners to...

In this video, the instructor demonstrates two quick methods to toggle between displaying formulas and calculated values in a spreadsheet. By utilizing the Formula Auditing section in the ribbon, users can easily switch between viewing...

This tutorial demonstrates how to generate random dates between two specified dates using the randbetween function in Excel. By inputting the earliest and latest dates as parameters, viewers can create a dynamic spreadsheet that...

This video explains how to read an Excel file.
<
br/>
This clip is from the chapter "Data-Driven Testing" of the series "Selenium WebDriver Advanced - Industry Standard Framework".In this section, you will learn about data-driven...

This video explains data science stages and technologies.<br<br/>/>

This clip is from the chapter "Introduction to Data Science" of the series "Practical Data Science Using Python".This section introduces you to data science.

This video explains standard and custom objects.
<
br/>
This clip is from the chapter "Data Modeling and Management" of the series "Salesforce Platform App Builder Certification Training".This section explains data modeling and...

This is second of the two-part video, where you will learn about the automation of data in a spreadsheet.
<
br/>
This clip is from the chapter "Tech Primer – Automation Activities" of the series "Robotic Process Automation -...

This is first of the two-part video, where you will learn about the automation of data in a spreadsheet.
<
br/>
This clip is from the chapter "Tech Primer – Automation Activities" of the series "Robotic Process Automation - UiPath...

In this lesson, we explore the Rows and Columns properties, which are available on both the top-level Application object and a specific Range. The two can be used to target complete rows or columns, within the spreadsheet or within a...

In this lesson, we invoke the Workbook.Active method to simulate a user click on a workbook and make it the ActiveWorkbook. We also review the ActiveSheet property, which targets the currently highlighted worksheet.
r/>
This...

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...

In the first of a 3-part series, we introduce the ListBox form control for displaying a list of predefined values for the user to choose from. We hardwire our list to show the names of all of the workbook's sheets.
r/>
This...

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...

Arrays can easily be populated with values from the worksheet using a basic For loop. In this lesson, we perform a popular string cleaning operation --- trimming the leading and trailing whitespace of a string -- on a column of values...

In this video, we will learn about dashboards, what they are for, and how they’re different from reports.

• Understand the important differences between a report and a dash
board
• Create a new dashboard by adding...

In this video, we will learn how to connect a folder as a data source.

• Understand the power and usefulness of the import o
ption
• Combine flat files from a folder using P
ower Query
• Import data from multiple...

The aim of this video is to explore subtotals.
r/>
This clip is from the chapter "Excel 2019 Beginners: Outlining and Subtotaling" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore...

This video is the second part of the three-part video that presents another practice exercise on Excel driven testing.
r/>
This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API...