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

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

Download the practice files

Download the 'Cool & New' practice files (zip format)

Extended Table Features

Download the training notes

1(a)    Extended Tables - Step-by-step training notes

Download the training notes

1(b)    Grouping - Step-by-step training notes

Download the cheat sheet

1(c)  Cheat Sheet - The new school way to do tables

Download the cheat sheet

1(d)  Cheat Sheet - Flash Fill

Download the cheat sheet

1(e)  Cheat Sheet - Sparklines

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

3,   Spark Lines

4.   Flash Fill

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

6.   How to group columns and rows effectively

7.   Adding multiple subtotals automatically without formulas

Slicers

Download the training notes

1.    Slicers - Step-by-step training notes

2.   Slicers

3.   Slicers exercise - solutions

Powerful New Formulas

Download the cheat sheet

1(a)    SUMIF and SUMIFS - Cheat Sheet

Download the cheat sheet

1(b)    COUNTIF and COUNTIFS - Cheat Sheet

Download the cheat sheet

1(c)    AVERAGEIF and AVERAGEIFS - Cheat Sheet

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

Custom Formatting

Download the training notes

1(a)    Custom Formatting - Step-by-step training notes

Download the cheat sheet

1(c)    Cheat Sheet - Custom date formats

Download the cheat sheet

1(d)    Cheat Sheet - How to keep leading zeroes (the easy way)

2.   Creating custom formats for numbers and dates

3.   Custom Formatting exercise - explanation

4.   Custom Formatting exercise - solutions

Goal Seek & Solver

Download the training notes

1(a)    Goal Seek & Solver - Step-by-step training notes

Download the cheat sheet

1(b)  Cheat Sheet - Goal Seek

2.   The Goal Seek Tool

3.   Goal Seek exercise - solutions

4.   The Solver Tool

Data Consolidation Tools

Download the training notes

1.    Data Consolidation Tools - Step-by-step training notes

2.   Consolidating Data By Position

3.   Consolidating Data By Position exercise - solutions

4.   Consolidating Data By Matching Labels

Tracing & Resolving Formula Errors

Download the training notes

1(a)    Tracing & Resolving Errors - Step-by-step training notes

Download the checklist

1(b)    Chedklist - 15 mistakes that will destroy your spreadsheet

Download the training notes

1(c)    Checklist - 21 Fatal formula fails

2.   Using ISERROR & IFERROR To Counter Formula Errors

3.   Error Tracing & Formula Auditing Tool Set

Paste Special

Download the training notes

1.    Paste Special - Step-by-step training notes

2.   Paste Special

Conditional Formatting

Download the training notes

1(a)    Conditional Formatting - Step-by-step training notes

Download the cheat sheet

1(b)    Cheat Sheet - Highlighting duplicates

Download the cheat sheet

1(c)    Cheat Sheet - Highlighting rows automatically using conditional formatting

2.   Conditional Formatting

Custom Views

Download the training notes

1.    Custom Views - Step-by-step training notes

2.   Creating & Applying Custom Views

3.   Custom Views - exercise - solutions


Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved