

May 18, 2021
Find a filter result without filtering in Excel
You may remember a previous blog post of mine about advanced filters previously. I recently had a student in one of our Excel Courses who was interested in filtering and [...]


Jan 12, 2021
Normalising your database: Second Normal Form (2NF) - Part 2
In the first part of the series, we looked at normalising into first normal form (1NF). In this article, the second part of the 3-part series, we focus on second normal [...]


Dec 02, 2020
Using the 'Flash Fill' feature to apply the desired formatting in Excel 2013
Excel 2013 has the wonderful new feature called Flash Fill. This feature allows the user to split and combine text string as well as format the split or combined text [...]


Sep 26, 2020
Dynamic charts in Microsoft Excel
Charts in Microsoft Excel are a great way of representing data graphically, but sometimes that data is subject to change and when it does change, we need our charts to [...]


Sep 04, 2020
Create an advanced filter in Excel
Filtering is a common task in Microsoft Excel and the normal filtering (the ‘autofilter’) can do quite a lot of what you will need. However, there are some filters that [...]


Aug 21, 2020
Dress up and present your data with Power View
Power View is a feature of Microsoft Excel 2013 that allows you to create stunning interactive visual presentations of data from multiple sources. In this tutorial we [...]


Jul 25, 2020
Remove excess spaces from data in Microsoft Excel
When data is imported into Excel, excess characters sometimes come with it. Non-printing characters are the hardest to detect as they are, of course, invisible. Spaces [...]


Jul 03, 2020
Combine MATCH and INDEX in Excel for a powerful tool
If you have used Excel for comparisons, reconciliations, validations or have attended our Microsoft Excel Level 2 course, you will have encountered "VLOOKUP" before. [...]


Jun 26, 2020
Data Quality in SQL Server 2014 for dummies (Part 2)
In my last blog post, we had a mini crash course on data quality and the three elements essential to data quality - knowledge base, domain, and Reference Data Service [...]


May 19, 2021
Use slicers to filter table data in Microsoft Excel
Slicers were first introduced in Excel 2010 and gave us a nice easy way of filtering PivotTable data. Instead of the typical drop-down list filtering in Excel, slicers [...]


Mar 03, 2021
A Closer Look at Excel PowerPivot and Power View
I'm sure that we can all agree that Microsoft Excel is an incredible application. You can do so much with it, but broadly speaking, there are 3 main functions that Excel [...]