Tracy van der Schyff

Facilitating The Evolution of Human Capabilities


data cleanup

Day 33 – Removing duplicates in Excel

#Office365Challenge - Excel Removing Duplicates - As most of our data calculation, manipulation and reporting still happens in Excel, it might be necessary to check for and remove duplicates at times. Seeing as Excel can have over a 1,000,000 rows... Continue Reading →

The lighter side of Microsoft #1: Excel functions – fixing capitalization & removing duplicates:

The reason for starting to write this blog is that I’ve come to the realization that there are millions of people out there – not using Microsoft Office to its full potential. I give SharePoint training, as well as build... Continue Reading →

Up ↑