Office Mastery | Latest Posts | Two Rivers Software Training
Automatic vs manual calculations in Excel

#028 | Automatic vs Manual Calculations In Excel

​Advanced users of large Excel spreadsheets can benefit from switching the default automatic calculations to manual calculations.

Useful ALT codes you can use in Excel to get special characters and symbols, such as the degree symbol, copyright, fractions and the diacritical letters (non-english letters)

#026 | Useful Alt codes to insert special characters

Alt codes allow special characters like the pound sign, copyright symbol, fractions and diacritical (non-English) characters to be added.​

Sorting - Everything you need to know

#025 | Sorting in Excel: The Ultimate Guide

What is the secret to sorting data in Excel effectively? Discover how to sort rows using value, colour, icon or custom sequence or rearrange columns​

How To Highlight Particular Excel Rows (Automatically) Using Conditional Formatting Formulas

#024 | Conditional Formatting Formulas That Highlight Entire Data Rows Automatically

Conditional Formatting is versatile. When a condition is true, a format is applied. Using conditional formatting formulas hands you complete control.​

How to create a custom date format

#023 | How To Create Your Own Custom Date Format In Excel

Creating a custom date format in Excel is easy and lets you get away from bog-standard date formats like dd/mm/yyyy. Find out how.​

Goal Seek: Reverse Engineering For Excel

#022 | Goal Seek: Reverse Engineer An Answer

​Goal Seek is a simple tool that finds the exact input value required to generate the answer you have specified.

VLOOKUP is used to find a match in a database and return a selected detail

#021 | VLOOKUP: The Ultimate Guide

Having problems with VLOOKUP formulas? Discover how to create them from scratch the right way, every time.​

3D Formulas: The Smart Way To Do Cross-Sheet Formulas

​#020 | 3D Formulas: The Smart Way To Do Cross-Sheet Formulas

3D formulas are simpler, take less time to create than regular formulas and are less prone to errors. What's not to like?​

Degree Symbol: 3 Ways To Insert Degrees Into Excel Spreadsheets

​#019 | Degree Symbol: 3 Ways To Insert Degrees Into Excel Spreadsheets

Discover 3 ways to insert a degree symbol into an Excel spreadsheet - using the built-in character sets and using superscript.​

21 major formula fails and how to fix them

#018 | 21 Major Formula Fails & How To Fix Them

​Identify, fix and avoid the most common formula errors on an Excel spreadsheet. Finally, put your formula headaches to bed.

How to identify then remove duplicates in Excel

#017 | Managing Duplicates in Excel

​Duplicates creep into any large Excel list. Here we explain how to (a) highlight duplicates, then (b) remove duplicates leaving just the unique items.

3 ways to calculate averages in Excel

#016 | 3 Easy Ways To Calculate Averages In Excel

​Average values are easy to work out in Excel. The Average, Mode and Median functions provide 3 ways. The AVERAGE function is the simplest and most common

How to remove the gridlines on a spreadsheet so you get a nice clean, professional finish

#015 | Hide Gridlines (On Spreadsheets) For a Clean Finish

​Hide Gridlines to apply a clean, crisp finishing touch to your spreadsheet. Gridlines are great while designing, but hide them when done to remove clutter.

Worksheet Tab Navigation – A Rare Expert Tip

#014 | Worksheet Tab Navigation – A Rare Expert Tip

​Worksheet tabs can be renamed, reordered and navigated, but it's painful to scroll through lots of tabs. If that's you, you'll love this quick tip.

How Many Rows & Columns Does Excel Have?

#013 | How Many Rows & Columns Does Excel Have?

​To discover how many rows and columns are available, there is a quick shortcut. Advanced users may also want to switch calculations from auto to manual.



​COUNT is different to SUM. This post explains why then goes beyond the basics revealing the different types of data that can be counted.

Merge and Centre: A Better Alternative

#011 | Merge and Centre: A Better Alternative

​Using Merge and Centre in Excel can cause many problems. This little gem is a fantastic alternative with no known side effects!

How to calculate percentages in Excel

#010 | How to Calculate a Percentage in Excel: A Comprehensive Guide

​Percentages in Excel are easy once you understand the simple maths behind them. Discover for yourself how to calculate percentage in Excel.

How to add a leading zero to a number

#009 | How to keep leading zeroes in Excel

​When you type a number with leading zeros, e.g. 00123, Excel drops the leading zeros as soon as you press Enter ... unless you do this ...

How to manipulate text and clean up your data like a pro

#008 | How to Manipulate Text and Clean Up Your Data Like a Pro

​With text functions you can manipulate text in Excel however you want. Trimming, searching, concatenating, extracting certain parts - Excel has it all

Drop down lists: Functional and Awesome

#007 | DropDown Lists: Functional & Awesome

​Drop down lists in Excel are functional and useful, But best of all it makes you look good! It also improves the accuracy of data and is easy to set up.

How to find the biggest or smallest number in a range

#006 | Finding the biggest number or smallest number

​Picking out the biggest number or the smallest number from a range of cells in Excel is super easy. Here's how.

Excel formulas quick start guide for beginners

​#002 | Formulas Quick Start Part 1 of 4: How To Get Started

#003 | Formulas Quick Start Part 2 of 4: SUM & AUTOSUM​

#004 | Formulas Quick Start Part 3 of 4: AVERAGE, MAX, MIN and COUNT

#005 | Formulas Quick Start Part 4 of 4: Order Of Operations​

Excel formulas are easy with a little bit of guidance. In this free 4 part blog guide, discover how to build Excel formulas the right way, step-by-step and without errors.​

3 Simple Productivity Tips For Getting Your Butt In Gear

​#001 | 3 Simple Productivity Tips For Getting Your Butt In Gear

Are you a perfectionist? Do you too suffer from paralysis by analysis? Stop overthinking and get your butt in gear with these productivity tips.​

David Friederick

I was pulling my hair out!

Wow, that was way too easy! You are the man! I've been pulling my hair out for weeks trying to figure this out. Thank you!

Mhlanga Mlungisi

Clearest Demo I've Seen

You went beyond the obvious and provided the clearest demonstrations & explanations for a number of key things that were bugging me.

Bettina St John

Fantastic, precise and simple

Fantastic, precise and simple explanations for a number of things I have been struggling with for years. Thanks heaps.

30 Excel Power Tips


Discover the shortcuts and tricks used by the pros

Copyright © Two Rivers Software Training. All Rights Reserved.

Like us on facebook Follow us on Twitter Watch us on YouTube Connect with Jason on LinkedIn