Useful Shortcuts for Excel 2003

Friday, 8 November 2013

Very Useful Shortcuts for Excel 2003
(click on image to enlarge)

comments | | Read More...

How to transform an entire word uppercase to lowercase

Thursday, 7 November 2013

To change the case (uppercase letters, lowercase letters) of text in Word,

• select the text,
• press Shift and the F3 function key.

To return to lowercase repeat the same operation.

comments | | Read More...

How to Change the default font in MS Word

Wednesday, 6 November 2013

Font that appears when you open a Word document is also called default font, you can change

• Format dropdown menu
• Police line
• In the window that opens, select the font you want to appear by default 
• and click the button at the bottom left of the window: "Default".

comments | | Read More...

How to replace a word with another in ALL your Word document

Tuesday, 5 November 2013

This feature can be very useful if want to change a word that is often repeated in your file The procedure Edit pull-down menu -> Replace  and spotted

comments | | Read More...

How To make calculations in Ms Word

Monday, 4 November 2013

If you do not have the courage to do the mental math and you are in Word,

• Use Ctrl + F9
•  type =,
• then your operation 
• and hit F9 
• Word will give you the result

comments | | Read More...

Put zeros before a number while keeping the possibility of calculating

Sunday, 3 November 2013

Very useful to align the numbers in a cell

the walk-through: use the custom formatting

 

Procedure selecting the cell or cells Format dropdown menu cell line In the window that opens many tab should be selected by default place the dropdown and at the end select the option "Custom and in the box type as zero indicate that we want numbers and confirm with OK verify that you have

comments | | Read More...

Multiple lines in a one Excel Cell

Friday, 1 November 2013

TIP

• Go to Excel.
• Type a line of text
• Press simultaneously on ALT and Enter
• Type a few words ... and magic was a new line!

comments | | Read More...

Create a formula in Excel

Formulas are equations that perform calculations on values ​​in your Excel Work Book.

A formula starts with an equal sign (=). 

1 / create a simple formula

• click in a cell
• then type    = 5 * 6 9
  
• the following formula multiplies 6 by 9 and adds 5 to the result.

2 / create a formula that refers to other cells

Example formula	Effect
= C2	Uses the value in cell C2
= Sheet2! B2	Uses the value of cell B2 on Sheet2

1. Click the cell in which you want to enter the formula.
2. in the formula bar,
   
    
3. type  = (equal sign).
4. then select a cell (or a range of cells, a location on another worksheet ..)
   
5. press enter
6. add a "logical operator" 
   eg +, -, / ...
7. and repeat as often as necessary with other cells

comments | | Read More...