Curated Video
Excel VBA Programming The Complete Guide - The Range.Worksheet Property
In certain cases, VBA allows us to traverse the Excel object model in reverse --- from the bottom up. One such example is the Range.Worksheet property, which returns a Worksheet object that encloses a Range. In this lesson, we practice...
Curated Video
Excel VBA Programming The Complete Guide - The Cells Property
In this lesson, we practice selecting single-cell Range objects with the Cells property before applying the Resize property to expand the selection to multi-cell Ranges. This clip is from the chapter "Range References" of the series...
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 - 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...
Brian McLogan
Can you simplify the square root of these 43 numbers?
In this video we work through 43 different examples for simplifying radical expressions. We focus on the square roots of numbers and simplify using the rules of exponents and prime factorization. After working through this worksheet you...
Brian McLogan
Can you evaluate these 16 Logarithms without a calculator?
In this video I work through 16 different examples of evaluating a logarithm with a base of 2 and 3. We will evaluate logarithms that have an argument of integers and fractions.
Curated Video
Excel VBA Programming The Complete Guide - The Range.Row and Range.Column Properties
The Range.Row and Range.Column properties return numbers that represent the numeric position of the cell's row and column relative to the spreadsheet. If a multi-cell Range is used, VBA uses the top-left cell as its reference point. In...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Count and Range.CountLarge Properties
In this lesson, we use the Range.Count and Range.CountLarge properties to find out the number of cells in a given range. The returned value counts all cells, not just those with values. This clip is from the chapter "Range References" of...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet.Copy Method
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...
Curated Video
Excel VBA Programming The Complete Guide - Predefined Constants
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...
Curated Video
Excel VBA Programming The Complete Guide - The Name Property on Workbook and Worksheet Objects
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...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_Activate Event
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 sheet's...
Curated Video
Excel VBA Programming The Complete Guide - The For Each-Next Construct
The For Each construct iterates over every single object in a collection. In this lesson, we practice iterating over the Workbooks and Worksheets collections. This clip is from the chapter "Iteration" of the series "Excel VBA...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Functions - Part 1
What are the functions? This clip is from the chapter "Excel 2019 Advanced: Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore what are functions.
Curated Video
Excel VBA Programming The Complete Guide - The ComboBox Control II
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. This clip is from the chapter "User Forms" of the series "Excel VBA...
Brian McLogan
How to factor 73 different examples
Need help with factoring? I show you how to factor 73 examples of quadratic trinomials to better improve your understanding of factoring. I keep it easy by only working through examples where a=1 and c is 1-12. By the end of the video...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Working with PivotTables
The aim of this video is to explore how to work with PivotTables. This clip is from the chapter "Excel 2019 Advanced: PivotTables" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we’ll explore PivotTables.
Kids’ Poems and Stories With Michael Rosen
Chapter 8 | You're Thinking About Tomatoes | STORY
You're Thinking About Tomatoes - Chapter 8 Kids' Poems and Stories With Michael Rosen. A sequel to the very popular ‘You're Thinking About Doughnuts’. Frank is back among the ruins of the past again, this time on a school trip to a...
Brian McLogan
Master Evaluating the half angle for sine, cosine, and tangent given an equation and constraint
Master Evaluating the half angle for sine, cosine, and tangent given an equation and constraint
Curated Video
Excel VBA Programming The Complete Guide - The Range.Offset Property
The Range.Offset property shifts the currently selected range to a new one. It accepts two arguments -- the number of rows and the number of columns to move. Positive arguments represent downward movements for rows and rightward...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_SelectionChange Event
The Worksheet_SelectionChange event is triggered when the user navigates to a different cell with a spreadsheet. In this lesson, we react our first Excel event and also explore the ByVal keyword in the automatically generated procedure....
Curated Video
Excel VBA Programming The Complete Guide - The ListBox Control I - Wire up the Form
In the first of a 3-part series, we introduce the ListBox form control for displaying a list of predefined values for the user to choose from. We hardwire our list to show the names of all of the workbook's sheets. This clip is from the...