Windows

Keyboard Shortcuts

crl + shift + t = pulls back closed page
crl + w = close tab

How to move a window back on your screen

Click on the window you want to move
alt+space+m
Directional arrows

Microsoft Excel

Data Validation

Using data validation tools prevents users from inputting bad data, but not from pasting it.
Go to the Data Menu, in the Data Tools group, select Data Validation.

Excel Names

Using excel names that are usable in formulas makes formulas easier to understand.
Use names to reference one cell or an array.
Excel names simplify references to other worksheets.

Calculation Formula Rules

Keep them short.
Add a sentence explaining what a block of formulas is doing.
They should only reference cells on the same worksheet or names ranges on (same or other) worksheets.
They should not include "raw inputs."

Creating Histograms using Data Analysis Toolpak

To Install the Data Analysis Toolpak:
Go to File>Options>Add-Ins>Select Analysis Toolpak>Go down to Manage "Excel Add-ins" and hit Go>Check the box next to Analysis Toolpak and hit Ok

To Create a Histogram:
Go to Data Ribbon>Analysis Panel>Data Analysis (Above Solver)
Input Range: Select data including header
Bin Range: Select data including header
Output Range: Select a cell or "new worksheet" for the output

Refining your Histogram:
Delete the "More" at the bottom of the newly created data to remove it from the histogram.
Right click on data series and select "Format Data Series." You can adjust the gap width.
Go to Chart Tools>Format>Update the Shape Color, etc...

Microsoft Word

Redline Strikeout

Select the text you want to format.
On the Home tab, in the Font group, click Strikethrough.
Reference

Creating a Redline Strikeout (RLSO) Document By Comparing Two Versions

On the Review tab, in the Review Group, click Compare.
Select the original document (Ex. Rev 0 of your document).
Select the revised document (Ex. Rev 1 of your document).
Select "create new document" and click OK.
Reference

Deleting a Watermark

On the Page Layout Tab - Select Watermark - Remove
Reference 

Converting Text to ALL CAPS

Highlight the text you want to change
Expand the font dialog box
Check the box under "Effects" for "All Caps" and click OK.
Reference

Linking an Excel Table in a Word Document

Open the Word Doc and Excel File.
In Excel - Select the range of cells you want and copy with CTRL+C.
In Word - Click where you want the data, go to the home tab, in the clipboard group click the arrow under paste and select paste special. Select Microsoft Office Excel Object. Click Paste to insert as an embedded object.
Reference