The 5 Minute Guide to Using Excel Pivot Tables

The 5 Minute Guide to Using Excel Pivot Tables

Microsoft Excel is used by many professionals in day-to-day business for data management and reporting. Today we have a mass of data that is often difficult to analyze or understand which is why we use Excel’s reporting tools to create simple visual representations of large data sets.  Enter Pivot Tables, one of Microsoft Excel’s most…

VLookup – What It Is and How You Can Use It to Free Up More of Your Time This Week

VLookup – What It Is and How You Can Use It to Free Up More of Your Time This Week

Microsoft Excel allows you to organise large sets of data in a way that is simple and streamlined. You can organise just about anything from inventories and stock counts to customer details or an employee’s progress in learning and development. But a clean, pretty spreadsheet means nothing if you can’t go back and look up…

4 Simple Excel Hacks That Will Free Up More of Your Time This Week

4 Simple Excel Hacks That Will Free Up More of Your Time This Week

We’ve all been a beginner at something, whether it be data management, sales, gardening or learning to play the drums. Just like any skill, Excel takes practice and the more you use it the more accustomed you become with the programme, and the more stumbling blocks you will inevitably face.  If you are reading this…