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...

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...

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...

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...

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...

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...

The For Each construct iterates over every single object in a collection. In this lesson, we practice iterating over the Workbooks and Worksheets collections.
r/>
This clip is from the chapter "Iteration" of the series "Excel...

Let's understand what are absolute values.
r/>
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...

The aim of this video is to explore how to work with links.
r/>
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...

In this video, we will explore the top title section of the report and see what types of information should be displayed there.

• Add a title and image to the r
eport
• Understand what types of information should be...

In this video, we will learn how to connect to any data source with the help of Power Query.

• Look at the various types of data connections we can make with the help of Power
Query
• Understand how to connect to data...

Mercy me, how are cell potential, equilibrium constants, and free energy change all related? By a few different equations, that's how. See if you can solve for these values given some data!

In this video tutorial I show you how simple and easy it is to name a cell in a Microsoft Excel spreadsheet, and then refer to that cell by its name elsewhere in the spreadsheet. Referring to cells using descriptions and names makes much...

This video tutorial demonstrates how to hide and unhide columns in a spreadsheet efficiently. It explains the process of hiding columns to declutter the view without deleting important data, and then provides clear steps on how to easily...

Learn how to efficiently separate first names and surnames from a list of names in Excel using the Text to Columns feature. By following simple steps, you can split the data into separate columns, eliminating numbers and organizing the...

Learn how to quickly rotate tables in Excel by transposing the data through 90 degrees. Instead of manually rearranging information, discover the hidden "transpose" feature in Excel's paste special option. This efficient technique allows...

In this video tutorial, learn how to round numbers in a spreadsheet to a set number of decimal places using the ROUND function. The instructor demonstrates how to easily round numbers to two decimal places and ensure consistency across...

In this tutorial, Justin demonstrates how to tidy up a large spreadsheet in Microsoft Excel using checkboxes. By hiding or compressing sections with checkboxes, users can easily navigate through the spreadsheet and focus on specific...

MATLAB solves nonlinear equations either symbolically or numerically with solvers such as "fsolve". This example demonstrates how to obtain a solution to sets of nonlinear equations.

In this video, you will take a closer look at Data Table variables and all the things we can do with them.
<
br/>
This clip is from the chapter "Tech Primer – Variables and Data Types" of the series "Robotic Process Automation -...

As the director of faculty equity and inclusion, Nilanjana (Buju) Dasgupta works with faculty and develops policies and programs that can be implemented college-wide to increase diversity in the hiring, retention, success, and...

This video explains how to use the Date and Time tool in Alteryx.<br/<br/>>

This clip is from the chapter "In/Out Tab" of the series "Alteryx for Beginners".This section provides an introduction to the In/Out tab in Alteryx.

In this lesson, we wire up the UserForm to iterate over all of the workbook's worksheets and normalize the font name and size based upon the user's ComboBox selections.
r/>
This clip is from the chapter "User Forms" of the...

The ComboBox is a dropdown of predefined options that can optionally accept a new user input. In this lesson, we create two ComboBoxes to accept a font name and a font size.
r/>
This clip is from the chapter "User Forms" of the...