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

This video explains the user interface of Alteryx.<br/<br/>>

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

Why manually adjust the width of a column when Excel can do it for you? In this lesson, we employ the Range.AutoFit method to dynamically expand a column so that it is just wide enough to fit all of its internal text.
r/>
This...

In this lesson, we introduce a basic sum example to show how R1C1 notation can be helpful when duplicating formulas across multiple columns.
r/>
This clip is from the chapter "Range References" of the series "Excel VBA...

The Worksheet.Delete method removes a worksheet. It is particularly effective to temporarily disable alerts before invoking this method to make the process as smooth and seamless for the user as possible.
r/>
This clip is from...

In this lesson, we explore the syntax for declaring a variable and its data type, as well as assigning it an initial value with the assignment operator ( = ).
r/>
This clip is from the chapter "Variables and Data Types" of the...

The Err object collects information about errors encountered during macro execution. In this lesson, we explore its helpful Number property and take a look at over 100 different VBA error messages.
r/>
This clip is from the...

The Split function splits a string based on the occurrence of a specific character (called a delimiter) and returns the results in an array. In this lesson, we split a cell's value by the presence of slashes and paste the results in...

The For loop is a fundamental building block of programming. It allows us to iterate, or to repeat a certain block of instructions a given number of times. In this lesson, we explore the syntax for For loops and implement a few...

Multiple pieces of conditional logic can be chained together with the If, ElseIf and Else keywords. In this lesson, we write a procedure that takes 3 possible paths of execution.
r/>
This clip is from the chapter "Conditionals"...

The aim of this video is to explore how to remove duplicates.
r/>
This clip is from the chapter "Excel 2019 Beginners: Sorting and Filtering" of the series "The Complete Excel Guide: Beginners to Advanced".In this section,...

The aim of this video is to explore how to protect sheets.
r/>
This clip is from the chapter "Excel 2019 Beginners: Formatting Worksheets" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll...

We will explore the additional sheet tab options.
r/>
This clip is from the chapter "Excel 2019 Beginners: Working with Sheets" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll start...

The aim of this video is to explain the course structure for advanced Excel.
r/>
This clip is from the chapter "Excel 2019 Advanced: Introduction to Advanced Course" of the series "The Complete Excel Guide: Beginners to...

The aim of this video is to explore how to apply advanced filters.
r/>
This clip is from the chapter "Excel 2019 Beginners: Sorting and Filtering" of the series "The Complete Excel Guide: Beginners to Advanced".In this section,...

The aim of this video is to explore types of charts.<br/<br/>>

This clip is from the chapter "Excel 2019 Beginners: Charts" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore what are charts.

This video provides an introduction to Excel data driven testing.
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...

In this video, we will learn about the benefits and creation of a DAX Measures table.

• Understand the benefits of organizing measures in a separate
table
• Create a new DAX meas
ures table
• Move existing measures...

In this video, we will learn about the design, form, and function of the report view.

• Learn about the characteristics of Power BI, compared to other
tools
• Learn about the various sections of the rep
ort layout
•...

In this video, we will learn how to translate project requirements into calculations needed for a data model.

• Learn how to break down project requirements into the needed DAX mea
sures
• Understand the types of basic...

In this video, we will learn some crucial concepts about data modeling and table types in data models.

• Understand why we did not import a single
table
• Understand the advantages of using multiple tables in our d
ata...

The aim of this video is to explore how date and time works.
r/>
This clip is from the chapter "Excel 2019 Advanced: Date and Time Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section,...

In this tutorial, the speaker demonstrates how to efficiently use the Flash Fill tool in Microsoft Excel to quickly separate data that has been combined in a single cell. By simply typing out the desired format in separate columns and...

This video introduces the concept of array formulas in Microsoft Excel, demonstrating how they can efficiently perform multiple calculations simultaneously on groups of cells. By using array formulas, complex tasks such as counting the...