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

Cool & New

Discover all the cool features and new features in Excel that have nothing to do with formulas. To name a few, you'll master SmartArt, Flash Fill, Sparklines, Slicers, Conditional Formatting, Custom Cell Styles, plus many more.

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='24'] [/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='24'] [/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='39'] [/MM_Member_Decision] Download the 'Cool & New' 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='39'] [/MM_Member_Decision]

Extended Table Features

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(a)    Extended Tables - 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='39'] [/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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(b)    Grouping - 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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(c)  Cheat Sheet - The new school way to do tables [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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(d)  Cheat Sheet - Flash Fill [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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(e)  Cheat Sheet - Sparklines [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='39'] [/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='39'] [/MM_Member_Decision]

2.   The 'New School' way of working with tables

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

3,   Spark Lines

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

4.   Flash Fill

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

5.   Three ways why grouping is better than hiding columns or rows

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

6.   How to group columns and rows effectively

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

7.   Adding multiple subtotals automatically without formulas

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

Slicers

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1.    Slicers - 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='39'] [/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='39'] [/MM_Member_Decision]

2.   Slicers

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

3.   Slicers exercise - solutions

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

Powerful New Formulas

[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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(a)    SUMIF and SUMIFS - Cheat Sheet [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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(b)    COUNTIF and COUNTIFS - Cheat Sheet [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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(c)    AVERAGEIF and AVERAGEIFS - Cheat Sheet [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='39'] [/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='39'] [/MM_Member_Decision]

2.   COUNTIF(S), SUMIF(S) AND AVERAGEIF(S)

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

Custom Formatting

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(a)    Custom Formatting - 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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(c)    Cheat Sheet - Custom date formats [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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(d)    Cheat Sheet - How to keep leading zeroes (the easy way) [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='39'] [/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='39'] [/MM_Member_Decision]

2.   Creating custom formats for numbers and dates

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

3.   Custom Formatting exercise - explanation

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

4.   Custom Formatting exercise - solutions

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

Goal Seek & Solver

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(a)    Goal Seek & Solver - 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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(b)  Cheat Sheet - Goal Seek [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='39'] [/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='39'] [/MM_Member_Decision]

2.   The Goal Seek Tool

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

3.   Goal Seek exercise - solutions

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

4.   The Solver Tool

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

Data Consolidation Tools

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1.    Data Consolidation Tools - 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='39'] [/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='39'] [/MM_Member_Decision]

2.   Consolidating Data By Position

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

3.   Consolidating Data By Position exercise - solutions

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

4.   Consolidating Data By Matching Labels

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

Tracing & Resolving Formula Errors

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(a)    Tracing & Resolving Errors - 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='39'] [/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='39'] [/MM_Member_Decision] Download the checklist [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='39'] [/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='39'] [/MM_Member_Decision] 1(b)    Chedklist - 15 mistakes that will destroy your spreadsheet [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='39'] [/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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(c)    Checklist - 21 Fatal formula fails [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='39'] [/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='39'] [/MM_Member_Decision]

2.   Using ISERROR & IFERROR To Counter Formula Errors

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

3.   Error Tracing & Formula Auditing Tool Set

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

Paste Special

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1.    Paste Special - 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='39'] [/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='39'] [/MM_Member_Decision]

2.   Paste Special

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

Conditional Formatting

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1(a)    Conditional Formatting - 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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(b)    Cheat Sheet - Highlighting duplicates [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='39'] [/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='39'] [/MM_Member_Decision] Download the cheat sheet [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='39'] [/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='39'] [/MM_Member_Decision] 1(c)    Cheat Sheet - Highlighting rows automatically using conditional formatting [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='39'] [/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='39'] [/MM_Member_Decision]

2.   Conditional Formatting

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

Custom Views

[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='39'] [/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='39'] [/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='39'] [/MM_Member_Decision] 1.    Custom Views - 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='39'] [/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='39'] [/MM_Member_Decision]

2.   Creating & Applying Custom Views

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

3.   Custom Views - exercise - solutions

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