Excel formulas

The UK's most regular instructor-led training courses.
Training information: training courses in excel · Excel training course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel formulas

Joanne has attended:
Excel Intermediate course

by - delegate Joanne [1 post] (2008 Feb 20 Wed, 09:04) Reply

How and when do you use "" in formulas? What do they mean?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	4	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	2	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Excel formulas

by - trainer Rich platinum contributer [754 posts] (2008 Feb 23 Sat, 22:22) Reply

This depends on the formula really, there are many. It basically means when there is zero length string (no text). In an if statement you might say if there is no or a zero then enter 'No Value' in the field.

· Basic Excel Training
· Reporting and Analysis with Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Prepare for your MOS Certification with MS Excel Courses

Please browse our web site to find out more about
training courses in excel and other Microsoft training courses.

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips

Rate this page: