Video
How to fill in missing data part 2
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions...Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
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
Video
Don't hard code values that may change
In this video we'll take a look at a few reasons why you shouldn't hard code values into your formulas that may change...Read more
Video
How to save a formula that's not finished
Excel won't let you save a formula that isn't working. In this video, we'll look at a simple way to save an unfinished formula so you don't lose your work...Read more
Video
How to make an exact copy of a formula
This video shows you how to stop Excel from changing cell references when you want an exact copy of a formula in a different cell.Read more
Video
How to convert formulas to values
This video shows how you can replace formulas with the results they return-- a useful way to stop Excel from calculating new results.Read more
Video
How to use the status bar for quick calculations
In this video we'll take a quick look at the information provided by the status bar. The status bar provides real-time data about currently selected cells and can give you a lot of useful information.
...Read more
Video
How to create a complex formula step by step
Some Excel formulas are complex, but all complex formulas are built from simple steps. In this video we build a more complex formula step-by-step.Read more
Video
Create a dynamic reference to a named range
In this video we'll look at how to create a dynamic reference to a named range with the INDIRECT function. This is one way to switch ranges on the fly...Read more
Video
How to apply a named range to an existing formula
Sometimes you might create named ranges after you've already built formulas. In this video we'll look at how to apply named ranges to an existing formula...Read more
Video
How to create a named constant
In this video we'll look at how to create a named constant. This is a useful way to create a name that doesn't appear in a cell on the worksheet...Read more
Video
How to create a named range
Named ranges make formulas easier to read and understand, and reduce errors. In this video we'll show you how to create a named range...Read more
Video
Create a dynamic reference to a worksheet
Sometimes you want to reference a worksheet dynamically in a formula so that it can be changed on the fly. In this video, we'll look at how to create a dynamic reference to a worksheet in a formula...Read more
Video
How to create a reference to another worksheet
In this video we'll look at how to create formulas that reference cells on different worksheets, or even in different workbooks...Read more
Video
How to create 3D references
In this video we'll look at how to create 3D references; an elegant way to analyze multiple worksheets with simple formulas...Read more
Video
How to create a mixed reference
In this video we look at how to create a mixed reference that is part relative and part absolute; useful when you want only part of a cell reference to change.Read more
Video
How to use a mixed reference to create a running total
In this video we'll look at how to use a mixed reference (part relative, part absolute) to create a running total...Read more
Video
How to do in-place changes with paste special
One of the cool things you can do with Paste Special is make "in place" changes to numbers. This is a handy way to quickly change things like dates, prices, and times without using formulas...Read more
Video
How to enter functions
In this video we'll look at several ways to enter Excel functions...Read more
Video
How to select arguments with the formula tip window
In this video we'll look at the best way to select function arguments in a formula: the function screen tip window...Read more
Video
How to use function arguments
Most Excel functions require arguments. In this video, we explain how function arguments work and how to use them.Read more
Video
How to use operators in formulas
This video reviews the key operators you can use in an Excel formula to perform math or build a logical expression. Read more
Video
What is text in Excel
Excel treats numbers and text differently. In this video we answer the question: "What is text in Excel?"...Read more
Video
How to use the REPT function to repeat things
In this video we look at how to use the REPT function, a special function for repeating text values with a numeric counter.Read more
Video
How to use CHAR and CODE functions
Each character you see displayed in Excel has a number. In this video we look at two functions that work with these numbers directly: CODE and CHAR.Read more
Video
How to join values with the ampersand
In this video we look at how to use the operator for concatenation, the ampersand character, to join values together in a formula.Read more
Video
How to join text with numbers
In this video we look at how to use the TEXT function. The TEXT function is useful when you need to CONCATENATE a number with text using a specific number format.Read more
Video
How to join cell values with CONCATENATE
In this video we'll look at how to use the CONCATENATE function, an alternative to using the ampersand (&) character to join values in a formula.
...Read more
Video
How to find text with a formula
In this video we look at how to use the FIND and SEARCH function to find the position of a substring in another string.Read more
Video
How to extract text with LEFT and RIGHT
In this video we look at how to use the RIGHT and LEFT functions to extract one or more characters from the beginning or end of a string.Read more