In this quick lesson, we dive into 3 total methods on a Range object:

• ClearContents, which removes the value from a R
ange.
• ClearFormats, which removes the formatting of a cell (font, border, backgr
ound, etc)
•...

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.
r/>
This clip is from the chapter "Range References" of...

In this video, we will learn how to set up scheduled refreshes using a data gateway.

• Understand the benefits of having scheduled refr
eshes
• Install a data gateway on you
r computer
• Set up a scheduled refresh on...

In this video, we will learn best practices and techniques for designing effective reports.

• Learn the three important techniques for designing and formatting a r
eport
• Change the color theme and add a report...

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 wit
h the same
• Create a...

In this video, we will learn how to write basic DAX measures.

• Understand how DAX calculates based on column or table refer
ences
• Create your first set of DA
X measures
• Learn how DAX measures can refer
en
ce each...

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 Pow
er BI
• Learn how DAX formulas work compared to Exce
l...

We are going to learn three common ways of adding and modifying columns.

• Get introduced to Add Columns, Merge Columns, and Modify Co
lumns
• Open your qu
ery editor
•
Ap
ply the steps

This clip is from...

The aim of this video is to understand the If statements.
r/>
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,...

Understand file extensions, share, export, and publish files.
r/>
This clip is from the chapter "Excel 2019 Beginner: Saving Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach...

Let's explore the Save and Save As Commands.
r/>
This clip is from the chapter "Excel 2019 Beginner: Saving Workbooks" of the series "The Complete Excel Guide: Beginners to Advanced".This section aims to teach you how to save a...

The aim of this video is to explore the custom views option.
r/>
This clip is from the chapter "Excel 2019 Beginners: Working with Views" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll...

This video demonstrates how to read and write data from Excel to Python.
r/>
This clip is from the chapter "Part V-Reading and Writing Data from Excel to Selenium Python Framework" of the series "Selenium Python Automation...

This video explains how to integrate the Excel utility into Selenium Python Framework.
r/>
This clip is from the chapter "Part V-Reading and Writing Data from Excel to Selenium Python Framework" of the series "Selenium Python...

This video explains the logical operators.<br/<br/>>

This clip is from the chapter "Fundamentals of C++" of the series "The Complete C++ Developer Course".This section discusses the fundamentals of C++.

In this video, we will cover some advanced DAX to find total open customer complaints in Power BI.
r/>
This clip is from the chapter "DAX, R, and Gateways" of the series "Power BI Masterclass".In this section, we will be...

In this video, we will learn how to always get the latest file from a folder into Power BI.
r/>
This clip is from the chapter "Additional Tips and Tricks" of the series "Power BI Masterclass".In this section, we will be...

This video explains how to use the Cross Tab tool in Alteryx.<br/<br/>>

This clip is from the chapter "Transform Tab" of the series "Alteryx for Beginners".This section explores the Transform tab.

This is the second part of the two-part video that explains how to use the Data Cleansing tool in Alteryx.
r/>
This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the...

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.
r/>
This clip is from the chapter "Range...

In this lesson, we explore this with the context of Worksheet objects inside the Worksheets collection.
r/>
This clip is from the chapter "The Fundamentals of the Excel Object Model" of the series "Excel VBA Programming–The...

The F8 key allows us to step through the lines of a procedure step by step. In this lesson, we see how this functionality grants tremendous power when debugging a complex piece of code.
r/>
This clip is from the chapter...

In this lesson, we explore 5 additional utility functions available in the Visual Basic Editor:

• Left for pulling out characters from the beginning of a s
tring
• Right for pulling out characters from the end o
f a...

If zero-based indexing is confusing, the Option Base 1 keywords at the top of a module force an array to start at an index position of 1. In this lesson, we enable this setting and see its results in a newly declared array.
r/>
...