[MM_Member_Decision membershipId='!2']

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

[/MM_Member_Decision]
[MM_Member_Decision membershipId='!2']
BUY
[/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]

Intermediate Module 01
Powerful Excel Functions You Can Use Every Day

Formulas and functions sit at the heart of any spreadsheet. It's the engine. Excel provides over 450 functions and the more you know, the more you'll be able to achieve with Excel. Let's get to it.

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] Download the training notes (PDF) [MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision]

[MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision] 1.1    Training notes [MM_Member_Decision isMember='true' status='active' membershipId='2'] [/MM_Member_Decision]

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

1.2   A refresher of Excel's 5 basic formula functions

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

1.3   Refesher exercise - solutions

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

1.4   COUNT functions (COUNT, COUNTA, COUNTBLANK)

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

1,5   COUNT functions exercise - solutions

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

1.6   The PI function

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

1.7   LOGIC functions (AND and OR) and lots of clever tricks you never knew existed

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

1.8   Logic functions exercise - solutions

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

1.9   The IF function

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

1.10   IF function exercise - solutions

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

1.11   DATE & TIME functions

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

1.12   DATE & TIME functions exercise - solutions

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

1.13   ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, TRUNC functions

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

1.14   NUMBER functions exercise - solutions

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

1.15   COMBO functions (COUNTIF, SUMIF, SUMIFS)

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

1.16   COMBO functions exercise - solutions

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