Go to Insert > PivotTable. If you’re using Excel for Mac 2011 and earlier, the PivotTable button is on the Data tab in the Analysis group. 3. Excel will display the Create PivotTable dialog with your range or table name selected. How do I find a PivotTable in Excel? Insert a Pivot Table Click any […]

How do I combine two pivot tables into one PivotTable? Combining PivotTables is as easy as knowing one simple command. Open the PivotTable you would like to work with. Click on a cell with the new worksheet where you want to start the consolidated data. Click “Consolidate” on the Data menu. Click on “Sum” (or […]

Select a table or range of data in your sheet, and then select Insert > PivotTable to open the Insert PivotTable pane. You can either manually create your own PivotTable or choose a recommended PivotTable that was created for you. What is the shortcut to open pivot table in Excel? Select the data set and […]

Rename a PivotTable Click the PivotTable. Go to PivotTable Tools > Analyze, and in the PivotTable group, click the PivotTable Name text box. For Excel 2007-2010, go to PivotTable Tools > Options, and in the PivotTable group, click the PivotTable Name text box. Type a new name. Press ENTER. How do you label a pivot […]

Click anywhere in a pivot table to open the editor. Add data—Depending on where you want to add data, under Rows, Columns, or Values, click Add. Change row or column names—Double-click a Row or Column name and enter a new name. Change sort order or column—Under Rows or Columns, click the Down arrow. How do […]

Log in to your email provider and compose a new message. Type in your client’s email address, a subject related to the fact that you’re sending your portfolio and a message that briefly explains the portfolio’s content. Attach the portfolio to the email and send it off. How do I send a work portfolio? Aim […]

Adjust the VoiceOver volume and other audio options To increase or decrease the volume, press the volume buttons on iPhone. To set other audio options, go to Settings > Accessibility > VoiceOver > Audio, then set options such as the following: Sounds & Haptics: Adjust and preview sound effects and haptics. Can barely hear voice […]

How to Encrypt Emails on iOS Go to advanced settings and switch S/MIME on. Change “Encrypt by Default” to yes. When you compose a message and lock icon will appear next to the recipient. Click the lock icon so it’s closed to encrypt the email. How do I encrypt Gmail on iPhone? Send messages & […]

Sign or encrypt emails in Mail on Mac In the Mail app on your Mac, choose File > New Message. Move the pointer over the From field, click the pop-up menu that appears, then choose the account for which you have a personal certificate in your keychain. Address the message to recipients. How do I […]

The style issue up for debate was whether we continue to use the phrase ‘data are’ or change it to ‘data is’? The grammatically correct approach is ‘data are‘, because the word ‘data’ is the plural of the latin word ‘datum’. Is data is singular or plural? As shown in the Publication Manual (p. 96), […]