MS OFFICE TIPS AND TRICKS

MS Word 2016

Master Documents and Subdocuments in MS Word 2016Image result for ms word 2016

One of the most useful features of MS Word is the management of large documents and their subsections, which allows users to collaborate documents by separating sections into different files. Subdocuments make it easy to update and export parts of a large document.

The tool is also great for smaller documents that have independent sections. In MS Word 2016, you don’t have to create subdocuments when you first create your Master Document. You can identify a document as the Master Document and then proceed to identifying the subdocuments within it, which can be split or merged with other subdocuments. Here’s a “how to” article to help you: https://www.addictivetips.com/microsoft-office/how-to-create-a-master-document-and-subdocuments-in-ms-word-2016/

ExcelImage result for excel

Freeze Panes

To keep the column or row names static while you scroll through the data, you can freeze the panes to help keep track on the data you’re looking at.

To freeze panes, click on the cell below the column heading and to the right of the label for each row, then to go View > Freeze Panes > Freeze Panes to make the column headings stay still so you can see them at all times.

Create a Backup Copy of a Sheet

This is great when you want to duplicate a sheet, so you can make changes without screwing up the original.
  1. Left-click and hold on the sheet you want to copy.
  2. Press and hold the Ctrl key. A plus symbol will appear in the sheet mouse icon.
  3. Drag the sheet to the right until the down arrow appears to the right of the sheet.
  4. Release the left mouse button. Then release the Ctrl key.
  5. It sounds like a lot, but once you get the hang of it you will wonder how you ever lived without this trick. It’s much faster than right-clicking the tab and going to the Move or Copy… menu.

You can also first select multiple sheets with the Shift key, then use the same method to copy multiple sheets at the same time.

 

Ctrl+Enter To Fill Multiple Cells

This keyboard shortcut can save time when entering the same formula in multiple cells.

  1. Select the cells that the formula will be inserted in.
  2. Type or insert the formula or text in the active cell.
  3. Hold the Ctrl key and press Enter. The formula or text will be copied to all the selected cells.

Bonus tip: If you have a single cell selected, then Ctrl+Enter can be used to keep that cell selected after you edit the formula.  Typically, the next cell will be selected after hitting Enter. Press Ctrl+Enter to keep the same cell selected.

Image result for powerpoint

PowerPoint

Use the Quick Access Toolbar

The Quick Access Toolbar (QAT) is located at the very top of the PowerPoint window. It gives you the possibility to keep access to your favorite features at all time. Features in the QAT will be actionable whatever tab you are currently on. By default, it contains the SaveUndoRepeat and Start from beginning commands.

To customize your QAT, the easy way is to just click on the drop-down arrow at the right of the QAT. You can then click More commands. You will view two lists of PowerPoint commands. The list on the left is the exhaustive list commands, while the list on the right is the list of commands in the QAT. Select your favorites from the left list and click on Add to add them to the QAT. They will now be accessible at the top of the PowerPoint window anytime.

The 10/20/30 Rule

It’s called it the 10/20/30 Rule of PowerPoint. According to the 10/20/30 rule, a PowerPoint presentation should have ten slides, last no more than twenty minutes, and contain no font smaller than thirty points.

CCC full logo-white

  • Web Outreach, Message and Content
  • Digital Marketing, SEO and Social Media
  • Responsive and Mobile Friendly

5335 Wisconsin Avenue, NW, Suite 640 Washington, DC 20015

202-785-8000 x101
info@cccsolutions.com

Copyright 2016 © All Rights Reserved