Also known as trellis charts, lattice chart, or whatever you want to call them, the technique lets you compare several categories in one view.Tags: Excel
Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables. Tags: Excel
Nov. 12, 2020, 11:22 a.m.
A row limit in Microsoft Excel led to an undercount of Covid-19 cases in the thousands. The root of the problem goes past the software though.Tags: Excel, limitations
Microsoft Excel is useful for many things, but it has its limitations (like…Tags: coronavirus, Excel, limitations
Heatmaps quickly translate data tables into a visual form, making them a great tool to explore a new dataset.Tags: Excel
Sept. 29, 2020, 5:45 p.m.
Show current evolution against expected historical variability and add one or more series that could account for the difference.Tags: Excel
Dylan Tallchief recreated “Take On Me” by a-ha in Excel. It’s not the…Tags: a-ha, Excel, songs
June 19, 2020, 11:04 a.m.
Also known as a bivariate area chart, the plot type focuses on the comparison between two time series.Tags: Excel
I’m just gonna put this right here, from @_daviant: “Another day another stupid…Tags: Excel, humor
There is a lot of data presented in a table format inside the web pages. However, it could be quite difficult when you try to store the data into local computers for later access. The problem would be…
March 31, 2020, 2:32 a.m.
To extract data from websites, you can take advantage of data extraction tools like Octoparse. These tools can pull data from websites automatically and save them into many formats such as Excel,…
March 23, 2020, 4:17 a.m.
Create better population pyramids that allow for improved comparisons between sexes and populations.Tags: Excel
In this tutorial, we’ll compare Excel and Python by looking at how to perform basic analysis tasks across both platforms. Excel is the most commonly used data analysis software in the world. Why? It’s easy to get the hang of and fairly powerful once you master it. In contrast, Python’s …
Easily compare multiple categories and spot differences between two or more series.Tags: Excel
For Datawrapper, Lisa Charlotte Rost outlines the steps to prepare and clean your…Tags: cleaning, Excel, spreadsheet
Oct. 24, 2019, 10:03 a.m.
Pythons xlwings is a tool that allows you to use Python code to control and analyze data in Excel spreadsheets. This tutorial will help you get started. The post xlwings Tutorial: Make Excel Faster Using Python appeared first on Dataquest.
Predictions for the World Cup 2018
R for Excel Users
Feb. 14, 2017, 12:02 p.m.