Medgar Evers College of CUNY

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

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

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. Crea...

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

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

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