In this Microsoft Excel tutorial, we learn how to use the sum function to add numbers together. We also explore how to use cell numbers or ranges as arguments in the sum function, and how Excel ignores text when adding numbers....

This video presents the sixth case study on joining tables with multiple criteria.<br/<br/>>

This clip is from the chapter "Case Studies" of the series "Alteryx for Beginners".null

This video demonstrates how to use the Join Multiple tool in Alteryx.<br/<br/>>

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

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

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

Sorting is one of the most popular operations in Excel. In this lesson, we utilize the Range.Sort method to sort both one and two columns at a time (in ascending or descending order) and discuss how we can ignore the values in the...

Most deletion operations will involve removing entire rows or columns at a time. In this lesson, we discuss how to make that happen in VBA as well as what happens when we delete a single cell instead.
r/>
This clip is from the...

R1C1 notation is a different way of thinking about cells in Excel. Instead of using a letter for the column and a row for the number, R1C1 relies on numbers for both. In this lesson, we enable R1C1 notation in our Excel interface and...

The Worksheet.Visible property is used to hide and unhide a worksheet. It accepts either a Boolean argument (True or False) or an XlSheetVisibility enumeration. One cool VBA feature is the ability to use the xlSheetVeryHidden option to...

In this lesson, we use the TypeName method from the VBA object to track the data type of a Variant variable as we assign different values to it.
r/>
This clip is from the chapter "Variables and Data Types" of the series "Excel...

In this lesson, we explore a myriad of ways to execute a public procedure from both the code editor and the Excel interface, including:

• The green execute button in th
e VBE
• The F5 keyboard shortcut
in the VBE
...

The MsgBox is a simple dialog box that prompts a user action or confirmation. In this lesson, we'll explore the syntax for the method as well as begin our discussion of inputs, parameters, and arguments. A parameter is the name given...

An event is a regular Excel action --- opening a worksheet, entering a cell value -- that can automatically trigger a VBA procedure. In this lesson, we compare event procedures to regular procedures and setup our VBE environment for...

Programmers of all experience levels make mistakes --- it's part of the job. Error handling is the ability to avoid errors in our code by catching them before they happen. In this lesson, we discuss some common errors we can run into...

The Application.InputBox method offers some additional flexibility when collecting user input. In this lesson, we provide a custom Type argument to collect a Range input from the user. We then color the range with an assorted...

The LowerBound To UpperBound syntax can be used when declaring an array to modify the starting and ending index position. In this lesson, we declare an array of 6 whole numbers.
r/>
This clip is from the chapter "Arrays" of the...

The aim of this video is to explore how to create an outline.
r/>
This clip is from the chapter "Excel 2019 Beginners: Outlining and Subtotaling" of the series "The Complete Excel Guide: Beginners to Advanced".In this section,...

The aim of this video is to explore how to format as table.
r/>
This clip is from the chapter "Excel 2019 Beginners: Formatting Worksheets" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, you'll...

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

The aim of this video is to explore how to convert text to columns.
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...

In this video, the speaker addresses a common issue where dates in Excel are not sorting correctly by year. By demonstrating a step-by-step solution, viewers learn how to ensure Excel recognizes the dates as dates, thus enabling proper...

This video tutorial demonstrates how to calculate someone's age from their date of birth in Microsoft Excel using the Date DIF formula and the NOW function. By inputting the individual's date of birth and the current date, the formula...

This video presents the fourth case study on finding working days from the calendar.<br/<br/>>

This clip is from the chapter "Case Studies" of the series "Alteryx for Beginners".null

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

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

This video explains how to convert text to columns.<br/<br/>>

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