Enter and move up

In this video, I’ll give a brief introduction to structured references. A structured reference is a term for using a table name in a formula instead of a normal cell reference. Structured references are optional, and can be used with formulas both inside or outside an Excel table. Let’s take a look …

In this video, we’ll look at how to generate a sequence of times with the SEQUENCE function. The SEQUENCE function can be used to generate numeric sequences of all kinds. Since Excel times are just numbers, SEQUENCE works well for generating times. In the first worksheet, let’s generate 9 times, one …

In this video I’m going to show you how you can use multiple Excel functions to split, manipulate, and rejoin values inside a single formula. Here we have some sample data and, in column B, we have text values with a number at the end. What we want to do is increment these numbers using the value in …

In this video, we’ll look at shortcuts for entering data. Before we start, I want to show you an option related to cursor movement in Excel. On Windows, press Alt + F, then T for Options, and A for Advanced. On a Mac, type command + comma to go to Preference, then click Edit. When you press Return, …