All the data you need.

Tag: Excel

Spreadsheet esports
You’ve probably heard of esports, where people compete against each other in multiplayer…Tags: esports, Excel
Reading Data from Excel Files with Python
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 …
Charting software that pre-dating Excel
RJ Andrews digs up the PC archives of charting software. Scrolling through the…Tags: Excel, Microsoft, vintage
✚ How to Make Frequency Trails in Excel
Also known as ridgelines, use the method to create a compact visualization where you can easily identify major patterns and outliers.Tags: Excel
✚ How to Make Alluvial Diagrams
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
✚ How to Make Small Multiples in Excel
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
✚ How to make Marimekko Charts in Excel
Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables. Tags: Excel
✚ The Process 111 – Excel Limit
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
Excel spreadsheet limit leads to 16,000 Covid-19 cases left off daily count
Microsoft Excel is useful for many things, but it has its limitations (like…Tags: coronavirus, Excel, limitations
✚ How to Make a Heatmap in Excel
Heatmaps quickly translate data tables into a visual form, making them a great tool to explore a new dataset.Tags: Excel
✚ How to Make a Customized Excess Mortality Chart in Excel
Show current evolution against expected historical variability and add one or more series that could account for the difference.Tags: Excel
“Take On Me” by a-ha recreated in Excel
Dylan Tallchief recreated “Take On Me” by a-ha in Excel. It’s not the…Tags: a-ha, Excel, songs
✚ How to Make Difference Charts in Excel
Also known as a bivariate area chart, the plot type focuses on the comparison between two time series.Tags: Excel
Making stupid Excel bar charts
I’m just gonna put this right here, from @_daviant: “Another day another stupid…Tags: Excel, humor
3 Ways to Scrape Data from a Table
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…
Extract Data from Website to Excel Automatically
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,…
✚ How to Make a Dynamic Multi-population Pyramid in Excel
Create better population pyramids that allow for improved comparisons between sexes and populations.Tags: Excel
Excel vs Python: How to Do Common Data Analysis Tasks
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 …