Looking for more? Try chatting with the Exceljet Chatbot.

Function

T Function

The Excel T function returns text when given a text value and an empty string ("") for numbers, dates, and the logical values TRUE and FALSE. You can use the T function to remove values that are not text.Read more

Video

23 Excel formula tips

In this video, we take a speed run through 23 tips you can use to save time with Excel formulas today. We try hard to make our videos quick and to the point, so this is a rapid-fire list, with more than 20 tips in about 10 minutes. We trust that you can rewind the video as needed :)Read more
Video

30 Excel Shortcuts in 12 minutes

Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of...Read more
Video

How to randomly assign people to teams

In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper columns, and nesting. We verify results with the COUNTIF function.Read more
Article

Excel Pivot Tables

Pivot tables are the fastest and easiest way to quickly analyze data in Excel. This article is an introduction to Pivot Tables and their benefits, and a step-by-step guide with sample data.Read more

Pivot Table

Pivot table show duplicates

Pivot tables make it easy to count values in a data set. One way this feature can be used is to display duplicates. In the example shown, a pivot table is used to show duplicate cities in an Excel Table that contains more than 250 rows.

Fields

The data contains 263...Read more

Video

Basic SORT function example

In this video, we’ll look at a basic example of sorting with the SORT function. Sorting with formulas is a traditionally hard problem in Excel new dynamic array formulas make much easier. ...Read more
Video

Basic SORTBY function example

In this video, we’ll look at a basic example of sorting with the SORTBY function. With the SORTBY function, you specify the sort order in pairs of inputs. Each pair has an argument for a range and an argument for the sort order.Read more
Video

Basic XLOOKUP example

In this video, we’ll set up the XLOOKUP function with a basic example. Matching on City name, we'll retrieve Country and Population...Read more
Video

Dynamic arrays are native

In this video we'll look at how dynamic array behavior is native and deeply integrated in Excel. Even older functions can use this new feature...Read more
Video

What is an array?

The term "array" comes from programming, but you'll hear it often in the context of more advanced Excel formulas. In this video, we'll answer the question "what is an array?" ...Read more
Video

How to convert Booleans to numbers

When working with more advanced formulas, especially array formulas, you need to know how to convert TRUE and FALSE values in Excel to their numeric equivalents, 1 and 0. In this video, we'll look at some ways you can convert TRUE and FALSE values in Excel to 1s and 0s...Read more
Video

Introduction to Booleans

In this video, we’ll introduce the idea of boolean values in Excel. Boolean values are a key building block in dynamic array formulas.Read more
Video

The UNIQUE function

In this video, we'll introduce the UNIQUE function. The UNIQUE function lets you extract unique values in a variety of ways...Read more
Video

The SEQUENCE function

In this video, we'll introduce the SEQUENCE function. The SEQUENCE function lets you generate numeric sequences, which can be used for dates, times, and more...Read more

Pages