If you have several sheets set up the same way, but with different data in them, you can use Excel’s Consolidate tool. Here is how:
- Use Word’s built-in Heading styles: Heading 1, Heading 2, etc. in your document.
- Click the References tab.
- Click the first button on the ribbon: Table of Contents and choose a type.
If you want to change text in the table of contents, it is best to go to the heading in your document and change the text there. Then go up to your table of contents, click in its title and Update your table of contents.
Creating Excel PivotTables can be easier than you think. Here is a demo:
- In PowerPoint 2016, use any of the standard design templates like Berlin or Ion.
- After your Title Slide, create a new slide with bullet points.
- Click on the Design tab at the top of the screen.
- Follow all the design choices to the right and click on the Design Ideas button.
- The Design Ideas pane opens up.
- Click on a design idea you like.
- The screenshot above shows how PowerPoint converted plain bullet points to a design idea.
How to see email, a Mini-Calendar, and Task List all at once
- Below your email near the bottom of the screen you will see icons for your calendar and task list.
- Right-click on the Calendar icon and choose Dock the Peek
- Right-click on the Task list icon and choose Dock the Peek
- The first button is to share editing your document with someone.
- The second button is to see the document activity: who has edited it and saved it, etc.
- The third button is to see comments you or other people have made about the document. Comments are also part of the Review tab.
These buttons are at the right of the screen above the Find tool on the ribbon. They are visible no matter which tab you are on. (Applicable to version 1710 of Microsoft Office 365 subscription).
Right-click on the File Explorer icon at the bottom of your screen to see and select frequently used Folders.