DB's

Resolved · Low Priority · Version 2003

DB's

Dorothy has attended:
Excel Advanced course

by - delegate Dorothy [2 posts] (2008 Jun 26 Thu, 16:55) Reply

What is an array?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: DB's

by - trainer Simon gold contributer [151 posts] (2008 Jul 14 Mon, 15:55) Reply

Hi Dorothy,

Thank you for your question.

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. For example, you can place an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. You can also place an array formula in a single cell and then calculate a single amount. An array formula that resides in multiple cells is called a multi-cell formula, and an array formula that resides in a single cell is called a single-cell formula.

I hope this gives you an insight into what an array is.

Regards

Simon

· How to Create Better Excel Spreadsheets: Part Three
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· How to check for and reduce errors in Microsoft Excel

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

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Rate this page: