YEHEY!!!

Microsoft Word tricks

1. Configure paste options

Word tries to be helpful when copied text is pasted into a document by automatically retaining the source formatting, while providing the option to change the text to match the formatting of the current document.

To avoid having to choose formatting options every time text is pasted, click the 'Office' button, followed by 'Word Options', then move to the 'Advanced' section. Under the 'Cut, copy and paste' heading, use the first four dropdown menus to choose a default setting for format pasting.

While configuring these options, untick the box labelled 'Show Paste Options Buttons' to prevent the formatting options pop-up from being displayed in the future.

Excel tricks 2

 Press [Ctrl]~ to display formulas so you can troubleshoot or debug them

If you wanted to troubleshoot a formula in early versions of Excel, you had to click on the cell containing the formula and look at the formula itself in the Formula Bar. In more recent versions of Excel, you can display your formulas by pressing [Ctrl]~. If you want to view the dependent cells for a particular cell, select it before you press [Ctrl]~.

To demonstrate this feature, open any worksheet that contains at least one formula and press [Ctrl]~. Our sample sheet contains two SUM functions. Figure H shows our sheet after we selected cell B2 and then pressed [Ctrl]~. Notice that when you press this key combination, Excel 2003 also displays the Formula Auditing toolbar.

Excel tricks 3

Generate a unique list of entries in a column

When you support or teach Excel users, one of the most common questions you'll hear is, "I've got a list with a thousand entries in a column, and many of those are duplicates. How do I generate a list of the unique entries in that column?"

There are at least two good answers to that question. The first answer is to refer back to #3 above: Go to Data | AutoFilter and then click the drop-down list for the column in question. Doing so lets you see the list of unique entries onscreen. If seeing the list satisfies your need, you're finished.

The second answer is the one to use if you want to have a list of the unique entries you can copy and paste elsewhere. To generate such a list, you'll use Data | Filter | Advanced Filter. To demonstrate how it works, we'll use the data in Column B from the sample sheet we introduced in Figure B.

1. Click on the column letter to select the entire column that contains your data and then copy it by pressing [Ctrl]C, going to Edit | Copy, or clicking the Copy button on the Standard toolbar. (Select the whole column because you'll need the column header.)
2. Paste that data into a column away from your source data range or in a new sheet. After you paste the data, it will still be selected. However, if you inadvertently deselect it, just make sure the cell pointer is located anywhere in the data you pasted before you proceed.Note: You don't have to select all the data or sort it first for this tip to work.
3. Go to Data | Filter | Advanced Filter.
4. By default, Excel will suggest filtering the list "in-place." There's nothing wrong with that, but I recommend copying the unique records to another location, so you can compare the two lists side by side.
5. As shown in Figure I, select the Copy To Another Location option, select the Unique Records Only check box, and type B1 in the Copy To field.
6. Click OK, and Excel will copy the unique entries from the source column into the new location. It will even sort those entries in alphabetical order, as shown in 

Excel tricks...

Select All with one click

The next time you need to select an entire worksheet, click the little gray box in the top-left corner of the sheet. As shown in Figure A, it's the space above the row numbers and to the left of the column letters.

Figure A

Select the entire worksheet by clicking on the gray square above the row numbers (and to the left of the column letters).

Why would you want to select the entire worksheet? Let's count some of the ways:

• With the entire worksheet selected, you can copy it from one workbook (XLS file) and then paste it into a worksheet in a different workbook. Selecting the whole worksheet ensures you won't accidentally miss something. Note: If you want to make a copy of a worksheet within the same book, just right-click on the worksheet tab, choose Move or Copy, then select the Create A Copy check box.
• With the entire worksheet selected, you can quickly and easily change the font in all cells or apply formatting to all cells.
• With the entire worksheet selected, you can double-click on any line separating two column letters or the line separating any two rows. Doing so tells Excel to adjust the width of the columns or the height of the rows to accommodate the data in the cells, which is very helpful if you've just shrunk (or enlarged) the font size of the text in your cells.

There are, of course, other ways to select all the cells in a worksheet. If you're a keyboard person, press [Ctrl]A. If you're a menu person, go to Edit | Select All.

Microsoft shortcut keys

Application window-maximize Alt-F10
Application window-previous Alt-Shift-F6
Application window-restore Alt-F5
AutoFormat Ctrl-Alt-K
AutoText-create Alt-F3
AutoText-insert entry Ctrl-Alt-V
AutoText-insert entry F3
Bold Ctrl-B
Bookmarks Ctrl-Shift-F5
Break-column Ctrl-Shift-Enter
Break-page Ctrl-Enter
Browse a document Ctrl-Alt-Home
Browse next/previous item Ctrl-PgDn/PgUp
Capatilize word shift+f3
Case-All Caps Ctrl-Shift-A
Close Ctrl-F4
Close Ctrl-W
Copy Ctrl + C
Copy formatting Ctrl-Shift-C
Create a nonbreaking hyphen CTRL+HYPHEN
Create a nonbreaking space CTRL+SHIFT+SPACEBAR
Customize a menu Ctrl-Alt =
Customize a shortcut Ctrl-Alt-Num +
Cut Ctrl-X
Date Field Alt-Shift-D
Decrease font size CTRL+SHIFT+<
Dialog box next tabbed section Ctrl-Tab
Dialog box previous tabbed section Ctrl-Shift-Tab
Document window-move Ctrl-F7
Document window-restore Ctrl-F5
Document window-size Ctrl-F8
Drawing-constrain shape to symmetrical Shift-drag
Drawing-draw from center Ctrl-drag
Ellipsis Ctrl-Alt-
Em Dash Ctrl-Alt-Num -
Endnote Ctrl-Alt-E
Exit application Alt-F4
Fields-display code Shift-F9
Fields-display codes (toggle) Alt-F9
Fields-double-click in field Alt-Shift-F9
Fields-insert blank field Ctrl-F9
Fields-lock a field Ctrl-3
Fields-lock a field Ctrl-F11
Fields-next field F11
Fields-previous field Shift-F11
Fields-unlink a field Ctrl-6
Fields-unlink a field Ctrl-Shift-F9
Fields-unlock a field Ctrl-4
Fields-unlock a field Ctrl-Shift-F11
Fields-update Alt-Shift-U
Fields-update link in source Ctrl-Shift-F7
Fields-update selected field F9
Find Find Ctrl + F
Font Ctrl-D
Font Ctrl-Shift-F
Font grow/shrink 1 pt Ctrl- ] or [
Font next/previous size Ctrl-Shift- >or <
Font Size Ctrl-Shift-P Font Size Ctrl-Shift-P
Footnote Ctrl-Alt-F
Create a new blank document Ctrl + N
Go Back Ctrl-Alt-Z
Go Back Shift-F5
GoTo Ctrl-G
GoTo Next/Previous Paragraph Ctrl-Up/Down
GoTo Next/Previous Word Ctrl-Left/Right
Graphic-crop Shift-drag
Graphic-original proportions Ctrl-click
Hanging indent-decrease Ctrl-Shift-T
Hanging Indent-increase Ctrl-T
Hard hyphen - Ctrl-Shift -
Hard space Hard space
Header/Footer-link to previous Alt-Shift-R
Heading Level 1 Ctrl-Alt-1
Heading Level 2 Ctrl-Alt-2
Heading Level 3 Ctrl-Alt-3
Help F1
Help-Whats This? Shift-F1
Hidden text Ctrl-Shift-H
Hyperlink Ctrl-K
CTRL+SHIFT+> Increase font size
Indent-decrease Ctrl-Shift-M
Indent-increase Ctrl-M
Ctrl-Alt-M Insert Comment
Insert ListNum field Ctrl-Alt-L
Italics Ctrl-I
Justify-Center Ctrl-E
Justify-Full Ctrl-J
Justify-Left Ctrl-L
Justify-Right Ctrl-R
Line-spacing Ctrl-1
Line-spacing 1.5 Ctrl-5
Line-spacing 2 Ctrl-2
List Bullet Style Ctrl-Shift-L
Macros-edit Alt-F8
Macros-view VBA code Alt-F11
Mark-Index entry Alt-Shift-X
Mark-TOA citation Alt-Shift-I
Mark-TOC entry entry Alt-Shift-O
Maximize window Ctrl-F10
Menu Bar F10
Merge-data edit Alt-Shift-E
Merge-field insert Alt-Shift-F
Merge-preview Alt-Shift-K
Merge-to document Alt-Shift-N
Merge-to printer Alt-Shift-M
Microsoft Script Editor Alt-Shift-F11
Microsoft System Info Ctrl-Alt-F1
Move between master/subdocument Ctrl-\
Newline within paragraph Shift-Enter
Next window Ctrl-F6
Nonprinting characters Ctrl-Shift-8
Normal Style Ctrl-Shift-N Ctrl-Shift-N
Open a document Ctrl-O
Open Ctrl + O Opens a saved document
Outlining-collapse Alt-Shift-Num -
Outlining-expand Alt-Shift =
Outlining-expand Alt-Shift-Num +
Outlining-move Alt-Shift-Up/Down
Outlining-promote/demote Alt-Shift-Left/Right
Outlining-Show 1st line Alt-Shift-L
Outlining-Show All Headings Alt-Shift-A
Outlining-Show Heading 1 Alt-Shift-1
Outlining-Show Heading 2 Alt-Shift-2
Outlining-Show Heading 3 Alt-Shift-3
Outlining-Show Heading 4 Alt-Shift-4
Outlining-Show Heading 5 Alt-Shift-5
Outlining-Show Heading 6 Alt-Shift-6
Outlining-Show Heading 7 Alt-Shift-7
Outlining-Show Heading 8 Alt-Shift-8
Outlining-Show Heading 9 Alt-Shift-9
Page number field Alt-Shift-P
Pane-Close Alt-Shift-C
Paragraph Space Above (add/delete 12 pt.)Ctrl-0 Ctrl-0 (zero)
Paste Ctrl-V
Print Ctrl-P
Print Preview Ctrl-Alt-I
Redo the last action CTRL+Y
Remove Character formats Ctrl-Shift-Z
Remove menu item Ctrl-Alt -
Remove Paragraph formats Ctrl-Q
Remove paragraph or character formatting CTRL+SPACEBAR
Repeat the last command Ctrl-Y
Repeat Find Ctrl-Alt-Y
Repeat Find Shift-F4 Repeat Find Shift-F4
Replace Ctrl-H
Revision Marks on/off Ctrl-Shift-E
Save As F12
Save Ctrl-S
Select All Ctrl-A
Selection extended F8
Selection reduced Shift-F8
Shortcut Menu Shift-F10
Small Caps Ctrl-Shift-K
Soft hyphen - Ctrl -
Spelling and Grammar check F7
Spell-It-display next misspelling Alt-F7
Spike-cut to Ctrl-F3
Spike-paste Ctrl-Shift-F3
Split a window Ctrl-Alt-S
Style box Ctrl-Shift-S
Subscript Ctrl =
Symbol Font Ctrl-Shift-Q
Table-remove border lines Ctrl-Alt-U
Table-to column bottom Alt-PgDn
Table-to column top Alt-PgUp
Table-to row beginning Alt-Home
Table-to row end Alt-End
Thesaurus Shift-F7
Time Field Alt-Shift-T
To bottom/top of screen Ctrl-Alt-PgDn/PgUp
Type (c) Ctrl-Alt-C
Type (r) Ctrl-Alt-R
Type (tm) Ctrl-Alt-T
underline CTRL+U
Underline-double Ctrl-Shift-D
Underline-word Ctrl-Shift-W
Undo Ctrl-Z
View-Normal Ctrl-Alt-N
View-Outline Ctrl-Alt-O
View-Page Ctrl-Alt-P
Window pane-next F6
Window pane-previous Shift-F6

 MY GOS......

Formulas!!, (well some of it)

Formula	Description (Result)
=IF(A2=15, "OK", "Not OK")	If the value in cell A2 equals 15, then return "OK". (OK)
=IF(A2<>15, "OK", "Not OK")	If the value in cell A2 is not equal to 15, then return "OK". (Not OK)
=IF(NOT(A2<=15), "OK", "Not OK")	If the value in cell A2 is not less than or equal to 15, then return "OK". (Not OK)
=IF(A5<>"SPROCKETS", "OK", "Not OK")	If the value in cell A5 is not equal to "SPROCKETS", then return "OK". (Not OK)
=IF(AND(A2>A3, A2<A4), "OK", "Not OK")	If 15 is greater than 9 and less than 8, then return "OK". (Not OK)
=IF(AND(A2<>A3, A2<>A4), "OK", "Not OK")	If 15 is not equal to 9 and 15 is not equal to 8, then return "OK". (OK)
=IF(OR(A2>A3, A2<A4), "OK", "Not OK")	If 15 is greater than 9 or less than 8, then return "OK". (OK)
=IF(OR(A5<>"Sprockets", A6<>"Widgets"), "OK", "Not OK")	If the value in cell A5 is not equal to "Sprockets" or "Widgets", then return "OK". (Not OK)
=IF(OR(A2<>A3, A2<>A4), "OK", "Not OK")	If 15 is not equal to 9 or 15 is not equal to 8, then return "OK". (OK)

I am quite frustrated now, actually

This is me while doing the excel.....

Putting the data one by one... T_T

Microsoft Excel

From Wikipedia, the free encyclopedia

  (Redirected from Microsoft excel)

Microsoft Excel

Microsoft Excel 2013 running on Windows 8
Developer(s)	Microsoft
Stable release	2013 (15.0.4433.1506) / December 11, 2012; 24 days ago
Preview release	2013 Beta (15.0.4128.1014) / July 16, 2012; 5 months ago
Operating system	Microsoft Windows
Type	Spreadsheet
License	Trialware
Website	office.microsoft.com/en-us/excel

Microsoft Excel for Mac

Microsoft Excel for Mac 2011 running on Mac OS X Snow Leopard
Developer(s)	Microsoft
Stable release	2011 (14.1.0.100825) / October 26, 2010; 2 years ago
Operating system	Mac OS X
Type	Spreadsheet
License	Proprietary commercial software
Website	www.microsoft.com/mac/excel

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has almost completely replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part ofMicrosoft Office. The current versions are 2010 for Microsoft Windows^[1] and 2011 for Mac OS X.^[2]

Micorsoft word...

Microsoft Word

From Wikipedia, the free encyclopedia

Microsoft Word

Microsoft Office Word 2013 on Windows 8
Developer(s)	Microsoft
Stable release	2013 (15.0.4433.1506) / December 11, 2012; 23 days ago
Operating system	Microsoft Windows
Type	Word processor
License	Trialware
Website	office.microsoft.com/en-us/word/

Microsoft Word for Mac

Microsoft Word for Mac 2011
Developer(s)	Microsoft
Operating system	Mac OS X
Type	Word processor
License	Commercial proprietary software
Website	www.microsoft.com/mac/word

Microsoft Word is a word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems.^[1][2][3]Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIX, OS/2, and Microsoft Windows (1989). It is a component of the Microsoft Office software system; it is also sold as a standalone product and included in Microsoft Works Suite. The current versions are Microsoft Office Word 2010 for Windows and Microsoft Office Word 2011 for Mac. (These versions differ.)

A short preview about microsoft

Microsoft

From Wikipedia, the free encyclopedia

Coordinates: 47°38′22.55″N 122°7′42.42″W

Microsoft Corporation

Type	Public
Traded as	NASDAQ: MSFT SEHK: 4338 Dow Jones Industrial Averagecomponent NASDAQ-100 component S&P 500 component
Industry	Computer software
Founded	Albuquerque, New Mexico, United States (April 4, 1975)
Founder(s)	Bill Gates, Paul Allen
Headquarters	Microsoft Redmond Campus,Redmond, Washington, U.S.
Area served	Worldwide
Key people	Bill Gates (Chairman) Steve Ballmer (CEO)
Products	Microsoft Windows Microsoft Office Microsoft Servers Video games (See products list)
Services	Online services
Revenue	US$ 73.72 billion (2012)[1]
Operating income	US$ 21.76 billion (2012)[1]
Net income	US$ 16.97 billion (2012)[1]
Total assets	US$ 121.2 billion (2012)[1]
Total equity	US$ 66.36 billion (2012)[1]
Employees	94,000 (2012)[1]
Subsidiaries	List of Microsoft subsidiaries
Website	Microsoft.com
References: [2]

Microsoft Corporation is an American multinational software corporation headquartered in Redmond, Washington that develops, manufactures, licenses and supports a wide range of products and services related to computing. The company was founded by Bill Gates and Paul Allen on April 4, 1975. Microsoft is theworld's largest software maker measured by revenues.^[3] It is also one of the world's most valuable companies.^[4]