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...
Curated Video
Excel VBA Programming The Complete Guide - Syntax Tips
In this lesson, we'll explore some tips for writing cleaner and more elegant VBA code. This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete Guide".In this section, we work with...
Curated Video
Excel VBA Programming The Complete Guide - Comments
In this lesson, we'll explore the benefits of comments to the developer and practice writing them in the context of a procedure. This clip is from the chapter "The Visual Basic Editor" of the series "Excel VBA Programming–The Complete...
Curated Video
Excel VBA Programming The Complete Guide - Create and Delete a Procedure
A procedure is a grouped set of instructions / code that accomplishes some kind of goal. We'll also talk about some of the common syntactical errors made when writing out procedures. In this lesson, we'll dive into the syntax to declare...
Curated Video
Excel VBA Programming The Complete Guide - Design Aesthetics
The Format menu in the Visual Basic Editor offers options for aligning, grouping, and resizing one or more form controls. In this lesson, we apply these techniques to the controls in our employees UserForm. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The Label and TextBox Controls
The Label form control adds a static piece of text to a UserForm. The Textbook form controls is an input box for the user to enter text. In this lesson, we add these two form controls to our UserForm. This clip is from the chapter "User...
Curated Video
Excel VBA Programming The Complete Guide - Create UserForm, Toolbox, Properties, Controls
The UserForm is a custom form that can be configured with labels, textboxes, buttons and more. In this lesson, we create our first UserForm and begin our discussion of popular naming conventions in the VBA community. This clip is from...
Curated Video
Excel VBA Programming The Complete Guide - The Worksheet_Change Event
The Worksheet_Change event shoots off when the user edits or deletes a value from a Range in the worksheet. In this lesson, we use it to create a basic pounds-to-kilograms converter that takes a numeric value from column A, applies a...
Curated Video
Excel VBA Programming The Complete Guide - Deleting Rows
Deleting rows from a spreadsheet can be a risky operation --- if moving downwards in direction, there's a risk that some rows will NOT be deleted. In this lesson, we explore iteration in reverse (from a larger number to a smaller one) to...
Curated Video
Excel VBA Programming The Complete Guide - The With-End With Construct
The With - End With construct is a shorthand syntax that allows for multiple properties to be overwritten on an object. In this lesson, we practice modifying the Name, Size, Bold and Italic properties on the Font object. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - Boolean Expressions
A Boolean is a special data type whose value can only be True or False. In this lesson, we explore the concept of truthiness and falsiness with the help of common mathematical operations and string comparisons. This clip is from the...
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 Paste and PasteSpecial Methods on the Worksheet Object
Excel offers several paste options in its user interface -- pasting just the value, just the formats, and more. In this lesson, we walk through how to emulate this feature in VBA with the help of predefined enumerations. This clip is...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Copy and Range.Cut Methods
Copy and paste --- is there a more common task in Excel? In this lesson, we use the Range.Copy and Range.Cut methods to copy, cut, and paste text across a spreadsheet. This clip is from the chapter "Range Actions" of the series "Excel...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
In this quick lesson, we dive into 3 total methods on a Range object: • ClearContents, which removes the value from a Range. • ClearFormats, which removes the formatting of a cell (font, border, background, etc) • Clear, which removes...
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
Learning Microsoft Power BI - Setting Up Scheduled Refreshes
In this video, we will learn how to set up scheduled refreshes using a data gateway. • Understand the benefits of having scheduled refreshes • Install a data gateway on your computer • Set up a scheduled refresh on the Power BI Service...
Curated Video
Learning Microsoft Power BI - Formatting and Report Design
In this video, we will learn best practices and techniques for designing effective reports. • Learn the three important techniques for designing and formatting a report • Change the color theme and add a report background • Add objects...
Curated Video
Learning Microsoft Power BI - Referencing DAX Measures
In this video, we will learn about the DAX quick measures tool in Power BI. • Understand the benefits of creating a new measure with the quick measures tool • Understand the risks involved with the same • Create a new DAX calculation...
Curated Video
Learning Microsoft Power BI - Creating Basic DAX Measures
In this video, we will learn how to write basic DAX measures. • Understand how DAX calculates based on column or table references • Create your first set of DAX measures • Learn how DAX measures can reference each other This clip is from...
Curated Video
Learning Microsoft Power BI - DAX Concepts and Fundamentals
In this video, we will learn important fundamentals of DAX, including what it is and what it’s used for. • Understand that DAX exists in multiple tools, not just Power BI • Learn how DAX formulas work compared to Excel formulas •...
Curated Video
Learning Microsoft Power BI - Adding New Columns with Power Query
We are going to learn three common ways of adding and modifying columns. • Get introduced to Add Columns, Merge Columns, and Modify Columns • Open your query editor • Apply the steps This clip is from the chapter "Common Data...
Curated Video
The Complete Excel Guide: Beginners to Advanced - If Statements
The aim of this video is to understand the If statements. This clip is from the chapter "Excel 2019 Beginners: Advanced Formula Creation" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore and...