Queens College Helpdesk

Create a chart from a table Select the cells you want to use. Select Insert > Recommended Charts. Select the chart type you want, and selec...

A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as ...

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Creat...

After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields.  The Field L...

Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times (date and...

To focus on a smaller portion of a large amount of your PivotTable data for in-depth analysis, you can filter the data. There are several ways to do that. S...

Create a PivotChart Select a cell in your table. Select Insert > PivotChart  . Select OK. Create a chart from a PivotTable Selec...

Select Share. Select permissions and then Apply. Add people. Type a message if you like. Select Send. Source: Microsoft

Add a comment Right-click a cell and click Insert Comment. In the comment box, type your comment. Click outside the comment box. The commen...

You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes ...