Video
How to test conditional formatting with dummy formula
In this video, I'll show you how to quickly test your conditional formatting rules with dummy formulas...Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
How to combine functions in a formula
In this video you'll learn how to use multiple Excel functions to split, manipulate, and rejoin values inside a single formula.
...Read more
Video
How to build a simple summary table
Pivot Tables are fantastic tools for summarizing data, but you can also use formulas to build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.Read more
Video
How to use VLOOKUP to merge tables
This video shows how to use VLOOKUP to merge data in two tables based on a common ID. You can even use this technique to reorder the columns you retrieve.Read more
Formula
Multiple matches in comma separated list
The core of this formula is the IF function, which "filters" the names in the table by color like this:
IF(group=E5,name,""))
The logical test checks each cell in the named range "group" for the color value in E5 (red in this case). The...Read more
Video
Intro to Boolean Logic
In this video, I'm going to show you the basics of Boolean logic. Boolean logic is a great tool for simplifying formulas, especially those with many IF statements...Read more
Video
Complex formula example 401k Match
In this video we'll look at how to build a formula that calculates a 401k match using several nested IF statements...Read more
Video
Simplified formula example 401k Match
In this video we'll look at how to simplify some formulas we created in a previous video by replacing IF statements with the MIN function and a bit of Boolean logic...Read more
Formula
Highlight 3 smallest values with criteria
Inside the AND function there are two logical criteria. The first is straightforward, and ensures that only cells that match the color in E5 are highlighted:
$B3=$E$5
The second test is more complex:...Read more
Video
How to highlight exact match lookups
In this video, we'll look at how to use conditional formatting to highlight rows and columns associated with exact match lookups...Read more
Video
Two-way lookup with INDEX and MATCH approximate
In this video we'll look at how to build a two-way lookup with INDEX and MATCH using an approximate match...Read more
Video
How to highlight approximate match lookups
In this video, we'll look at how to highlight the results of approximate match lookups with conditional formatting...Read more
Video
Shade groups of rows with conditional formatting
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows - groups of 3 rows, groups of 4 rows, and so on. ...Read more
Formula
Easy bundle pricing with SUMPRODUCT
The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an elegant and versatile function, which this example illustrates nicely.
In this example, SUMPRODUCT is...Read more
Video
How to calculate due dates with WORKDAY
In this video we'll look at how to calculate due dates with the WORKDAY and WORKDAY.INTL functions...Read more
Video
How to copy a pivot table without the data
In this video, we'll look at how to copy and paste a pivot table without bringing along the source data...Read more
Video
How to generate random values
In this video we'll look at a few ways to generate random values with the RANDBETWEEN function, including random dates, random prices, and random workdays...Read more
Video
How to use the CHOOSE function
In this video we'll look at how you can use the CHOOSE function. We also compare a formula based on CHOOSE vs. a formula based on VLOOKUP...Read more
Video
How to build a simple dynamic chart
In this video we'll look at how to build a simple dynamic chart in Excel. A dynamic chart automatically responds to changes in data...Read more
Video
An introduction to chart axes
In this video, we'll take a look at the different axes (horizontal, vertical, etc.) you'll find in Excel charts...Read more
Video
How Excel plots dates on a chart axis
In this video, we'll look at an example of how Excel plots dates on a horizontal axis, and some ways you can control the axis when working with dates...Read more
Video
How to add a secondary axis to a chart
In this video, we'll look at how to add a secondary axis to chart. A secondary axis allows you to data with a different scale in the same chart...Read more
Video
How to create a multi level axis
In this video, we'll look at how to build a chart with multi-level axis labels. A multi-level axis allows you to group related information together...Read more
Video
How to reverse a chart axis
In this video, we'll look at how to reverse the order of a chart axis...Read more
Video
How to customize a category axis
In this video, we'll look at options for customizing a category axis in an Excel chart...Read more
Video
How to customize a value axis
In this video, we'll look at options for customizing a value axis in an Excel chart...Read more
Video
How to customize axis labels
In this video, we'll look at some examples of customizing the labels that appear on a chart axis...Read more
Video
How to apply font formatting to a chart
In this video, we'll look at some ways you can apply font formatting to an Excel chart...Read more
Video
How to format chart and plot area
In this video, we'll look at how to work with the chart area and plot area in an Excel chart...Read more
Video
How to copy chart formatting
In this video, we'll look at how to transfer formatting from one chart to another using copy and paste...Read more