Some event procedures feature a Cancel Boolean argument that can cancel a specific operation by being set to True in the body of the procedure. In this lesson, we try this out with the BeforePrint event procedure.
r/>
This clip...

The Workbook_Open event is triggered when a workbook is opened -- it can be an effective way to welcome a user or run a procedure. In this lesson, we utilize this feature in a new event procedure.
r/>
This clip is from the...

In this lesson, we explore the Date, Time and Now functions for retrieving the current date and/or time as well as the DateSerial function for generating a specific date in time.
r/>
This clip is from the chapter "Functions" of...

VBA package several functions to determine if a value is of a certain data type. In this lesson, we explore the IsNumeric, IsDate, IsEmpty, and IsError functions and use them to populate a table on our spreadsheet.
r/>
This...

Continuing where we left off in the previous lesson, we wire up the buttons in a sample MsgBox to follow different branches of logic in our VBA code using the If conditional.
r/>
This clip is from the chapter "Miscellaneous...

The Step keyword can iterate with a different increment or decrement after each cycle of the loop. In this lesson, we experiment with a syntax and write a procedure that colors every second row yellow.
r/>
This clip is from the...

The conditional If statement is the heart of programming. It allows our macro to have multiple branches --- different pathways to take depending on a given condition. In this lesson, we explore the technical syntax for implementing an...

The Range.Resize changes the size of a range based on the location of a single cell. It can be used to dynamically increase the size of a cell range in the vertical direction, horizontal direction, or both.
r/>
This clip is...

In this lesson, we take a look at the default values for the String, Long, Double and Boolean data types.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete...

The aim of this video is to explore financial functions and terminology.
r/>
This clip is from the chapter "Excel 2019 Advanced: Financial Functions" of the series "The Complete Excel Guide: Beginners to Advanced".In this...

Let's open a file.<br/<br/>>

This clip is from the chapter "Excel 2019 Beginner: Navigating Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to navigate a workbook in Excel.

Learn about the relative references.
r/>
This clip is from the chapter "Excel 2019 Beginner: Creating Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to create a...

The aim of this video is to explore how to customize ribbons and tabs
r/>
This clip is from the chapter "Excel 2019 Beginners: Additional Excel Features" of the series "The Complete Excel Guide: Beginners to Advanced".In this...

The aim of this video is to explore how to consolidate data.
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...

This video explains how to test the integration of Excel with REST Assured.
r/>
This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API Automation Testing from Scratch - REST Assured...

This video presents an introduction to Library API.
r/>
This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API Automation Testing from Scratch - REST Assured Java".This section explains...

In this video, we will see in what ways slicers can allow users to interact with reports.

• Learn the various slicer types in Power BI based on data
type
• Learn about drop-down sl
icer types
• Create the slicers...

In this video, we will learn merging tables.

• Understand why we have to merge t
ables
• Understand what it means to me
rge tables
• Combine data from multiple tables into
a
single table

This clip is from...

In this video, we will cover the three most common transformations you will apply to any table.

• Open up the query editor to look at the seven queries that can be e
dited
• Apply the different steps to the DIMPro
duct...

The aim of this video is to explore get and transform.
r/>
This clip is from the chapter "Excel 2019 Advanced: Connecting to External Data" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll...

The aim of this video is to explore PivotTables.
r/>
This clip is from the chapter "Excel 2019 Beginners: PivotTables" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we’ll understand and...

In this tutorial, the teacher demonstrates how to sort a table of people's names and dates of birth chronologically in Microsoft Excel. The instructor explains the process of formatting the date cells, selecting the column to be sorted,...

This video demonstrates how to create the map of India in Power BI.
<
br/>
This clip is from the chapter "Maps in Power BI" of the series "Business Intelligence with Microsoft Power BI - with Material".This section focuses on the...

In this video, we will learn how to extract patterns from columns.
r/>
This clip is from the chapter "Additional Tips and Tricks" of the series "Power BI Masterclass".In this section, we will be covering some additional tips...