Tag Archives: Data Entry

SharePoint Part 13 – Field Staff Management

Share data from Head Office to field staff or vice versa. All using the powerful List feature of SharePoint. Zero Programming. Anyone can do it in minutes. Try it and apply it to your needs.

These videos were created in 2013. Therefore the logos and screenshots depict older versions of products. However the concepts – which are more important – are still valid.

Bad Data to Good Data: Fill gaps using Power Query

This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data which has gaps and how to fill gaps efficiently. This is a new approach available using Power Query – it is fast and effective. Have a look and save hours of your precious time.

fill gaps in data using Power Query

Continue reading Bad Data to Good Data: Fill gaps using Power Query

Good Data vs. Bad Data: How to identify?

This article shows you simple and immediately usable methods of understanding whether the data you have is good or bad.

This article has intentionally been kept short and to the point so that it is practically usable as a set of best practices.

A more detailed version of this article is being written by an expert in the field, which will be also be published as a guest post soon.
Continue reading Good Data vs. Bad Data: How to identify?