Queens College Service Desk

Use the SUMIF function to sum the values in a range that meet criteria that you specify. Syntax =SUMIF(range, criteria, [sum_range]) Range → The c...

Use SUMIFS to test multiple conditions and return a value based on those conditions. For example, you could use SUMIFS to sum the number of a products sold ...

Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows o...

Use the DATEDIF function when you want to calculate the difference between two dates.  Syntax DATEDIF(start_date,end_date,unit) ...

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Onc...

Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Combined Data Type = and select t...

Create and format a table to visually group and analyze data. Select a cell within your data. Data Select Home > Format as Tab...

Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or ...

Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you fi...

You can quickly total data in an Excel table by enabling the Total Row option and then use one of several functions that are provided in a drop-down lis...