The video demonstrates how to use the Goal Seek tool in Excel to quickly determine the target grade a student needs to achieve in a particular subject in order to reach a desired overall average. By setting a target average and letting...

In this video, the instructor demonstrates how to efficiently sort data in Microsoft Excel 2007. They showcase a simple method of sorting by average score and then delve into a more advanced technique involving multiple sorting levels to...

In this video, we will see the connect page and the features and functions that we get from it. We are also going to see the global superstore dataset. • Explore the data connection page • Inspect the global superstore dataset

This video explains how to use the Summarize 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.

This video demonstrates how to use the Find and Replace tool in Alteryx.<br/<br/>>

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

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

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

This video demonstrates how to use the Filter tool for numerical data in Alteryx.<br/<br/>>

This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.

This video explains how to use the Select tool in Alteryx.<br/<br/>>

This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.

This video demonstrates how to use Alteryx as the Output tool for updating existing data.
r/>
This clip is from the chapter "In/Out Tab" of the series "Alteryx for Beginners".This section provides an introduction to the In/Out...

In this section of the course, we take a deep dive into the Range, the most popular object in the Excel Object Model. We begin with the Select method, which highlights the range's boundaries on the spreadsheet.
r/>
This clip is...

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

The Format menu in the Visual Basic Editor offers options for aligning, grouping, and resizing one or more form controls. In this lesson, we apply these techniques to the controls in our employees UserForm.
r/>
This clip is...

The Label form control adds a static piece of text to a UserForm. The Textbook form controls is an input box for the user to enter text. In this lesson, we add these two form controls to our UserForm.
r/>
This clip is from the...

The UserForm is a custom form that can be configured with labels, textboxes, buttons and more. In this lesson, we create our first UserForm and begin our discussion of popular naming conventions in the VBA community.
r/>
This...

The Worksheet_Change event shoots off when the user edits or deletes a value from a Range in the worksheet. In this lesson, we use it to create a basic pounds-to-kilograms converter that takes a numeric value from column A, applies a...

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

A Boolean is a special data type whose value can only be True or False. In this lesson, we explore the concept of truthiness and falsiness with the help of common mathematical operations and string comparisons.
r/>
This clip is...

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

Excel offers several paste options in its user interface -- pasting just the value, just the formats, and more. In this lesson, we walk through how to emulate this feature in VBA with the help of predefined enumerations.
r/>
...

Copy and paste --- is there a more common task in Excel? In this lesson, we use the Range.Copy and Range.Cut methods to copy, cut, and paste text across a spreadsheet.
r/>
This clip is from the chapter "Range Actions" of the...