En este video te enseñamos cómo crear presentaciones apoyándote en ChatGpt. Aprende a crear presentaciones en PowerPoint con ChatGPT.

Every operating system contains interpreters that can read higher-level programming languages. This video covers three popular interpreters: Visual Basic, Python, and JavaScript.
<
br/>
This clip is from the chapter "Working with...

This video explains the Excel VBA developer toolbar and the various panels associated with it.
<
br/>
This clip is from the chapter "Introduction" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This...

In this video, we will explore the VBA Editor.

VBA adds programming functionality to Microsoft Excel. A Macro is a VBA program that can be recorded to auto-generate code in VBA. VBA is a simplified form of Visual Basic and lacks full-featured programming support. VBA extends the...

The Macro Recorder is a powerful tool that converts your interface actions (i.e. clicks, navigations, aesthetic changes) into valid VBA code. In this lesson, we discuss the merits (and drawbacks) of the Macro Recorder and explore some...

In this video, the speaker, a Microsoft certified trainer, introduces the Microsoft Excel VBA editor tool. They explain the basics of VBA and macros, their functions and applications in Microsoft Excel. They also discuss the Visual Basic...

VBA is an object-oriented programming language that views an application as a series of interactions between data entities called objects. Objects have properties, which describe its characteristics, and methods, which are actions that...

Malware is malicious software that comes in many different shapes and sizes. This episode tackles examples of malicious code and how it related to Visual Basic for Applications (VBA).
r/>
This clip is from the chapter "Tools of...

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

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

The author introduces himself and his capabilities to handle C programming.
r/>
This clip is from the chapter "Introduction" of the series "Learn and Master C Programming For Absolute Beginners!".In this introductory section,...

In this lesson, we use the Visual Basic Editor's Immediate Window to explore the hierarchy of the Excel Object Model. We begin at the top with the Application object, which houses all of the Workbooks currently open in Excel, and...

The Developer Tab is a secret Tab on the Ribbon that includes several options for working with VBA. Users can access the Visual Basic Editor, enable the Macro Recorder, and display a list of public macros. In this lesson, we expose the...

In this video, Justin demonstrates how to generate a random slide within a PowerPoint presentation. He also shows how to limit the random slide selection to a specific group of slides and how to ensure that each slide is visited only...

In this lesson, we dive into the mathematical operators for

• addition
( + )
• subtrac
tion ( - )
• multi
plication ( * )/> • division ( / )
> • exponentiatio
n
( ^ )
• modulo ( Mod )

This...

The VBA community follows a popular convention for naming form controls. It begins with a 3-letter prefix for the type of form control, followed by the name of the entity or data point that the form control is related to. In this...

The Range.FillDown method populates a formula or value downwards based on an existing's cell value; this is the VBA emulation of the feature available in the Excel interface. In this lesson, we employ the method to concatenate text...

Many of Excel's popular worksheet functions are available for use in the Visual Basic Editor. In this lesson, we implement the popular VLOOKUP function using code.
r/>
This clip is from the chapter "Functions" of the series...

Macros have been used to package malicious code in the past. In this lesson, we explore the security options built into Excel that prevent macro code from executing automatically. We also add a directory to a Trusted Locations list of...

There are dozens of file types available in Excel. In order to work with macros, we need to save our files in a special format called .xlsm. In this lesson, we introduce an option for defaulting to a .xlsm format upon saving.
r/> ...