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

Formatting Like a Pro

Master the art of adding a professional finish to your spreadsheets. After moving through the basics of formatting you'll be treated to such delights as conditional formatting, custom cell styles, custom content formatting and the modern table tools.

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='29'] [/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='29'] [/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='29'] [/MM_Member_Decision] Download the 'Formatting Like a Pro' 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='29'] [/MM_Member_Decision]

Formatting Fundamentals

[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='29'] [/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='29'] [/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='29'] [/MM_Member_Decision] 1(a)    Formatting 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='29'] [/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='29'] [/MM_Member_Decision]

2.   Formatting numbers, percentages, currency & dates

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

3.   Aligning and positioning cell data

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

4.   Tricks to make your text look great

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

5.   Adding borders and a touch of colour

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

6.   Using the Format Painter tool to replicate exiting formatting

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

7.   Enhancing your workbook with images/pictures/graphics

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

8.   Adding background graphics, working with gridlines, clearing formatting

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

9.   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='29'] [/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='29'] [/MM_Member_Decision]

10.   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='29'] [/MM_Member_Decision]

Advanced Formatting Techniques

[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='29'] [/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='29'] [/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='29'] [/MM_Member_Decision] 1(a)    Conditional Formating, Custom Styles, Formatted 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='29'] [/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='29'] [/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='29'] [/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='29'] [/MM_Member_Decision] 1(b)    Custom Content Formats: 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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/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='29'] [/MM_Member_Decision] 1(e)    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='29'] [/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='29'] [/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='29'] [/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='29'] [/MM_Member_Decision]

3.   Conditional 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='29'] [/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='29'] [/MM_Member_Decision]

4.   Simplifying your formatting creating custom Cell Styles

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

5.   Modifying Cell Styles

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

6.   Format Painter - the copy and paste tool for formatting

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

7.   How to re-use cell styles in other workbooks without recreating them

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

8.   Creating tables the modern way

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

9.   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='29'] [/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='29'] [/MM_Member_Decision]

10.   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='29'] [/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='29'] [/MM_Member_Decision]

11.   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='29'] [/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