Curated Video
The Complete Excel Guide: Beginners to Advanced - File Extensions, Share, Export, and Publish Files
Understand file extensions, share, export, and publish files. This clip is from the chapter "Excel 2019 Beginner: Saving Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Working with the Save and Save As Commands
Let's explore the Save and Save As Commands. This clip is from the chapter "Excel 2019 Beginner: Saving Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to save a workbook in...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Custom Views
The aim of this video is to explore the custom views option. This clip is from the chapter "Excel 2019 Beginners: Working with Views" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll learn how to...
Curated Video
Selenium Python Automation Testing from Scratch and Frameworks - Reading and Writing Data from Excel to Python Tests
This video demonstrates how to read and write data from Excel to Python. 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...
Curated Video
Selenium Python Automation Testing from Scratch and Frameworks - Integrating Excel Utility into Selenium Python Framework
This video explains how to integrate the Excel utility into Selenium Python Framework. This clip is from the chapter "Part V-Reading and Writing Data from Excel to Selenium Python Framework" of the series "Selenium Python Automation...
Curated Video
C++ Developer - Logical Operators
This video explains the logical operators. This clip is from the chapter "Fundamentals of C++" of the series "The Complete C++ Developer Course".This section discusses the fundamentals of C++.
Curated Video
Power BI Masterclass - Advanced DAX - Total Open Customer Complaints in Power BI
In this video, we will cover some advanced DAX to find total open customer complaints in Power BI. This clip is from the chapter "DAX, R, and Gateways" of the series "Power BI Masterclass".In this section, we will be covering DAX, R, and...
Curated Video
Power BI Masterclass - How to Always Get the Latest File from a Folder into Power BI
In this video, we will learn how to always get the latest file from a folder into Power BI. This clip is from the chapter "Additional Tips and Tricks" of the series "Power BI Masterclass".In this section, we will be covering some...
Curated Video
Alteryx for Beginners - Cross Tab Tool
This video explains how to use the Cross Tab 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
Alteryx for Beginners - Data Cleansing Tool - Part 2
This is the second part of the two-part video that explains how to use the Data Cleansing 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
Excel VBA Programming The Complete Guide - The Range.End Property
In this lesson, we write values to the four corners of the spreadsheet using the Range.End property and discuss the predefined constants (enumerations) passed in as arguments. This clip is from the chapter "Range References" of the...
Curated Video
Excel VBA Programming The Complete Guide - Access Object from Collection by Name
In this lesson, we explore this with the context of Worksheet objects inside the Worksheets collection. This clip is from the chapter "The Fundamentals of the Excel Object Model" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - Stepping Through Code
The F8 key allows us to step through the lines of a procedure step by step. In this lesson, we see how this functionality grants tremendous power when debugging a complex piece of code. This clip is from the chapter "Debugging" of the...
Curated Video
Excel VBA Programming The Complete Guide - VBA Functions, Part II
In this lesson, we explore 5 additional utility functions available in the Visual Basic Editor: • Left for pulling out characters from the beginning of a string • Right for pulling out characters from the end of a string • Mid for...
Curated Video
Excel VBA Programming The Complete Guide - The Option Base 1 Syntax and Write Array Values to Cells
If zero-based indexing is confusing, the Option Base 1 keywords at the top of a module force an array to start at an index position of 1. In this lesson, we enable this setting and see its results in a newly declared array. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - The InputBox Function
In this lesson, we use the InputBox function to collect a new worksheet title from the user. The InputBox is a basic dialog box with a single text entry field, a prompt, a title, and OK / Cancel buttons. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - Exit For and Review of Exit Sub
The Exit For keywords prematurely terminate a For loop. The Exit Sub keywords prematurely terminate a procedure. In this lesson, we practice implementing these concepts. This clip is from the chapter "Iteration" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - SpecialCells
The Range.SpecialCells method extracts a subset of cells from a Range based on a criteria -- empty cells, cells with constants, cells with formulas, etc. In this lesson, we populate a column with various values and use the method to...
Curated Video
Excel VBA Programming The Complete Guide - Absolute vs. Relative References II
In this lesson, we continue our exploration of absolute vs relative references by recording a macro that deletes a row from the worksheet. Absolute references explicitly target a specific row each time, which defeats the purpose of the...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Table References
The aim of this video is to explore what are table references. This clip is from the chapter "Excel 2019 Advanced: Tables" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore the tables.
Curated Video
The Complete Excel Guide: Beginners to Advanced - Connecting Web Data Sources
The aim of this video is to explore how to connect to web data sources. 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,...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Comments
This video aims to explain comments. This clip is from the chapter "Excel 2019 Beginner: Page Setup and Print Options" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to explore page setup and print...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Arranging Files
The aim of this video is to explore how to arrange files. This clip is from the chapter "Excel 2019 Beginners: Working with Views" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll learn how to work...
Curated Video
Selenium Python Automation Testing from Scratch and Frameworks - Loading the Excel Data
This video explains how to load the Excel data. 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 Frameworks".This...