VALUE HAS A VALUE IF ITS VALUE IS VALUED

PowerPoint Show file! Heard about that?
Yes, it is the file with a .pps extension that plays the PowerPoint slideshow. Since it runs the slideshow directly, you don't get the option of editing the file from the PowerPoint environment.

However, with a small tweak you can easily edit the content in the PowerPoint Show file.

1. Let's assume you have a powerpoint show named "Life.pps" which needs to be modified.

2. All you have to do is change(or rename) the extension of the file from .pps to .ppt.
(Note: To display the file extensions of file types, in Windows Explorer go to Tools >> Folder Options >> View and uncheck the "Hide file extensions of known file types" checkbox.)

3. So, "Life.pps" should be made "Life.ppt".

4. Clicking the "Life.ppt" file will open it in the PowerPoint environment and can be easily edited.

This tweak can also be applied the other way around when you want to make a PowerPoint Slideshow (.pps) from a PowerPoint presentation document (.ppt).

ALT and = Autosum
ALT and F8 Macros
CTRL and ; Insert Current Date
CTRL and : Insert Current Time

Keyboard Shortcuts Result in Excel - Movement
Left Arrow One Cell Left (also SHIFT and TAB)
Right Arrow One Cell Right (also TAB)
Up Arrow One Cell Up
Down Arrow One Cell Down
Home Go to End of row
CTRL and left Arrow Go to End of Column
CTRL and Home Go to Top of Worksheet (A1)
CTRL and End Go to End of Worksheet
CTRL and PAGE-DOWN Go to Next Worksheet

Keyboard Shortcuts Result in Excel - Cell Selection
CTRL and Spacebar Select the entire Column
SHIFT and Spacebar Select the entire Row
CTRL and A Select Entire Worksheet
SHIFT and Left Cursor Select all cells to the left of the active one
SHIFT and Right Cursor Select all cells to the right of the active one..

Type (Without Quotes)
" =rand(200,99) "
and press ENTER in the Microsoft Word Document
and watch the magic.
Trick 2:
Create Table Without mouse and Menu !!
Type the content (+——+——-+——+) in Microsoft Word and press Enter with out paranthesis. One row of a table will be created and for more rows you can press TAB.

Step 1:copy and paste the below line.

+———–+————————+————-+

Step 2: (After pressing Enter having the cursor at the last ‘+’ Result will be Table of single row is created)

Step 3: (press TAB to create more Rows)

here ' + ' represents the column borders and ' – ' represents the length of the each column.