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?
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.
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.
https://www.stl-training.co.uk/vba-training.php
Hope this helps,
Anthony
