Accept function with autocomplete

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 take a look at the TEXTAFTER function. TEXTAFTER is designed to extract text that occurs after a specific “delimiter”, which can be one or more characters. Let’s look at an example. In this worksheet, we have a list of email addresses. The goal is to extract the domain portion …

In this video, we’ll look at shortcuts for creating and applying named ranges. Here we have a set of sales data that spans 2 years, broken down by month. Using named ranges, I’m going to add several formulas to fill in the summary information, based on a name in I8. Generally, the fastest way to …

In this video, we’ll look at several ways to enter functions. Let’s take a look. If you know the function name, the easiest way to enter a function is just to enter an equal sign and start typing. For example, if I want to get the average of these test scores with the AVERAGE function, I can start …

In this video, we’ll take a look at the TEXTBEFORE function. Like the name suggests, TEXTBEFORE is designed to extract text that occurs before a specific marker, called a “delimiter”. A delimiter can be one or more characters. Let’s look at an example. In this worksheet, we have a list of email …