Video
How to make a Pareto chart
In this video, we'll look at how to create a Pareto chart. A Pareto chart plots the distribution of data in columns by frequency, sorted in descending order. ...Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Formula
Multiple matches into separate columns
In this example, the goal is to get all names in a given group into the same row, in separate columns, as seen in the worksheet. This is sometimes referred to as a "pivot" operation. The idea is to restructure the data into multiple columns using common values, which in this case are the...Read more
Function
IFERROR Function
The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.Read more
Article
Excel custom number formats
Number formats are a key feature in Excel. Their key benefit is that they change how numeric values look without actually changing any data. Excel ships with a huge number of different number formats, and you can easily define your own. This guide explains how custom number formats work in...Read more
Formula
Multiple matches into separate rows
In this example, the goal is to get all names in a given group into separate rows grouped by column, as seen in the worksheet above. This is sometimes referred to as a "pivot" operation. The idea is to restructure the data into multiple columns where each column holds the names that belong to a...Read more
Video
Shortcuts to move the active cell
In this lesson, we cover shortcuts you can use to move the active cell in a selection.Read more
Video
How to fill in missing data with a simple formula
In this video we'll look at a way to quickly add missing data to a worksheet. It's a simple technique using a very basic formula and a cool example of relative cell references...Read more
Term
Power Query
Power Query is a tool in Excel that allows you to import data from a wide variety of sources, and manipulate that data to meet your needs. For example, you can:
- Import a CSV file on your computer
- Import a table from a web page
- Import data from an online ...Read more
Function
SMALL Function
The Excel SMALL function returns a numeric value based on its position in a list when sorted by value in ascending order. In other words, SMALL can return the "nth smallest" value (1st smallest value, 2nd smallest value, 3rd smallest value, etc.) from a set of numeric data.Read more
Function
FILTER Function
The Excel FILTER function is used to extract matching values from data based on one or more conditions. The output from FILTER is dynamic. If source data or criteria change, FILTER will return a new set of results. This makes FILTER a flexible way to isolate and inspect data without altering the...Read more
Formula
Count unique text values in a range
This formula is more complicated than a similar formula that uses FREQUENCY to count unique numeric values because FREQUENCY doesn't normally work with non-numeric values. As a result, a large part of the formula simply transforms...Read more
Article
How to lookup first and last match
If VLOOKUP finds more than one match, will you get the first match or the last match? It's a trick question. It depends :) This article explains this confusing topic in detail, with lots of examples.Read more
Course
Dynamic Array Formulas
Dynamic Array Formulas are one of the biggest changes to Excel ever. They completely change the way you solve hard problems in Excel, with excellent new functions and an upgraded formula engine that can return multiple results at the same time. With Dynamic Arrays, you can extract...Read more