Curated Video
Excel VBA Programming The Complete Guide - Call A Procedure from Another one
Learn more about calling procedure. This clip is from the chapter "Procedures" of the series "Excel VBA Programming–The Complete Guide".We look into variable scopes in procedures.
Curated Video
Excel VBA Programming The Complete Guide - The CheckBox Control
The Checkbox is an ideal form control for simple Yes or No questions. In this lesson, we create a new UserForm that allows the user to choose to clear cells and / or save the workbook. We also dive a bit into modifying the aesthetics of...
Curated Video
Excel VBA Programming The Complete Guide - The ListBox Control III - Select Multiple Items
The ListBox offers a way for the user to select more than one option. In this lesson, we enable this setting and configure our code to delete all the worksheets that a user selects from the list. This clip is from the chapter "User...
Curated Video
Excel VBA Programming The Complete Guide - The Range.RemoveDuplicates Method
The Range.RemoveDuplicates method removes the repeating occurrences of a value in a given range. In this lesson, we use it to clear a list of duplicate names and show how arrays can be fed as arguments to methods. This clip is from the...
Curated Video
REST API Automation Testing from Scratch - REST Assured Java - Why Dynamic JSON Payloads are Important to Understand
This video explains the importance of the dynamic JSON payloads. This clip is from the chapter "Handling Dynamic JSON Payloads with Parameterization" of the series "REST API Automation Testing from Scratch - REST Assured Java".This...
Curated Video
REST API Automation Testing from Scratch - REST Assured Java - Apache POI API and Downloading Instructions
This video focuses on Apache POI API and explains how to download instructions. 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
Efficiently Deleting Blank Rows in Excel
If you have multiple blank rows in a spreadsheet it can be very time-consuming to try to delete them either individually, or selecting them and then deleting them. In this quick tutorial I'll show you a very easy way to delete every...
Curated Video
Robotic Process Automation - UiPath RPA Developer Masterclass - Robot #5 Case Introduction
This video provides an introduction to the case that you will be working on. This clip is from the chapter "Robot #5 – Form Field Mania (Medium)" of the series "Robotic Process Automation - UiPath RPA Developer Masterclass".This...
Curated Video
Business Intelligence with Microsoft Power BI - with Material - Conditional Formatting in a Table
This video explains how to perform conditional formatting in a table. This clip is from the chapter "Tables and Matrix in Power BI" of the series "Business Intelligence with Microsoft Power BI - with Material".This section provides an...
Curated Video
Full Stack Web Development MASTERY Course - Novice to Expert - Basic Fundamentals of MongoDB
This video explains the basic fundamentals of MongoDB. This clip is from the chapter "MongoDB + Mongoose (Zero to Hero)" of the series "Full Stack Web Development Mastery Course - Novice to Expert".This section focuses on MongoDB and...
Curated Video
Google Sheets Fundamentals - Exporting Your Work
Exporting to a New Format • Excel/ ODF • PDF • HTML for Web Display • CSV
Curated Video
Using Chat GPT with Google Docs: Tips and Tricks
In this lesson, we'll explore how to use Chat GPT with Google Docs. We'll cover the steps to add the Chat GPT add-on to your Google Drive, how to launch the Chat GPT sidebar, and the different types of actions and suggestions available...
Curated Video
Using ChatGPT on Excel Sheets: Creating and Activating API Key
In this lesson, you will learn how to install and activate the ChatGPT add-on on your Excel or Drive documents. You will also learn how to create a valid API key by going to the ChatGPT playground and pasting it into the add-on's...
Curated Video
Installing ChatGPT Add-On in Excel and Google Doc Files
In this lesson, we learn how to install the ChatGPT add-on to Excel and Google Doc files. The lesson provides step-by-step instructions on how to search for and install the add-on, and shows how it can be accessed in different document...
Catalyst University
NO BS: Multiple Regression Excel Tutorial
NO BS: Multiple Regression Excel Tutorial
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Move Method
The Worksheet.Move method moves a worksheet to a different position in the order of workbook sheets. In this lesson, we explore the signature of the method including its familiar Before and After parameters. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheets.Add Method
The Worksheets.Add method creates a new worksheet in the current Workbook. It accepts either one of two optional arguments, Before and After, that determine where the new worksheet will be placed. This clip is from the chapter "Object...
Curated Video
Excel VBA Programming The Complete Guide - The Boolean Data Type
In this lesson, we practice declaring a procedure with Boolean variables and discuss the contexts in which they can be used. This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - Methods with Arguments
In this lesson, we use the official Microsoft Developer Network documentation to look up the Worksheet object and the Protect method. We discuss the idea of method parameters, which are names we give to expected inputs. We also explore 2...
Curated Video
Excel VBA Programming The Complete Guide - Submit the UserForm
In this lesson, we wire up the final Command Button on our UserForm to capture the user's input and populate it on the spreadsheet. This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The Complete Guide".null
Curated Video
Excel VBA Programming The Complete Guide - Add Event Procedure to Control
In this lesson, we create our first event procedure to react to the Change event on our Textbox. Upon any user edit, it outputs the current entry to the Immediate Window. This clip is from the chapter "User Forms" of the series "Excel...
Curated Video
Excel VBA Programming The Complete Guide - The ListBox Control II - React to User Selection
In this lesson, we wire up a Command Button event procedure to delete the single worksheet the user has selected from the ListBox. This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The Complete Guide".null
Curated Video
Creating Dropdown Lists in Excel
This video tutorial demonstrates how to create a dropdown list in a spreadsheet to easily select predefined options, such as student effort levels like excellent, good, fair, poor, and unacceptable. By setting up a list of options and...
Curated Video
Web Scraping Tutorial with Scrapy and Python for Beginners - Saving Data Locally to Excel ( XLSX ) Files
In this video, you will learn how to use item pipelines in Python to save scraped data locally to an Excel file. The video explains the three steps of this process and walks through the code needed to create an Excel workbook, add...