Office Mastery | The Official Blog of Two Rivers Software Training
Assign a 'primary' menu
Office Mastery

HELPING YOU BECOME
CONFIDENT, FEARLESS AND TOTALLY AWESOME
WITH MICROSOFT OFFICE

 30 Excel Power Tools The Experts Didn't Want You To Know!

Start Here

GETTING STARTED / REFRESHER

​

Excel formulas quick start guide for beginners

Formulas Quick Start Guide For Beginners

3 ways to calculate averages in Excel

3 Easy Ways To Calculate Averages In Excel

21 major formula fails and how to fix them

21 Major Formula Fails & How To Fix Them

EXCEL FORMULAS

​

How to calculate percentages in Excel

How to Calculate a Percentage in Excel

COUNT vs SUM vs COUNTA vs COUNTBLANK vs COUNTIF

COUNT vs SUM vs COUNTA vs COUNTBLANK vs COUNTIF

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

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

COOL FEATURES

​

How to add a leading zero to a number

How to keep leading zeroes in Excel

Sorting - Everything you need to know

Sorting in Excel: The Ultimate Guide

Drop down lists: Functional and Awesome

DropDown Lists: Functional & Awesome

TOP END / EXPERT 

​

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

VLOOKUP: The Ultimate Guide

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

Conditional Formatting Formulas That Highlight Entire Data Rows Automatically

Goal Seek: Reverse Engineering For Excel

Goal Seek: Reverse Engineer An Answer

Office Mastery is the digital arm and official blog of Two Rivers Software Training
Copyright © Two Rivers Software Training. All Rights Reserved Privacy Terms Contact
Like us on facebook Watch us on YouTube Connect with Jason on LinkedIn
>