Sharing options are found on the File menu. Some sharing options were available in previous Word versions, but it’s even easier in Word 2016 to share files. This innovation makes it easier for authors, editors, and other team members to directly address others’ comments during the editing process, thereby eliminating confusion and enhancing collaboration. There’s also support for threaded comments, so collaborators and reviewers can conduct a conversation regarding a document’s proposed changes. When a user working on a file saves any changes, the platform generates a notification that highlights the changes for the other users. Multiple team members can simultaneously create and edit a single new Word document. The Smart Lookup feature is also available on the Tools menu. In this case, you’ll see a company summary, the company’s Wikipedia page, and Microsoft’s official website all listed within the top search results. For example, highlighting the word “Microsoft” within a document, then right-clicking and selecting Smart Lookup, generates a window that reveals Bing search results. Smart Lookup provides contextually relevant information for highlighted text, so authors can access additional web-based data. Pre-formatted templates, color combinations, complete themes, and individual fonts all appear on the Design tab.
#Whats new in excel for mac 2016 professional#
The tab aims to make it easier for Mac users to quickly access preconfigured design elements and produce professional appearing documents without having to possess any significant graphics or design expertise. Word 2016 for the Mac includes a new Design tab.
#Whats new in excel for mac 2016 how to#
Office 365 users can learn more about the new version of Office, and how to download it, in my previous post: “ What’s new in Office 2016 for Mac?“ Numerous innovations are included with Microsoft’s newest version of Word for the Mac. Mac users leveraging Microsoft Office 365 should be pleasantly surprised to learn they’re eligible to begin using Microsoft’s new Office 2016 for Mac applications. Here's a quick walk through of the new word processing platform. Microsoft Word receives intriguing new features within its 2016 for Mac iteration, including new design, review, and collaboration capabilities. Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format.Intriguing new features in Microsoft Word 2016 for Mac Have a look at the following image and the tutorial below that to see how this is achieved using Excel 2013:Ħ. Lock The Excel Pivot Table But NOT The Slicer! Now as you select each Slicer’s items, both Pivot Tables will change! STEP 5: Right Click on Slicer #2 and go to Report Connections(Excel 2013)/PivotTable Connections (Excel 2010) > “check” the PivotTable1 box and press OK STEP 4: Right Click on Slicer #1 and go to Report Connections(Excel 2013 & 2016)/PivotTable Connections (Excel 2010) > “check” the PivotTable2 box and press OK STEP 3: Click in Pivot Table #2 and insert a YEAR Slicer by going to PivotTable Tools > Analyze/Options > Insert Slicer > Year > OK STEP 2: Click in Pivot Table #1 and insert a MONTH Slicer by going to PivotTable Tools > Analyze/Options > Insert Slicer > Month > OK
STEP 1: Create 2 Pivot Tables by clicking in your data set and selecting Insert > Pivot Table > New Worksheet/Existing Worksheet You can then use the scroll bar to increase and decrease the columns or manually type in the number of columns to show your Slicer. To do this you need to click on your Slicer and go to Slicer Tools > Options > Buttons > Columns. Say that your Slicer is showing months from January to December, you can change the layout of the buttons to show in 3 separate columns, turning it into a “Quarterly View”. When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout. SHIFT KEYBOARD:You can select a range of items by holding down the SHIFT key on your keyboard! LEFT MOUSE CLICK:You can select items from the Slicer by using your left mouse button ĭRAG LEFT MOUSE BUTTON:You can select an array of items by clicking the left mouse button and doing a dragging motion downwards/upwards within the Slicer ĬTRL KEYBOARD:You can select multiple items by holding down the CTRL key on your keyboard
0 kommentar(er)
