Instructional Video10:42
Curated Video

Excel VBA Programming The Complete Guide - The ElseIf and Else Statements

Higher Ed
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. This clip is from the chapter "Conditionals" of the series...
Instructional Video7:46
Curated Video

The Complete Excel Guide: Beginners to Advanced - Remove Duplicates

Higher Ed
The aim of this video is to explore how to remove duplicates. 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, we'll explore what...
Instructional Video9:01
Curated Video

The Complete Excel Guide: Beginners to Advanced - Protecting Sheets

Higher Ed
The aim of this video is to explore how to protect sheets. 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 learn how to...
Instructional Video5:19
Curated Video

The Complete Excel Guide: Beginners to Advanced - Additional Sheet Tab Options

Higher Ed
We will explore the additional sheet tab options. 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 working with sheets.
Instructional Video4:20
Curated Video

The Complete Excel Guide: Beginners to Advanced - Course Structure

Higher Ed
The aim of this video is to explain the course structure for advanced Excel. This clip is from the chapter "Excel 2019 Advanced: Introduction to Advanced Course" of the series "The Complete Excel Guide: Beginners to Advanced".Now, with...
Instructional Video4:47
Curated Video

The Complete Excel Guide: Beginners to Advanced - Advanced Filters

Higher Ed
The aim of this video is to explore how to apply advanced filters. 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, we'll explore...
Instructional Video5:59
Curated Video

The Complete Excel Guide: Beginners to Advanced - Types of Charts

Higher Ed
The aim of this video is to explore types of charts. 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.
Instructional Video8:42
Curated Video

Selenium Python Automation Testing from Scratch and Frameworks - Introduction to Excel Data-Driven Testing

Higher Ed
This video provides an introduction to Excel data driven testing. 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...
Instructional Video5:00
Curated Video

Learning Microsoft Power BI - Creating a DAX Measures Table

Higher Ed
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 measures table • Move existing measures from the data table...
Instructional Video3:59
Curated Video

Learning Microsoft Power BI - Report View Walkthrough

Higher Ed
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 report layout • Learn about the...
Instructional Video3:17
Curated Video

Learning Microsoft Power BI - Translating Report Requirements into DAX Measures

Higher Ed
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 measures • Understand the types of basic DAX measures that...
Instructional Video5:31
Curated Video

Learning Microsoft Power BI - Table Types and Relational Data Modeling

Higher Ed
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 data models • Identify...
Instructional Video10:00
Curated Video

The Complete Excel Guide: Beginners to Advanced - How Date and Time Works

Higher Ed
The aim of this video is to explore how date and time works. 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, we'll explore the...
Instructional Video3:21
Curated Video

Excel: How to Use the Flash Fill Tool for Data Separation

Pre-K - Higher Ed
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...
Instructional Video7:29
Curated Video

Using Goal Seek Tool in Excel to Set Target Grades for Students

Pre-K - Higher Ed
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...
Instructional Video7:16
Curated Video

Mastering Data Sorting in Microsoft Excel

Pre-K - Higher Ed
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...
Instructional Video8:48
Curated Video

Introduction to Array Formulas in Microsoft Excel

Pre-K - Higher Ed
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...
Instructional Video8:19
Curated Video

Mastering Tableau 2018.1, Second Edition 2.1: Understanding the Connect Page and Global Superstore Dataset

Higher Ed
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
Instructional Video7:01
Curated Video

Alteryx for Beginners - Find and Replace Tool

Higher Ed
This video demonstrates how to use the Find and Replace tool in Alteryx. This clip is from the chapter "Join Tab" of the series "Alteryx for Beginners".This section explores the Join tab.
Instructional Video4:39
Curated Video

Alteryx for Beginners - Append Fields Tool

Higher Ed
This video demonstrates how to use the Append Fields tool in Alteryx. This clip is from the chapter "Join Tab" of the series "Alteryx for Beginners".This section explores the Join tab.
Instructional Video2:46
Curated Video

Alteryx for Beginners - Filter Tool (Number Example)

Higher Ed
This video demonstrates how to use the Filter tool for numerical data in Alteryx. This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.
Instructional Video4:54
Curated Video

Alteryx for Beginners - Select Tool

Higher Ed
This video explains how to use the Select tool in Alteryx. This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.
Instructional Video4:18
Curated Video

Alteryx for Beginners - Output Tool - Updating Existing Data

Higher Ed
This video demonstrates how to use Alteryx as the Output tool for updating existing data. This clip is from the chapter "In/Out Tab" of the series "Alteryx for Beginners".This section provides an introduction to the In/Out tab in Alteryx.
Instructional Video6:01
Curated Video

Alteryx for Beginners - Summarize Tool

Higher Ed
This video explains how to use the Summarize tool in Alteryx. This clip is from the chapter "Transform Tab" of the series "Alteryx for Beginners".This section explores the Transform tab.