NH Blog - Articles on data

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 [...]

top
Back to top