Click here: PowerPoint AI
Blog
Consolidate Data in Excel
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:
Easy Word Table of Contents
- 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.
PivotTable Basics
Creating Excel PivotTables can be easier than you think. Here is a demo:
Click Here
PowerPoint helps us design
- 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.
Outlook 2016 – How to see email, Mini-Calendar, and Task List all at once
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
New buttons for shared document editing in Word
- 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).
Frequent Folder Miles in Windows 10
Right-click on the File Explorer icon at the bottom of your screen to see and select frequently used Folders.
Look into Microsoft Word’s deep brown eyes
I was writing a scene in Word describing a cup of coffee and noticed that the words “dark brown” had a dotted underline. When right-clicking on “dark brown” there were suggested alternative choices of:
- Deep brown
- Mahogany
- Chestnut brown
This happened because Word now checks for vague adjectives and clichés as part of the Grammar options. As a review, here are the non-printing marks Word will put under your text as default editing suggestions:
- Spelling – red squiggly
- Grammar – double blue
- Vocabulary choice – dotted chestnut-brown
To change Grammar options right-click on text underlined with dots, and choose Options for Vocabulary Choice. Alternatively, choose File>Options>Proofing, then in the Grammar section, click the Settings button. (p.s. I have Office 365 – Word 2016 version 1706, the latest update.)
New Views in Word
If you have the latest updated version of Word 2016 (Office 365), click on the View tab and you will notice a new group on the Ribbon called Page Movement.
1. Click Side to Side and you can scroll through your document by using the Horizontal Scroll bar which runs horizontally at the bottom of the Word window.
2. Two tools over you can click on Thumbnails and you will see the small thumbnail pages of your document. Click on a page to go to that page. You must be in Side to Side view to see the Thumbnails tool.
3. To switch to the usual vertical scrolling click on the Vertical tool.
