Curated Video
The Complete Excel Guide: Beginners to Advanced - Financial Functions and Terminology
The aim of this video is to explore financial functions and terminology. This clip is from the chapter "Excel 2019 Advanced: Financial Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Opening a File
Let's open a file. This clip is from the chapter "Excel 2019 Beginner: Navigating Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to navigate a workbook in Excel.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Relative References
Learn about the relative references. This clip is from the chapter "Excel 2019 Beginner: Creating Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to create a workbook in Excel.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Customizing Ribbons and Tabs
The aim of this video is to explore how to customize ribbons and tabs 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...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Consolidating Data
The aim of this video is to explore how to consolidate data. This clip is from the chapter "Excel 2019 Beginners: Linking Files" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll learn how to link...
Curated Video
REST API Automation Testing from Scratch - REST Assured Java - Testing Excel Integration with REST Assured
This video explains how to test the integration of Excel with REST Assured. This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API Automation Testing from Scratch - REST Assured Java".This...
Curated Video
REST API Automation Testing from Scratch - REST Assured Java - Introduction to Library API - Excel Integration with REST Assured Test
This video presents an introduction to Library API. This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API Automation Testing from Scratch - REST Assured Java".This section explains the strategy...
Curated Video
Learning Microsoft Power BI - Slicers and Filter Settings
In this video, we will see in what ways slicers can allow users to interact with reports. • Learn the various slicer types in Power BI based on data type • Learn about drop-down slicer types • Create the slicers based on the client...
Curated Video
Learning Microsoft Power BI - Merging Tables with Power Query
In this video, we will learn merging tables. • Understand why we have to merge tables • Understand what it means to merge tables • Combine data from multiple tables into a single table This clip is from the chapter "Common Data...
Curated Video
Learning Microsoft Power BI - Common Data Transformations with Power Query
In this video, we will cover the three most common transformations you will apply to any table. • Open up the query editor to look at the seven queries that can be edited • Apply the different steps to the DIMProduct table • Rinse and...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Get and Transform
The aim of this video is to explore get and transform. This clip is from the chapter "Excel 2019 Advanced: Connecting to External Data" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll learn how to...
Curated Video
The Complete Excel Guide: Beginners to Advanced - PivotTables
The aim of this video is to explore PivotTables. This clip is from the chapter "Excel 2019 Beginners: PivotTables" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we’ll understand and explore PivotTables.
Curated Video
Sorting Dates Chronologically in Microsoft Excel
In this tutorial, the teacher demonstrates how to sort a table of people's names and dates of birth chronologically in Microsoft Excel. The instructor explains the process of formatting the date cells, selecting the column to be sorted,...
Curated Video
Business Intelligence with Microsoft Power BI - with Material - Creating the Map of India in Power BI
This video demonstrates how to create the map of India in Power BI. This clip is from the chapter "Maps in Power BI" of the series "Business Intelligence with Microsoft Power BI - with Material".This section focuses on the types of maps...
Curated Video
Power BI Masterclass - Power Query Editor Tips and Tricks: How to Extract Patterns from Columns
In this video, we will learn how to extract patterns from columns. This clip is from the chapter "Additional Tips and Tricks" of the series "Power BI Masterclass".In this section, we will be covering some additional tips and tricks....
Curated Video
Alteryx for Beginners - Union Tool
This video explains how to use the Union 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 - Downloading and Installing Alteryx
This video demonstrates how to download and install Alteryx. This clip is from the chapter "Introduction to Alteryx" of the series "Alteryx for Beginners".This section introduces you to Alteryx.
Curated Video
Getting Started with JIRA - Reports in Jira
In this session, we will see where we can find reports in Jira. This clip is from the chapter "Using Company-Managed Projects" of the series "Course Overview".In this section, we will cover company-managed projects.
Curated Video
Excel VBA Programming The Complete Guide - The Workbook.SaveAs and Workbook.Save Methods
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 use...
Curated Video
Excel VBA Programming The Complete Guide - Variable Scope
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 are limited...
Curated Video
Excel VBA Programming The Complete Guide - Unload and Hide a UserForm
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...
Curated Video
Excel VBA Programming The Complete Guide - Select Case
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. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Application.ScreenUpdating Property
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 this...
Curated Video
Excel VBA Programming The Complete Guide - The NOT Operator
The NOT operator reverses a Boolean value. In this lesson, we use it to design our own implementation of Excel's bolding feature. This clip is from the chapter "Conditionals" of the series "Excel VBA Programming–The Complete Guide".In...