Curated Video
Complete Java SE 8 Developer Bootcamp - Comparable
The author implements the Comparable interface as one option for providing this information. This clip is from the chapter "More with Collections" of the series "Complete Java SE 8 Developer Bootcamp".In this section, learn more about...
Curated Video
Excel VBA Programming The Complete Guide - The Range.CurrentRegion Property
The Range.CurrentRegion property looks for the boundaries surrounding the range passed in as the argument. It returns a new Range representing the complete region surrounding the cell. In this lesson, we practice using the CurrentRegion...
Curated Video
Excel VBA Programming The Complete Guide - The Workbooks.Count and Worksheets.Count Properties
The Workbooks.Count property returns the count of open workbooks. The Worksheets.Count property returns the count of worksheets in the selected workbook. In this lesson, we play around with these properties in the Immediate Window. This...
Curated Video
Excel VBA Programming The Complete Guide - Constants
In this lesson, we explore constants, an alternative to variables. A constant's value cannot change over the course of a macro's execution, making it optimal for static values. This clip is from the chapter "Procedures" of the series...
Curated Video
Excel VBA Programming The Complete Guide - Multiple Variable Declarations
VBA allows multiple variables to be declared on a single line. The user has to be careful, however. If the wrong syntax is used, some variables can be assigned an automatic Variant data type. Variant is a chameleon data type that is...
Curated Video
Excel VBA Programming The Complete Guide - The Date Data Type
In this lesson, we practice declaring several dates and times in our procedure and outputting them to the spreadsheet. This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete Guide".In...
Curated Video
Excel VBA Programming The Complete Guide - The OnError Resume Next Keywords
Some errors are not catastrophic to the health of a procedure --- some, in fact, are completely ignorable. In this lesson, we utilize the On Error Resume Next keywords to tell an iteration macro to continue in spite of any errors...
Curated Video
Excel VBA Programming The Complete Guide - Iterating over a Range of Cells with For Each
The For Each construct can also be used to iterate over a range of cells. Each object iterated over will be a single cell, itself a Range object. In this lesson, we iterate over and modify the values in a single column. This clip is from...
Curated Video
Excel VBA Programming The Complete Guide - Absolute vs. Relative References I
The Macro Recorder can record with absolute or relative references. Absolute references (the default recording option) target specific cells (i.e. B1) -- the recorder is more concerned with the destination. Relative references record...
Curated Video
TypeScript for Beginners - Object Literal
This video explains the concept of object literal. This clip is from the chapter "Objects and Arrays" of the series "TypeScript for Beginners".This section introduces you to objects and arrays and demonstrates how to use them.
Curated Video
Excel VBA Programming The Complete Guide - The Range.AutoFit Method
Why manually adjust the width of a column when Excel can do it for you? In this lesson, we employ the Range.AutoFit method to dynamically expand a column so that it is just wide enough to fit all of its internal text. This clip is from...
Curated Video
Excel VBA Programming The Complete Guide - The Formula and FormulaR1C1 Properties
In this lesson, we introduce a basic sum example to show how R1C1 notation can be helpful when duplicating formulas across multiple columns. This clip is from the chapter "Range References" of the series "Excel VBA Programming–The...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Delete Method
The Worksheet.Delete method removes a worksheet. It is particularly effective to temporarily disable alerts before invoking this method to make the process as smooth and seamless for the user as possible. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - Variable Declarations and Assignments
In this lesson, we explore the syntax for declaring a variable and its data type, as well as assigning it an initial value with the assignment operator ( = ). This clip is from the chapter "Variables and Data Types" of the series "Excel...
Curated Video
Excel VBA Programming The Complete Guide - Error and Err.Number
The Err object collects information about errors encountered during macro execution. In this lesson, we explore its helpful Number property and take a look at over 100 different VBA error messages. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Split Function
The Split function splits a string based on the occurrence of a specific character (called a delimiter) and returns the results in an array. In this lesson, we split a cell's value by the presence of slashes and paste the results in...
Curated Video
Excel VBA Programming The Complete Guide - The For Next Loop
The For loop is a fundamental building block of programming. It allows us to iterate, or to repeat a certain block of instructions a given number of times. In this lesson, we explore the syntax for For loops and implement a few...
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
Mockito Tutorial: Learn mocking with 25 Junit Examples - Step 08: Comparing Arrays in JUnit Tests
Unit Testing with Junit: Step 08: Comparing Arrays in JUnit Tests This clip is from the chapter "Unit Testing with Junit" of the series "Mockito Tutorial: Learn mocking with 25 Junit Examples".In this section, we look into unit testing...
Curated Video
The Full Stack Web Development - Getting Started With PHP
Backend Programming with PHP: Getting Started With PHP This clip is from the chapter "Backend Programming with PHP" of the series "The Full Stack Web Development".Here, we talk about all the basics of PHP and move on to OOP, integrate...
Curated Video
TypeScript for Beginners - Array Interfaces
This video demonstrates how to work with array interfaces. This clip is from the chapter "Interfaces" of the series "TypeScript for Beginners".This section introduces you to interfaces and explains how to use them.
Curated Video
C++ Programming By Example - Use STL Algorithms with Containers
How do you use STL algorithms with C++ containers? • Explain iterators • Show examples to further illustrate how they work • Analyze the results of the examples via print statements This clip is from the chapter "Data Structures and...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Select Method
In this section of the course, we take a deep dive into the Range, the most popular object in the Excel Object Model. We begin with the Select method, which highlights the range's boundaries on the spreadsheet. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The Workbooks. Method
In this lesson, we use the Workbooks. method to close every open workbook in Excel. We also configure the procedure to disable alerts temporarily to avoid halting execution. This clip is from the chapter "Object Deep Dive" of the series...