Excel

Resolved · Low Priority · Version 2003

Mon 27 Oct 2008, 16:56 Delegate Natalie said...

Natalie has attended:
Excel Intermediate course
Excel Advanced course

Excel

How do I use an IF function?

Tue 28 Oct 2008, 10:42 Trainer David said...

RE: Excel

Hi Natalie

I found a usefull video that shows how IF functions work.
http://video.about.com/spreadsheets/IF-Function-in-Excel.htm

If you can't access the video from your machine please let me know and I'll reply with a 'how to'

David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips