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

In this tutorial, Justin demonstrates how to create a live currency converter in Microsoft Excel by importing real-time currency conversion data from a website. By following his step-by-step guide, you can set up your own converter to...

In this video, learn how to apply conditional formatting to tables, and create a waterfall chart.

• Learn the three ways to apply conditional formatting to t
ables
• Understand how conditional formatting works when using...

Let's look and understand web app.<br/<br/>>

This clip is from the chapter "Excel 2019 Advanced: Excel Web App" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore the Excel web app.

A quick overview of the course.
r/>
This clip is from the chapter "Excel 2019: Introduction" of the series "The Complete Excel Guide: Beginners to Advanced".The upcoming 21 sections for Microsoft Excel 2019 are perfect for...

In this video, we will cover some advanced DAX to find price changes in Power BI - setting up our data model.
r/>
This clip is from the chapter "DAX, R, and Gateways" of the series "Power BI Masterclass".In this section, we...

This video explains what a database table is.<br/<br/>>

This clip is from the chapter "Manipulating Tables and Data" of the series "Microsoft SQL Server Development for Everyone".This section explains how to manipulate tables and data.

This video explains how to use the Report Text 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 use the Table 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 use the Count Records 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 video explains how to use the Generate Rows tool in Alteryx.<br/<br/>>

This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.

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

This clip is from the chapter "Preparation Tab" of the series "Alteryx for Beginners".This section focuses on the Preparation tab.

Let's continue with web app.<br/<br/>>

This clip is from the chapter "Excel 2019 Advanced: Excel Web App" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore the Excel web app.

The aim of this video is to explore how to connect to access databases.
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...

The aim of this video is to explore goal seek.<br/<br/>>

This clip is from the chapter "Excel 2019 Advanced: Data Analysis" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore data analysis.

The aim of this video is to explore how to link chart titles.
r/>
This clip is from the chapter "Excel 2019 Beginners: Charts" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore what...

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

VBA has 3 options for whole numbers: Byte, Integer, and Long. Each data type supports a different range of numbers; Byte only supports any number from 0 to 256 while Long can store numbers in the billions. In this lesson, we practice...

The Option Explicit setting at the top of a code module mandates that all variables be declared with a valid data type before being assigned a value. In this lesson, we compare a code sample with and without this setting enabled to see...

The VBA.TypeName method accepts an VBA object and returns its type as a string. In this lesson, we practice invoking the method in the Immediate Window with a variety of inputs including strings, numbers, and various Excel...

In this lesson, we'll explore the default properties on the Range and Application objects and discuss the benefits and disadvantages of explicitly writing them out.
r/>
This clip is from the chapter "The Fundamentals of the...

This is the first in a series of videos on how to find and use data in global health. In this video Dr Greg Martin shows you how to download data on HIV, TB and ART and how to use the vLookup function in Excel to extract the data that...

In this video tutorial, learn how to create a painting by numbers tool in Microsoft Excel using conditional formatting. By assigning colors to specific numbers and applying conditional formatting rules, you can transform a grid of...