Just released Excel Tables comprehensive video. Have a look.
Download the sample file form here
Read all my articles about Excel Tables – these contain detailed instructions and lots of sample files.
The more I work with customers, the more I realize that data quality is still a very big problem. Data Validation in Excel is an effective solution to this problem. Here is a short guide for you. Reading time 12 min.
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.
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.
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?