[MM_Member_Decision access='true' isMember='true' status='active' hasBundle='!34' 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='!34' 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]

Absolute Cell Referencing & Naming Cells

Discover how, why and when to fix a cell reference and how to use cell naming for added benefits. If you haven't yet mastered this, it will come up a lot once you get past a certain level, so this is an essential skill.

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='34'] [/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='34'] [/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='34'] [/MM_Member_Decision] Download the 'Absolutes & Naming' 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='34'] [/MM_Member_Decision]

Part 1: Absolute Cell Referencing

[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='34'] [/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='34'] [/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='34'] [/MM_Member_Decision] 1.    Absolute Cell Referencing: 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='34'] [/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='34'] [/MM_Member_Decision]

2.   Why Absolute Referencing is so important, how to use it (and an exercise)

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='34'] [/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='34'] [/MM_Member_Decision]

3.   Exercise solution

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='34'] [/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='34'] [/MM_Member_Decision]

4.   Taking it further with partial-absolutes (this is cool)

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='34'] [/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='34'] [/MM_Member_Decision]

5.   A mortgage repayment example using partially-absolute cell referencing

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

Part 2: Naming Cells To Make The Process Easier

[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='34'] [/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='34'] [/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='34'] [/MM_Member_Decision] 1.     Naming Cells & Cell Ranges: 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='34'] [/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='34'] [/MM_Member_Decision]

2.   How & why to name cells, lots of applications (and some exercises)

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='34'] [/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='34'] [/MM_Member_Decision]

3.    Exercise solutions

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] [MM_Member_Decision isMember='true' status='active' membershipId='3' hasBundle='34'] [/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