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

Excel Database Mastery

Manage, format, filter and sort your database like a pro using modern tools like sparklines, flash fill, subtotals and grouping. There's more here than you realise and you'll instantly save time by using smarter techniques every day.

[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='28'] [/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='28'] [/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='28'] [/MM_Member_Decision] Download the 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='28'] [/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='28'] [/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='28'] [/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='28'] [/MM_Member_Decision] 1(a)  Excel Databases Fundamentals: 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='28'] [/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='28'] [/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='28'] [/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='28'] [/MM_Member_Decision] 1(b)  Grouping / Outlines - 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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/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='28'] [/MM_Member_Decision] 1(f)  Cheat Sheet - How to handle duplicates in Excel [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='28'] [/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='28'] [/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='28'] [/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='28'] [/MM_Member_Decision] 1(g)  Cheat Sheet - Every smart sorting trick in the book [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='28'] [/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='28'] [/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='28'] [/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='28'] [/MM_Member_Decision]

3.   Time saving tips when entering data

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

4.   Using the Data Form (now a legacy tool)

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

5.   Spark Lines

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

6.   Flash Fill

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

7.   AutoFiilter

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

8.   AutoFilter exercise - solutions

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

9.   Advanced Filter

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

10.   Advanced Filter exercise - solutions

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

11.   Sorting rows & columns in Excel 2016 (everything you need to know)

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

12.   Sorting rows

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

13.   Sorting rows using a custom sort sequence

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

14.   Using the Sort tool to change the order of table columns

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

15.   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='28'] [/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='28'] [/MM_Member_Decision]

16.   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='28'] [/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='28'] [/MM_Member_Decision]

17.   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='28'] [/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