Curated Video
Excel VBA Programming The Complete Guide - The ElseIf and Else Statements
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Remove Duplicates
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Protecting Sheets
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Additional Sheet Tab Options
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.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Course Structure
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Advanced Filters
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Types of Charts
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.
Curated Video
Selenium Python Automation Testing from Scratch and Frameworks - Introduction to Excel Data-Driven Testing
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...
Curated Video
Learning Microsoft Power BI - Creating a DAX Measures Table
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...
Curated Video
Learning Microsoft Power BI - Report View Walkthrough
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...
Curated Video
Learning Microsoft Power BI - Translating Report Requirements into DAX Measures
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...
Curated Video
Learning Microsoft Power BI - Table Types and Relational Data Modeling
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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - How Date and Time Works
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...
Curated Video
Excel: How to Use the Flash Fill Tool for Data Separation
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...
Curated Video
Using Goal Seek Tool in Excel to Set Target Grades for Students
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...
Curated Video
Mastering Data Sorting in Microsoft Excel
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...
Curated Video
Introduction to Array Formulas in Microsoft Excel
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...
Curated Video
Mastering Tableau 2018.1, Second Edition 2.1: Understanding the Connect Page and Global Superstore Dataset
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
Curated Video
Alteryx for Beginners - Find and Replace Tool
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.
Curated Video
Alteryx for Beginners - Append Fields Tool
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.
Curated Video
Alteryx for Beginners - Filter Tool (Number Example)
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.
Curated Video
Alteryx for Beginners - Select Tool
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.
Curated Video
Alteryx for Beginners - Output Tool - Updating Existing Data
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.
Curated Video
Alteryx for Beginners - Summarize Tool
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.