Video
How to extract a first name with a helper column
In this video we look at how to combine the FIND function with the LEFT function to extract the first name from a full name using a formula.Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
How to count characters with the LEN function
In this video we look at how to use the LEN function to calculate the number of characters in a text string. LEN is a surprisingly useful function that appears in many formulas.Read more
Video
How to concatenate with line breaks
In this video we demo how to join different values together in one cell with line breaks. This also includes a clever way to add spaces and commas without using double quotes.Read more
Video
How to clean text with CLEAN and TRIM
This video shows you how to use two text functions, CLEAN and TRIM, to strip extra spaces and remove line breaks from text.Read more
Video
How to change case with UPPER LOWER and PROPER
In this video we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.Read more
Video
How to use concatenation to clarify assumptions
In this video we show how to use the TEXT function to call out assumptions in a model. You can use the same approach to highlight assumptions in any spreadsheet.Read more
Video
How to find and highlight formulas
In this video, we show you three ways to find formulas in a worksheet, including a tricky way to use conditional formatting and a named formula to highlight formulas.
...Read more
Video
How to pick names out of a hat with Excel
In this video we look at how to simulate a random drawing to pick winners in a contest with Excel using the RAND and RANK functions together.Read more
Video
How to rank values with the RANK function
In this video we'll look at how to rank values in ascending or descending order using the RANK function. When values change, the rank will automatically update...Read more
Video
How to calculate and highlight expiration dates
In this lesson we look at how to generate an expiration date in the future, how to calculate "days remaining," and how to highlight dates that are "expired" or "expiring soon" with conditional formatting...Read more
Video
Pivot Table Example - IMDB Movie data
In this video, we look at how to use a pivot table to analyze movie data by rating, runtime, genre, and more.Read more
Video
Pivot Table Example - Instrument readings
In this video, we look at how to use a pivot table to analyze instrument measurements. This data consists of temperature readings taken in a green house over a period of days.Read more
Video
Pivot Table Example - Voting results
In this video, we look at how to use a pivot table to analyze voting data, including winning vote by percentage, and breakdown by age and gender.Read more
Video
Conditional formatting based on a different cell
In this video, we'll look at how to apply conditional formatting to one cell based on values in another, using a formula...Read more
Video
How to test a conditional formatting formula
In this video, we'll look at an easy way to test a conditional formatting formula before you create the rule...Read more
Video
How to highlight rows using multiple criteria
In this video, we'll look at how to use conditional formatting to highlight entire rows using multiple criteria...Read more
Video
How to apply conditional formatting with a formula
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to create more flexible and powerful conditional formats...Read more
Video
Conditional formatting with one variable input
In this video, we look at how to make conditional formatting variable, so that you can change how formatting is applied without editing a rule. This elegant technique helps you build killer spreadsheets that are fun to use.
...Read more
Video
Conditional formatting with two variable inputs
In this video, we'll look at how to extend a conditional formatting formula so that so that it checks more than just one condition...Read more
Video
How to create zebra stripes with conditional formatting
In this video, we'll look at how to use conditional formatting to shade every other row in a table. This is sometimes called "zebra striping"...Read more
Video
Why pivot tables?
In this video, we compare formulas and pivot tables side-by-side to build the same reports to demonstrate how powerful and easy to use pivot tables are.Read more
Video
10 pivot table problems and easy fixes
Pivot tables are very easy to create, but they still present challenges. In this video, we look at how to identify and fix 10 common pivot table problems.Read more
Video
How to compare two lists and highlight differences
In this video, we'll look at how to compare two lists using conditional formatting. This is a great way to visually highlight missing items in a list...Read more
Formula
Video
How to get nth values with SMALL and LARGE
In this video we'll look at how to calculate the "nth" smallest or largest values in a range using the SMALL and LARGE functions. For example, the 1st, 2nd, and 3rd smallest or largest values...Read more
Video
How to build all-in-one formulas
In this video we build a formula that counts words in a cell with the LEN and SUBSTITUTE functions.Read more
Formula
Sum columns based on adjacent criteria
In this example, the goal is to sum the values in columns C, E, G, and I conditionally using the text values in columns B, D, F, and H for criteria. This problem can be solved with the SUMPRODUCT function, which is designed to multiply ...Read more
Video
Excel Ribbon shortcuts
In this video, we'll look at shortcuts that let you work with the Ribbon using only your keyboard...Read more
Video
Shortcuts for Excel dialog boxes (Win)
In this video, we'll look at some tips and shortcuts you can use to control dialog boxes using only the keyboard...Read more
Video
Shortcuts for Excel dialog boxes (Mac)
How to use your keyboard to navigate dialog boxes in Excel for the MacRead more