Do you feel behind because you never learned the foundations of Microsoft Excel? In this video, Mark will take you through everything you need to know to get started in about 20 minutes.

This video is a comprehensive guide to using Excel 2016, a powerful spreadsheet program that allows users to store, organize, and analyze information. The video covers essential features such as navigating the interface, utilizing the...

This video provides a comprehensive overview of Excel 2016, a powerful spreadsheet program used for storing, organizing, and analyzing information. The instructor guides viewers through the various features and tools of Excel, starting...

The Application.ScreenUpdating property can be set to False to disable updates to the Excel interface. One way to optimize the speed of a macro is to turn the property off at the beginning of execution and reenable it at the end. In...

In this Microsoft Excel tutorial, we learn how to extract values using the SMALL and LARGE functions, as well as how to rank values using the RANK function and calculate percentile ranks using the PERCENTRANK function. The tutorial...

In this lesson, we use the Range.Count and Range.CountLarge properties to find out the number of cells in a given range. The returned value counts all cells, not just those with values.
r/>
This clip is from the chapter "Range...

This video introduces the student to a variety of basic functions available in Excel, including SUM, AVERAGE, MIN, and MAX, and how to apply them to a range of cells, thereby enabling the student to perform basic statistical analyses on...

Many people seem to struggle with formatting percentages in Microsoft Excel, with 100% seemingly equivalent to 1000% or more! In this tutorial I'll explain what's really going on, how to use the percentage tool correctly, demonstrate why...

In this video, the teacher provides an overview of the VBA editor tool in Microsoft Excel. They explain the different tools and commands available, such as modules, project windows, and macros. The teacher also demonstrates how to...

An introduction to Excel.
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 those new...

Let's explore the Excel window.
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...

Let's see what's new in Excel 2019.
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...

Let's explore the mouse features available in Excel.
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...

Let's see what is the backstage view.
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...

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 lesson, we explore the Rows and Columns properties, which are available on both the top-level Application object and a specific Range. The two can be used to target complete rows or columns, within the spreadsheet or within a...

In this lesson, we wire up the final Command Button on our UserForm to capture the user's input and populate it on the spreadsheet.
r/>
This clip is from the chapter "User Forms" of the series "Excel VBA Programming–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...

Daily reports will often have a fluctuating number of rows. In this lesson, we introduce a convenient strategy to identify the last row of data in a sheet --- starting at the bottom of the spreadsheet and navigating upwards.
r/> ...

This video serves as a comprehensive introduction to Microsoft Excel 2016, a powerful spreadsheet program used for storing, organizing, and analyzing information. The tutorial covers various aspects of Excel, starting with the Start...

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

Basic demonstration of how to use spreadsheets in an introductory physics class.

The Worksheet_SelectionChange event is triggered when the user navigates to a different cell with a spreadsheet. In this lesson, we react our first Excel event and also explore the ByVal keyword in the automatically generated...

Copy and paste --- is there a more common task in Excel? In this lesson, we use the Range.Copy and Range.Cut methods to copy, cut, and paste text across a spreadsheet.
r/>
This clip is from the chapter "Range Actions" of the...