Using Microsoft Office for Mac as a Relational Database

By Jim Gordon, co-author of Office 2011 for Mac All-in-One For Dummies.

Part 18 - Make a PivotTable based on the results of a SQL query

EXCEL 2016
  1. On the Insert tab of the Ribbon choose PivotTable
  2. In the Create PivotTable dialog choose Use External Data Source
  3. Click Choose Connection
  4. Choose a DSN
  5. Microsoft Query opens. Write a SQL query
  6. Click the Return Data button (If you get a "Data Source Reference is not valid" error message, click the Smile button in Excel to alert Microsoft that they need to fix this.)
EXCEL 2011
  1. On the Data tab of the RIbbon, in the Analysis group of commands, click the small triangle next to the PivotTable button.
  2. From the pop-up menu choose Create Manual PivotTable to display the Create PivotTable dialog box.
  3. In the Create PivotTable dialog, click the Use External Data Source Radio button.
  4. In the Create PivotTable dialog, click the Get Data button to display the data source chooser.
  5. In the Data Source Chooser select a data source, then click the OK button to launch Microsoft Query.
  6. When you are done making your query, in Microsoft Query click the Return Data button to return to the Create PivotTable dialog.
  7. Click the OK button to return the result set to an empty Excel PivotTable, where you see the column names waiting for you to use in your PivotTable.
Part 1
Part 17 Part 19 (Next)