Forum home » Delegate support and help forum » Microsoft Excel Training and help » Functions
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Functions
Resolved · Medium Priority · Version 2003
Reply Fri 16 Apr 2010, 00:51Delegate Matt said...
Matt has attended:
Excel Advanced course
Functions
I've understand that functions can be arranged in "arrays", how would this be structured and what is the purpose?
For upcoming training course dates see: Pricing & availability
RE: Functions
Hi Matt, thanks for your query. Actually, an array is a multi-dimensional variable rather than an arrangement of functions. A table on a spreadsheet is an "array" of data which Excel can then process. Arrays are more commonly used in programming but one live example would be how Excel creates a Pivot table from raw data - it's creating and manipulating an array from your data in the background. Using arrays programmatically really speeds data processing up but unless you've an interest in VBA you won't really come across them using standard Functions in Excel.
Hope this helps,
Anthony
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Reply Fri 16 Apr 2010, 12:42Delegate Matt said...
RE: Will be marked as resolved in 5 days
Thanks for the clarification Anthony
Does your VBA course cover arrays?
RE: Will be marked as resolved in 5 days
Hi Matt. Our advanced course covers arrays. The 2 day intro/intermediate course gives you a good grounding in the basic principles of programming (variables, loops, objects etc) so you can then go on and be confidant manipulating something like an array.
http://www.microsofttraining.net/vba-training.php
Hope this helps,
Anthony
Fri 23 Apr 2010: Automatically marked as resolved.
|