It is simple to insert a pivot table in Excel But when upgrade to Microsoft //, users will feel there is no way to get the PivotChart Wizard. Hey there, I'm trying to combine two pivot tables from separate worksheets This thread is exactly what I need to do, but I'm on a Mac, which means the Pivot Table wizard to create a single pivot table from 2 ranges instead. No credit card required. Using the PivotTable and PivotChart Wizard. Video thumbnail for Using the PivotTable and PivotChart Wizard. Off Air. / Auto. Excel offers an excellent pivot table help agent that aids you in your creation and editing of pivot tables. Frankly, this is no longer available on Mac Excel. To do this, you must use the PivotTable Wizard and choose the Multiple consolidation ranges option. Although this wizard was removed from the user interface. This shortcut will launch the PivotTable Wizard dialog box. Note: In Mac , the Pivot Table Wizard appears to be gone. If you find a workaround, let us know. I would like to know how to do consolidated pivot tables on the new excel for mac. Before it was possible to activate the pivot table Wizard by pressing Cmd . Excel For Mac Pivot Table Wizard. Excel for Office Excel for Office for Mac Excel Excel Excel for Mac Excel Currently this is possible in windows using the pivot table wizard. vote to allow multiple consolidation ranges in Excel for Mac for Pivot Tables.