Powerpoint Shortcut keys:All

Bold	Ctrl-B
Close	Ctrl-W
Close	Ctrl-F4
Copy	Ctrl-C
Cut	Ctrl-X
Find	Ctrl-F
Italics	Ctrl-I
Menu bar	F10
Move to the end of the entry	End
New (slide)	Ctrl-N
Next window	Ctrl-F6
Open	Ctrl-O
Outline: Collapse	Alt-Shift -
Outline: Demote paragraph	Alt-Shift-Right
Outline: Expand	Alt-Shift +
Outline: Move paragraph down	Alt-Shift-Dn
Outline: Move paragraph up	Alt-Shift-Up
Outline: Promote paragraph	Alt-Shift-Left
Outline: Show All Headings	Alt-Shift-A
Outline: Show heading level 1	Alt-Shift-1
Paste	Ctrl-V
Print	Ctrl-P
Repeat Find	Shift-F4
Repeat/Redo	Ctrl-Y
Replace	Ctrl-H
Save	Ctrl-S
Select all	Ctrl-A
Slide Show: Begin the slide show	F5
Slide Show: Black screen show/hide	B
Slide Show: End	Esc
Slide Show: Erase annotations	E
Slide Show: Go to next hidden slide	H
Slide Show: Hide pointer and button always	Ctrl-L
Slide Show: Hide pointer and button temporarily	Ctrl-H
Slide Show: Mouse pointer to arrow	Ctrl-A
Slide Show: Mouse pointer to pen	Ctrl-P
Slide Show: Next slide	N
Slide Show: Previous slide	P
Slide Show: Set new timings while rehearsing	T
Slide Show: Stop/restart automatic slide show	S
Slide Show: Use mouse-click to advance (rehearsing)	M
Slide Show: Use original timings (rehearsing)	O
Slide Show: White screen show/hide	W
Spelling and Grammar check	F7
Switch to the next presentation window	Ctrl-F6
Switch to the next tab in a dialog box	Ctrl-Tab / Ctrl-Page Down
Switch to the previous presentation window	Ctrl-Shift-F6
Switch to the previous tab in a dialog box	Ctrl-Shift-Tab / Ctrl-Page Up
Turn character formatting on or off	Num /
Underline	Ctrl-U
Undo	Ctrl-Z

Excel shortcut keys

Excel shortcut keys

Don't get bogged down in Excel's options and commands. Use this guide to its keyboard shortcuts to fly around the keyboard and get your work done without having to take your hands away to move the mouse all the time.

Ctrl+- Delete the current cell or selection
Ctrl+Shift++ Insert cell or selection
Ctrl+; Insert current date at the selected cell
Ctrl+Shift+; Insert current time at the selected cell
Ctrl+K Insert a hyperlink or web link
Ctrl+Tab Switch to the next worksheet in the workbook
Shift+F3 Open the formula window
F11 Create a chart
Ctrl+Space Select all of the current column
Shift+Space Select all of the current row
Ctrl+Shift+1 Format the current cell with commas
Ctrl+Shift+4 Format the current cell as currency
Ctrl+Shift+5 Format the current cell as a percentage
Ctrl+Arrow key Move to the next used cell in the direction of the arrow key
Ctrl+F Open the search box

Microsoft Word Shortcut keys

Most of us spend more time using Microsoft Word than any other Office application, so make use of our handy guide to Word's shortcut keys and cut down the time you spend hunting for what you want among the many menus and toolbars.

Ctrl+B Make selected text bold
Ctrl+U Underline selected text
Ctrl+I Make selected text italic
Ctrl+L Align selection or paragraph to the left of the screen
Ctrl+E Align selection or paragraph to the centre of the screen
Ctrl+M Indent paragraph or selection
Ctrl+1 Single-space all the lines in selection
Ctrl+2 Double-space all the lines in selection
Ctrl+5 1.5-space all the lines in selection
Ctrl+Space Toggle AutoCorrect
Ctrl+Del Delete the word to the right of the cursor
Ctrl+Backspace Delete the word to the left of the cursor
Ctrl+Shift+8 Toggle hidden characters that mark spaces, carriage returns, and so on
F7 Run a spelling and grammar check
Shift+F7 Use the Thesaurus

Microsoft office Outlook Shortcut keys; All Versions

Although Outlook Express doesn't have as many options or buttons as Word or Excel, it does have many features that are easier to get at if you use the keyboard rather than the mouse. This guide to keyboard shortcuts will help you navigate your way around your inbox.

Ctrl+M Send and receive messages
Ctrl+N Start a new mail message
Ctrl+P Print the current message
Ctrl+R Reply to a message
Ctrl+Shift+R Reply to all addressees of a message
Ctrl+F Forward a message
Ctrl+Shift+B Open your address book
Alt+Enter View message properties including header information
Ctrl+I Go to your Inbox
Ctrl+Enter Mark a message as read
Ctrl+Y Open the dialogue box to go to a folder
Ctrl+> Go to the next message in your inbox
Ctrl+< Go to the previous message in your inbox
Ctrl+U Go to the next unread message in your inbox
Ctrl+D Delete the currently selected message

Data validation in MS Excel

Working in a team can be irritating if some of the team members don’t play by the rules you all agreed when you started a project. Imagine this situation: for this team, you created some Excel templates which the other members need to fill in and return them to you, so you can put them together. Suppose that one of your table fields is the date at which a sale has been done, during the current year. If team members do not pay attention, they don’t use the date format in the way you want, or they make mistakes and write there instead of the current year, some 2023 or whatever other bothering thing that you’ll have to correct?

Well, when you design your template, you can easily restrict what kind of values can be input in every cell of your table. The command is called Validation and you can find it by accessing in the main menu, Data – Validation.

Let’s suppose you want to restrict a column to be used only for inputting dates in the current year.

How to proceed:

1. First, you select the cells which you want to restrict.
2. Then, in the main menu, go to Data – Validation. A popup menu opens: it has three tabs: settings, input message and error alert.
3. In Settings, in the Allow field, you select Date.
4. In the Data field you select Between (this is set by default).
5. In the Start date field you input the first date you want to be recognized as valid (01/01/2006 or 1 Jan 2006).
6. In the End date field you input the last valid date (31/12/2006 or 31 Dec 2006).
7. Now press OK and you are finished.

Yet, if you want your users to know about this enhancement you made to the worksheet, instead of pressing OK, you go to the next tab, Input Message. Here you give a title and a message which the users will see as a comment when they click on one of the cells selected by you for validation.

Furthermore, if you go to Error Alert tab, you can input there a message that the user will see when trying to input in those cells something that does not match your criteria.

Data Validation Tip: the validation property is maintained when applying the Copy – Paste command.

MS Excel pivot table field settings

Pivot table is a command in MS Excel which allows thorough analyses of a given database. It can help you group the information in a table by dynamic criteria. As an example, supposing that you have recorded all the sales you had over the past two years, you can group them to see how much you sold per year, or how many items did you sell in total, or you can make a top of your clients with split on the items bought by each of them.

I started this article with the intention of teaching you how to obtain a pivot table from an Excel database, but browsing the net, I found this site that does it very well, so if you don’t know how to do it, take a look there, then come back here for the tip I want to share with you.

I’ll show you how to switch between the normal view of the pivot table and other views, such as percentages. It saves you a lot of work, as in the common way, you would probably have to save your table as values, then create another table in which to put appropriate formulas, in order to obtain your percentages.

This way goes much faster and error free, as it is automatic:

1. Once you got your pivot table, click somewhere in the Total column
2. Look at the Pivot Table floating menu, and click on the button with an “i” in a blue circle (called Field Settings)
3. On the popup menu that opens, click on Options. You will see the menu elongating downwards
4. In the Show Data As field, choose % of column (by default, it should have been set to normal).
5. Click OK and look at your pivot table. Now the totals are displayed as percentages of the total.

Additional tip: if you press F11 while your cursor is somewhere inside the pivot table, you’ll get a very nice, dynamic and customizable pivot chart report.

How to hide formulas in MS Excel worksheets

This simple exercise supposes that you already know what a MS Excel formula is and that you currently work with formulas. If you do so, then you know that formulas in cells can be seen. A click on the respective cell makes the contained formula visible in the formula bar, just above the worksheet. It is possible to hide it from others and still keep the worksheet usable, by performing the following steps:

1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
2. In the menu bar, go to Format - Cells
3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
4. Deselect the small box tagged Locked
5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
7. In the menu bar, go to Format - Cells
8. In the popup menu that opens, click on the Protection tab
9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
10. Click on OK
11. In the menu bar, go to Tools - Protection - Protect Sheet
12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

How to assign a toolbar button to a macro in MS Excel?

Do you know what a macro is? Or how to make a MS Excel macro? Have you ever made a macro? If you had, it means you use it frequently, this is why you made it, isn’t it? It must be boring though, every time you want to run it, to go to the main menu, to look for it, to select it, to click it… Let’s suppose you already recorded your macro. If you want to access it instantly, there are two options available:

Option 1: define a shortcut keys combination for it.

• Go to Tools – Macro – Macros
• Select your macro
• Go to Options, assign a shortcut key (type it in the small box under Ctrl), press OK
• You are ready to run your macro by pressing Ctrl + key (where ‘key’ stands for the key you have previously defined)

Option 2: assign it to a custom button on your toolbar.

• Go to Tools – Customize – Commands
• In the Categories field, scroll down and select Macro
• In the Commands field, click on Custom Button and drag it to the desired position on the menu bar.
• Press Close
• You’ll see now your button on the menu bar. Click on it.
• You will be prompted to choose a macro to assign to it. Double click your desired macro and there you are!