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

The Range.SpecialCells method extracts a subset of cells from a Range based on a criteria -- empty cells, cells with constants, cells with formulas, etc. In this lesson, we populate a column with various values and use the method to...

In this lesson, we continue our exploration of absolute vs relative references by recording a macro that deletes a row from the worksheet. Absolute references explicitly target a specific row each time, which defeats the purpose of the...

The aim of this video is to explore what are table references.
r/>
This clip is from the chapter "Excel 2019 Advanced: Tables" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore the...

The aim of this video is to explore how to connect to web data sources.
r/>
This clip is from the chapter "Excel 2019 Advanced: Connecting to External Data" of the series "The Complete Excel Guide: Beginners to Advanced".In...

This video aims to explain comments.
r/>
This clip is from the chapter "Excel 2019 Beginner: Page Setup and Print Options" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to explore page setup...

The aim of this video is to explore how to arrange files.
r/>
This clip is from the chapter "Excel 2019 Beginners: Working with Views" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll...

This video explains how to load the Excel data.
r/>
This clip is from the chapter "Part V-Reading and Writing Data from Excel to Selenium Python Framework" of the series "Selenium Python Automation Testing from Scratch and...

This video explains the strategy to access Excel data.
r/>
This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API Automation Testing from Scratch - REST Assured Java".This section...

In this video, we will learn how to apply data filtering.

• Understand why we should filter
data
• Apply data transformations to the FACTS
ales table
• Filter the data us
in
g Power Query

This clip is from...

In this video, we are going to review project requirements and determine data sources.

• Learn how to take a given set of require
ments
• Understand what finalizing the requirements by multiple refinement and review...

This video tutorial demonstrates two simple methods for adding up numbers in Microsoft Excel. The first method involves manually typing a formula to add specific cells together, while the second method utilizes the autosum feature to...

This video provides an introduction to the case that you will be working on.
<
br/>
This clip is from the chapter "Robot #6 - Amazon Data Scraping (Medium)" of the series "Robotic Process Automation - UiPath RPA Developer...

In this video, we will be covering a challenge for date time conversion.
r/>
This clip is from the chapter "Solving Data Prep Challenges" of the series "Power BI Masterclass".In this section, we will learn how to do data...

This video demonstrates how to use the Transpose tool in Alteryx.<br/<br/>>

This clip is from the chapter "Transform Tab" of the series "Alteryx for Beginners".This section explores the Transform tab.

What the Font object is to the foreground, the Interior property is to the background. In this lesson, we use the Range.Interior property to modify the color of a cell in a variety of different ways including:

• VBA color...

The Range.TextToColumns method splits a string based on a delimiter, a special symbol. In this lesson, we use this feature to separate several strings, applying a variety of delimiters (commas, spaces, even custom vertical pipes) along...

The Range.Replace method acts as a Find-and-Replace search mechanism. In this lesson, we apply it to a range of values in column A and discover a unique quirk when it comes to replacing numbers.
r/>
This clip is from the...

In this lesson, we continue to expand on the R1C1 concepts introduced in the past lesson by applying them to several real-life examples.
r/>
This clip is from the chapter "Range References" of the series "Excel VBA...

The Range.EntireRow and Range.EntireColumn properties are used to target a complete row or column from a single cell. In this lesson, we play around with the two properties in the Immediate Window.
r/>
This clip is from the...

The Range.Row and Range.Column properties return numbers that represent the numeric position of the cell's row and column relative to the spreadsheet. If a multi-cell Range is used, VBA uses the top-left cell as its reference point. In...

In this lesson, we use the Range.Count and Range.CountLarge properties to find out the number of cells in a given range. The returned value counts all cells, not just those with values.
r/>
This clip is from the chapter "Range...

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