Use SUMIF and SUMIFS to sum with conditions. Learn how to use different types of conditions including dates and multiple criteria for a single range.
Category Archives: 2 Intermediate
Data Tables
Reply
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.
Continue reading
Named Ranges
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.
Continue reading
Restrict Values in a Cell
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
Customise the Quick Access Toolbar
Excel commands or buttons that you use frequently can be easily added to the Quick Access Toolbar (QAT). This means that your favourite buttons are only one click away. Continue reading