Queens College Helpdesk

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 list f...

Convert data into table In order to use a slicer, you must convert your data into a table first. There are four ways to convert data into a table: ...

Create a chart Select data for the chart. Select Insert > Recommended Charts. Select a chart on the Recommended Charts tab, to preview the...

Add a chart title In the chart, select the "Chart Title" box and type in a title. Select the plus sign. Select the arrow next to Cha...

When you create a chart, the legend appears by default, but you can hide the legend or change its location after you create the chart. You can also show a...

When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data seri...

Add a Trendline Select a chart. Select the + to the top right of the chart. Select Trendline. Format a trendline In the Format Tren...

Select a range of cells. Select the Quick Analysis button that appears at the bottom right corner of the selected data. Or, press Ctrl + Q. ...