Queens College Service Desk

Grouping data in a PivotTable can help you show a subset of data to analyze.  Group Data 1. Select the items you want to group. Items ...

Filter data in a PivotTable in slicers You can insert one or more slicers for a quick and effective way to filter your data. Slicers have buttons ...

PivotCharts are a great way to add data visualizations to your data. Create a PivotChart 1. Select a cell in your table. 2. Select Insert and choose ...

Share a workbook with others, right within Excel. You can let them edit the workbook or just view it. Select Share. Share Add people...

You can add comments to cells. When a cell has a comment, an indicator appears in the corner of the cell. When you hover your cursor over the cell, the com...

You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. 1. In the upper right, select Share, then select Sh...

By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's pos...

To prevent others from accessing data in your Excel files, protect your Excel file with a password. Select File > Info . Inf...

You can use the Office programs to save or convert your files to PDFs so that you can share them or print them using commercial printers. And you won’t nee...