Enter array formula

In this video we’ll look at a few ways to generate random values with the RANDBETWEEN function. The RANDBETWEEN function is a simple function you can use to generate random numbers. For example, I can enter RANDBETWEEN with a bottom value of 1 and a top value of 100. When I press Enter, I get a …

In this video, we’ll look at shortcuts for working with Excel functions. Excel contains over 400 built-in functions, and a number of related shortcuts. To start off, there’s a shortcut for the Autosum feature, which automatically enters the SUM function. Select a range that includes a blank cell, …

In this video, we’ll look at shortcuts for working with formulas. Even basic formulas require absolute and relative references, so one of the most useful formula shortcuts is the toggle for references. For example, to complete this multiplication table, we need to multiply the left column by the top …

In this video, we’ll take a look at the error codes that Excel generates when there’s something wrong with a formula. There are 8 error codes that you’re likely to run into at some point as you work with Excel’s formulas. First, we have the divide by zero error. You’ll see this when a formula tries …

In this video, I’ll explain the basic idea of dynamic array formulas. Dynamic Array formulas are the biggest change to the Excel formula engine in years. Maybe the biggest change ever. This is because Dynamic Arrays make it easy to work with many values at the same time. For many users, this will be …