Curated Video
REST API Automation Testing from Scratch - REST Assured Java - Strategy to Access Excel Data
This video explains the strategy to access Excel data. 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...
Curated Video
Learning Microsoft Power BI - Intelligent Data Filtering with Power Query
In this video, we will learn how to apply data filtering. • Understand why we should filter data • Apply data transformations to the FACTSales table • Filter the data using Power Query This clip is from the chapter "Common Data...
Curated Video
Learning Microsoft Power BI - Reviewing Project Requirements and Determining Data Sources
In this video, we are going to review project requirements and determine data sources. • Learn how to take a given set of requirements • Understand what finalizing the requirements by multiple refinement and review iterations means •...
Curated Video
Excel: Easy Ways to Add Numbers in Cells
This video tutorial demonstrates two simple methods for adding up numbers in Microsoft Excel. The first method involves manually typing a formula to add specific cells together, while the second method utilizes the autosum feature to...
Curated Video
Robotic Process Automation - UiPath RPA Developer Masterclass - Robot #6 Case Introduction
This video provides an introduction to the case that you will be working on. This clip is from the chapter "Robot #6 - Amazon Data Scraping (Medium)" of the series "Robotic Process Automation - UiPath RPA Developer Masterclass".This...
Curated Video
Power BI Masterclass - Power BI Data Prep Challenge 1 - Date Time Conversion
In this video, we will be covering a challenge for date time conversion. This clip is from the chapter "Solving Data Prep Challenges" of the series "Power BI Masterclass".In this section, we will learn how to do data preparation, data...
Curated Video
Alteryx for Beginners - Transpose Tool
This video demonstrates how to use the Transpose tool in Alteryx. This clip is from the chapter "Transform Tab" of the series "Alteryx for Beginners".This section explores the Transform tab.
Curated Video
Excel VBA Programming The Complete Guide - The Range.Interior Property
What the Font object is to the foreground, the Interior property is to the background. In this lesson, we use the Range.Interior property to modify the color of a cell in a variety of different ways including: • VBA color constants • The...
Curated Video
Excel VBA Programming The Complete Guide - The Range.TextToColumns Method
The Range.TextToColumns method splits a string based on a delimiter, a special symbol. In this lesson, we use this feature to separate several strings, applying a variety of delimiters (commas, spaces, even custom vertical pipes) along...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Replace Method
The Range.Replace method acts as a Find-and-Replace search mechanism. In this lesson, we apply it to a range of values in column A and discover a unique quirk when it comes to replacing numbers. This clip is from the chapter "Range...
Curated Video
Excel VBA Programming The Complete Guide - R1C1 Notation, Part II
In this lesson, we continue to expand on the R1C1 concepts introduced in the past lesson by applying them to several real-life examples. This clip is from the chapter "Range References" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - The Range.EntireRow and Range.EntireColumn Properties
The Range.EntireRow and Range.EntireColumn properties are used to target a complete row or column from a single cell. In this lesson, we play around with the two properties in the Immediate Window. This clip is from the chapter "Range...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Row and Range.Column Properties
The Range.Row and Range.Column properties return numbers that represent the numeric position of the cell's row and column relative to the spreadsheet. If a multi-cell Range is used, VBA uses the top-left cell as its reference point. In...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Count and Range.CountLarge Properties
In this lesson, we use the Range.Count and Range.CountLarge properties to find out the number of cells in a given range. The returned value counts all cells, not just those with values. This clip is from the chapter "Range References" of...
Curated Video
Excel VBA Programming The Complete Guide - The Application.DisplayAlerts Property
The Application.DisplayAlerts property is used to enable or disable user alerts in Excel. An alert is a dialog box that warns the user of an impending operation. It's a helpful feature but can be distracting when the user is executing a...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Copy Method
The Worksheet.Copy method copies the contents of a worksheet to a new worksheet. When invoked with no arguments, it will create the copy in a brand new workbook. With either a Before or After argument, the copy will be placed in the...
Curated Video
Excel VBA Programming The Complete Guide - Predefined Constants
In this lesson, we dive into predefined constants or enumerations. These are constants built into the VBA language itself that evaluate to numbers. They are used internally by VBA whenever several options are needed that cannot be...
Curated Video
Excel VBA Programming The Complete Guide - The Immediate Window and Debug.Print Method
The Immediate Window is a console or playground within the Visual Basic Editor that allows the developer to test out snippets of VBA code. The IW can be used to get or set property values, invoke object methods and more. In this lesson,...
Curated Video
Excel VBA Programming The Complete Guide - The Name Property on Workbook and Worksheet Objects
In this lesson, we explore the Name property on both a Worksheet and Workbook object. The Name property is only readable on a Workbook but is readable and writeable on a Worksheet. The key takeaway is that object design differs; just...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_Activate Event
The Worksheet_Activate event is triggered when the user navigates to a different worksheet. It can be used to provide the user with instructions or warnings. In this lesson, we write a quick procedure to MsgBox out the activated sheet's...
Curated Video
Excel VBA Programming The Complete Guide - Dynamic Arrays
A dynamic array can be resized repeatedly throughout a procedure to hold a different number of elements. This can be helpful when we cannot predict an array size in advance. In this lesson, we use a dynamic array to contain a list of...
Curated Video
Excel VBA Programming The Complete Guide - The For Each-Next Construct
The For Each construct iterates over every single object in a collection. In this lesson, we practice iterating over the Workbooks and Worksheets collections. This clip is from the chapter "Iteration" of the series "Excel VBA...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Absolute Values
Let's understand what are absolute values. This clip is from the chapter "Excel 2019 Beginners: Formulas and Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore formulas and functions.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Working with Links
The aim of this video is to explore how to work with links. 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 files.