It's easy to see object properties as simple, static data values -- integers, floating point numbers, or strings. However, object properties can also store other objects, complete with their own distinct properties and methods. In this...

Some objects in VBA are collection objects. Their purpose is to serve as a box or container for related objects. For example, the Worksheets collection object stores a Worksheet object for each worksheet in a Workbook. In this lesson,...

Multiple conditions can be checked with the And and Or logical operators. In this lesson, we apply these principles to conditional logic across two columns.
r/>
This clip is from the chapter "Conditionals" of the series "Excel...

We discuss the benefits offered by the technology, the tools and features available in VBA, a brief history of the language including its precursors Basic and Visual Basic and the prerequisites for the course.
r/>
This clip is...

You will learn all about Macro malware, why they are so popular, having become a go-to means of infiltrating a computer in devastating fashion. You will also learn how to easily spot malicious macros, as well as protect yourself...

In this section, we'll explore the objects in the Excel object hierarchy in greater depth. We begin with the Application object at the top of the hierarchy. Its properties and methods deal with top-level, global Excel settings....

In this Excel tutorial, we will learn about the Excel interface and basic shortcuts. We will cover the options and ribbons, where to insert various formulas, and how to find row and column numbers. By the end of this tutorial, you will...

This video explains how to use the Running Total tool in Alteryx.<br/<br/>>

This clip is from the chapter "Transform Tab" of the series "Alteryx for Beginners".This section explores the Transform tab.

Python packages such as numpy, scipy, matplotlib, xlwings, pygame, openCV, and others extend the capabilities of this capable programming language. Installing packages is accomplished with downloadable installer packages or through the...

This video explains how to read an MS Excel files using POI.<br/<br/>>

This clip is from the chapter "Working with MS Excel Files (Apache POI)" of the series "Learn How to Code: The Complete Core Java Programming Course".null

In this Microsoft Excel tutorial, we learn how to create basic formulas using operators such as addition, subtraction, multiplication, division, percentage, and exponentiation. The tutorial provides step-by-step instructions on how to...

In this Microsoft Excel tutorial, we explore the structure of an Excel workbook and discuss its various maximum limits. From the number of worksheets and rows to the column width and character limits, we cover all the essential...

This video tells you what mindset is required from here onwards. • A quick chat on the main mindset prerequisites • Brief description of the example problem

The MATLAB internet installer is downloaded from MathWorks.com. It requires an account associated with a valid MathWorks license. This video walks through the setup and installation of MATLAB as well as adding packages such as the one...

This video explains page object model.
<
br/>
This clip is from the chapter "Framework Part 8 - Page Object Pattern and Page Factory" of the series "Selenium WebDriver with Java - Basics to Advanced and Frameworks".This section...

This video presents the second part of the Excel driven testing practice exercise.
<
br/>
This clip is from the chapter "Framework Part 6: Data Driven Testing Utilities" of the series "Selenium WebDriver with Java - Basics to...

In this video, I show you how to perform a Dixon Q-test on a data set, and how to interpret the Q-values for discarding a data point.<br/>

Linear and polynomial regression is demonstrated in Excel. The data is show on a plot with trend lines added as linear, quadratic, and cubic correlations.

This is a tutorial on how to change margins, scaling, and orientation in Microsoft Excel for printing purposes. It covers both manual adjustments and using the mouse to adjust margins, as well as selecting portrait or landscape...

This video demonstrates how to use the Formula tool in Alteryx with the help of multiple examples.
r/>
This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the...

This video explains how to use the Multi-Row Formula tool in Alteryx.<br/<br/>>

This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.

Many people seem to struggle with formatting percentages in Microsoft Excel, with 100% seemingly equivalent to 1000% or more! In this tutorial I'll explain what's really going on, how to use the percentage tool correctly, demonstrate why...

In this quick tutorial I'll show you how to add a diagonal line or border to a cell in Microsoft Excel and how to format that line by changing width and color.

In this video, we will learn how to create a line and column combo chart and supporting DAX measures.

• Learn about the DAX CALCULATE function and how it incorporates filters inside the me
asure
• Understand the ways in...