This video explains how to use the Union 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 download and install Alteryx.<br/<br/>>

This clip is from the chapter "Introduction to Alteryx" of the series "Alteryx for Beginners".This section introduces you to Alteryx.

In this session, we will see where we can find reports in Jira.<br/<br/>>

This clip is from the chapter "Using Company-Managed Projects" of the series "Course Overview".In this section, we will cover company-managed projects.

In this lesson, we walk through the complete process of creating a new workbook, saving it, making changes, saving it again, and closing it. We introduce the SaveAs and Save methods on the Workbook object and explore their different...

Variables have scope, which describes the boundary or context in which the variable can be used. In this lesson, we explore the 3 types of variable scope:

• local / procedure / macro scope - variables declared in a procedure...

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

This video aims to explain page setup options.
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...

The aim of this video is to explore how to create range names.
r/>
This clip is from the chapter "Excel 2019 Beginners: Working with Names" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll...

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

This video explains how to use the least squared method to break down mixed costs in Managerial Accounting.

In this tutorial, Justin demonstrates how to effectively use the SUMIF function in Microsoft Excel to analyze data sets and calculate specific criteria. He provides three practical examples, including calculating profits and losses,...

In this video tutorial, the instructor demonstrates how to bring back essential elements in Excel that may have disappeared, such as the grid lines, formula bar, and ribbon. By accessing the view menu and utilizing simple checkboxes,...

In this video, I explain clearly how to calculate weighted averages in Microsoft Excel, such as when calculating students' grades where exams and coursework may be weighted differently. I show clearly step by step how such weighted...

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

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

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

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

The Range.Offset property shifts the currently selected range to a new one. It accepts two arguments -- the number of rows and the number of columns to move. Positive arguments represent downward movements for rows and rightward...

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 Visual Basic Editor includes a complex set of options that cover everything from syntactical help with the code to visual aesthetics. In this lesson, we'll explore all of the available options and configure a setup that is ideal...

The initialize event shoots off before the UserForm is rendered. It can be used to calculate configure dynamic values. In this lesson, we create a new form that displays the current day of the week when it loads.
r/>
This clip...

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