You’ve probably heard of esports, where people compete against each other in multiplayer…Tags: esports, Excel
Microsoft Excel is one of the most powerful spreadsheet software applications in the world, and it has become critical in all business processes. Companies across the world, both big and small, are using Microsoft Excel to store, organize, analyze, and visualize data. As a data professional, when you combine Python …
RJ Andrews digs up the PC archives of charting software. Scrolling through the…Tags: Excel, Microsoft, vintage
Also known as ridgelines, use the method to create a compact visualization where you can easily identify major patterns and outliers.Tags: Excel
Here's how to do it in R from start to finish, plus editing in illustration software. Make design choices and trade-offs for more readable charts.Tags: color, Excel, Illustrator, layout, R
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 …