[MM_Member_Decision access='true' isMember='true' status='active' hasBundle='!30' membershipId='3']

[Preview Mode] All links and videos on this page are inactive

[/MM_Member_Decision] [MM_Member_Decision access='false' | isMember='false' | status = '!active')]

[Preview Mode] All links and videos on this page are inactive

[/MM_Member_Decision]
[MM_Member_Decision access='true' isMember='true' status='active' hasBundle='!30' membershipId='3'] [/MM_Member_Decision] [MM_Member_Decision access='false' | isMember='false' | status = '!active')] [/MM_Member_Decision]
Excel Clubhouse

[MM_Member_Decision isMember='false'] Visit Clubhouse Store   |   Login [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active'] G'day [MM_Member_Data name='firstName'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='2']   |   VIP Lifetime Member [/MM_Member_Decision]
[MM_Member_Decision isMember='true' status='active'] Account [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='!2']   |   Upgrade to VIP   |   Clubhouse Store [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active']   |   Logout  [/MM_Member_Decision]

[MM_Member_Decision isMember='true' status='active' membershipId='2'] Return to Dashboard Return to Module List
[/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='!23'] Return to Dashboard
[/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='23'] Return to Dashboard Return to Beginners Module List
[/MM_Member_Decision]

Array Formulas: Hidden Magic

Take your skills beyond the standard Excel formulas and discover the magic of array formulas, a vastly under-utilised part of Excel. Some of the things you can achieve with arrays include controlling logic, transposing data and creating histograms and frequency distributions.

[MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision] Download the practice files [MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

[MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision] Download the Arrays practice files (zip format) [MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

[MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision] Download the training notes [MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

[MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision] 1.    Array Formulas: Step-by-Step Training Notes [MM_Member_Decision access='true' isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision access='true' isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

2.   Basic Array Formulas

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]
[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

3.   Adding Logic To Arrays

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]
[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

4.   Array Logic exercise - solutions

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]
[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

5.   Using Arrays To Transpose Data

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]
[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

6.   Frequency Distribution Using Arrays

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]
[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

7.   Histograms Using Arrays

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='30'] [/MM_Member_Decision]

[MM_Member_Decision isMember='true' status='active' membershipId='2'] Return to Dashboard Return to Module List
[/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='!23'] Return to Dashboard
[/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='23'] Return to Dashboard Return to Beginners Module List
[/MM_Member_Decision]
Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved