Automatically changing named ranges can save you time, avoiding the need to manually change the chart data range as new data is added, for example, for monthly reports. The key to this is using the OFFSET function when defining the name. Continue reading
Excel data tables are a useful way to show how calculated results depend on one or two variables. There are two types of data tables: one-way data tables which have only one variable changing and two-way data tables which have two variables changing. Let’s find out how to create each type.
You can create names for a range of cells. (A range consists of one or more cells on a worksheet.) These names can be used in formulas and functions wherever a reference to a range can be used. Using named ranges makes things more understandable, especially if others need to look at your Excel files and use them. It also reduces the chance of making an error in your calculations.
You can restrict values in a cell by applying Data Validation. You can also add a message when they select the cell and another message if they enter data that doesn’t match your criteria. Continue reading