by

Stanford Microsoft Office For Mac

Faculty, staff, and students with a Stanford Office 365 account can install Office 365 ProPlus on up to five computers (Windows and Mac), five tablets, and five smartphones at no charge. These devices can be personal or Stanford-owned. A traditional perpetual license of Microsoft Office Home & Student 2019, which grants use of Word, Excel, PowerPoint, and OneNote for one computer. Mac compatible Win dows compatible SKU 19664999. Oct 05, 2015 The Microsoft Office applications that will be available via ProPlus include Outlook 2016, Excel, Word, PowerPoint and OneNote. The latest versions currently available via ProPlus are Office 2016 for Mac and Office 2013 for Windows. Office 2016 for Windows will be available early October at ess.stanford.edu. Mac spinning wheel of death.

PivotTables are used to organize and summarize data in numeric form. If you have a large Excel spreadsheet with lots of information stored in it, a PivotTable can make the data easier to comprehend and manage.

To create a PivotTable:

  1. Select a cell in your spreadsheet.
  2. In Excel 2007, 2010, or 2013, click Insert, and then click PivotTable.
    In Excel 2008 or 2011, click Data, and then click PivotTable.
  3. Select the range of data you wish to be included in your PivotTable. Then, choose where you wish the PivotTable to be displayed (a new Worksheet or an existing Worksheet). Click OK.
  4. Select the fields you wish to be included in your Pivot by dragging them to the Row, Column, and Values sections. Be sure to put numeric data in the Values. The Report Filter can be used as a way of further filtering out the data.

For example, from this spreadsheet (fake data taken from the Sample Human Resources Report found in ReportMart1):

Buy Microsoft Office Mac

the following PivotTable was created by dragging the Salary to Values, the Dept Name to Column, and the Range to Row:

Stanford Microsoft Office For Mac Office

And this PivotTable was created by dragging the Dept Name into Column, the Employee Number into Values (changing it from Sum to Count by clicking the i button), and Range and Job Title to Row: