Looking for more? Try chatting with the Exceljet Chatbot.

Function

ISBLANK Function

The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.Read more

Function

WORKDAY Function

The Excel WORKDAY function returns a date in the future or past that is a given number of working days from a specified start date, excluding weekends and (optionally) holidays. You can use the WORKDAY function to calculate things like start dates, delivery dates, and completion dates...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

Function

ROW Function

The Excel ROW function returns the row number for a reference. For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet. When no reference is provided, ROW returns the row number of the cell which contains the formula.Read more

Course

Excel 101

Understand Excel today! Quickly learn to use Excel to create and edit spreadsheets. This accelerated video training guides you step-by-step.Read more
Article

How to use formula criteria (50 examples)

Criteria are a key concept in Excel, but building useful criteria for text, numbers, dates, times, etc. is hard because it requires a good understanding of how Excel handles data. This guide will help you build formulas that work the first time with over 50 examples.Read more

Formula

Data validation require specific multiple

In this example, the goal is to create a data validation rule that will only accept numbers that are a specific multiple of another number. In the worksheet shown, the multiple is 100. Data validation rules are triggered when a user adds or changes a cell value. When a custom formula returns...Read more

Keyboard shortcut

Select table column

This shortcut selects one or more table columns in a table, when the cursor is in an Excel table. Behavior changes as the shortcut is used more than once. First time: column data. Second time: column data + column header. Third time: entire worksheet column.Read more

Keyboard shortcut

Format (almost) anything

This shortcut is a gateway to many formatting options, even when the ribbon is collapsed. When regular cells are selected, it displays the Format Cells dialog box with the "last tab used" selected. This is a very fast way to access font controls, borders and fills, alignment options, and...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

Function

WORKDAY.INTL Function

The Excel WORKDAY.INTL function returns a date in the future or past that is a given number of working days from a specified start date, excluding weekends and (optionally) holidays. Unlike the simpler WORKDAY function, WORKDAY.INTL can be...Read more

Article

Excel formulas and functions

Most people never receive proper Excel training and spend years frustrated by the simplest tasks, especially tasks that involve formulas. To use Excel with confidence, you must have a good understanding of formulas and functions. This article introduces the basic concepts you need to know...Read more

Formula

Subtotal by color

In this example, the goal is to subtotal (count and sum) values based on cell color. This is a tricky problem, because there is no Excel function that will let you count cells by color directly. There are several different approaches, as explained below.

Standard formula logic

...Read more

Function

LEN Function

The Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included.Read more

Formula

Pad text to equal length

This formula concatenates the original value in column B to a string of asterisks (*) assembled with the REPT function so that the final result is always 12 characters:

REPT("*",12-LEN(B5))

Inside the REPT function, the text to repeat is...Read more

Function

MOD Function

The Excel MOD function returns the remainder of two numbers after division.  For example, MOD(10,3) = 1. The result of MOD carries the same sign as the divisor.Read more

Function

COLUMN Function

The Excel COLUMN function returns the column number for a reference. For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the formula.Read more

Puzzle

Highlight dates in the same month and year

Excel has a built-in conditional formatting rule that will highlight dates that occur "this month". But what if you want to highlight dates in the same month and year for any date?Read more

Function

MEDIAN Function

The Excel MEDIAN function returns the median (middle number) in the supplied set of data. For example, =MEDIAN(1,2,3,4,5) returns 3.Read more

Function

LOOKUP Function

The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range. LOOKUP's default behavior makes it useful for solving certain problems in Excel.Read more

Video

Welcome

The number one goal of this course is to help you learn excel fast, so you can get back to your real work. We believe people learn best by doing. Our videos are short and focused, and include a practice worksheet, so you can immediately put your new skills to work. If you have 5 minutes, you can...Read more
Formula

Due date by category

In this example, the goal is to create a due date based on category, where each category has a different number of days allocated to complete a given task, issue, project, etc. The amount of time available to resolve each category is shown in column H, and categories is the...Read more

Keyboard shortcut

Edit the active cell

This shortcut enters cell edit mode with the cursor at the end of the last line of text in the cell. If you want the cursor to move to the formula bar, see below.

Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through...Read more

Formula

Highlight numbers that include symbols

The formula first uses the ISNUMBER function to test if the value is a number, and applies a simple logical if so:

=IF(ISNUMBER(B4)

For any number less than the value in "input", the formula will return TRUE and the conditional formatting...Read more

Pages