In this article, we'll show you an easy way to align y-axis labels in Excel charts and Microsoft applications. It's a simple but important step to make sure your data visualizations are clear and accurate.
Read More
While traditional bar charts are both straightforward and powerful for data representation, there are instances when we seek innovative alternatives to breathe new life into our reports. Enter the lollipop chart. Learn how to develop them in Excel here.
Read More
Want visuals that best express your data story? Here are some ideas to clean up those charts and help make them pop.
Read More
This article walks you step-by-step through the process we use when merging datasets from multiple sources.
Read More
Chart templates will alleviate the pains of trying to reformat every new chart from scratch. From adjusting text size and font to formatting bar width and colour, a template will save you a significant amount of time in drafting your next evaluation report.
Read More
Here, I share solutions to two challenges you are likely to come across while entering survey data: 1) coding complex question types and 2) dealing with unclear responses. Addressing these challenges will require some advanced coding that I did not cover in my first article.
Read More
When entering survey data, it is important that it is accurate, easy to analyze, and fast. Use these tips to prevent mistakes from the beginning.
Read More
The most exciting part about conducting a survey is seeing the results – finally your hard work has come to fruition, and you get to hear what everybody had to say! But before you can get to that step, you need to transform the stack of paper surveys on your desk into useable data.
In this article, I share my three-step system for making survey data entry as easy and painless as possible, which comes from my experience designing, entering, and analyzing survey data.
Read More