Excel

12 posts
✚ 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. Read More

0 0
“Take On Me” by a-ha recreated in Excel

Dylan Tallchief recreated “Take On Me” by a-ha in Excel. It’s not the tools. It’s how you use them. Something something blah blah. It’s in Excel! Tags: a-ha, Excel, songs

0 0
✚ 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. Read More

0 0
Making stupid Excel bar charts

I’m just gonna put this right here, from @_daviant: “Another day another stupid Excel chart”. Tags: Excel, humor

0 0
✚ How to Make a Multi-Series Dot Plot in Excel

Easily compare multiple categories and spot differences between two or more series. Read More

0 0
Cleaning your data with Excel and Google Spreadsheets

For Datawrapper, Lisa Charlotte Rost outlines the steps to prepare and clean your data in Excel or Google Spreadsheets. From the beginning: When you download an Excel file, it often has multiple sheets. Our data set has three of them, as seen on the bottom: “Data”, “Metadata – Countries” and “Metadata – Indicators”. Look through all of your sheets and make sure you understand what you’re seeing there. Do the...

0 0
R data structures for Excel users

Introducing yourself to R as an Excel user can be tricky, especially when you don’t have much programming experience. It requires that you switch from one mental model of the data that exists in an interactive spreadsheet to one that exists in vectors and lists. Steph de Silva provides a translation of these data structures for Excel users. Tags: Excel, R

0 0
Microsoft Excel painter

Remember the artist Tatsuo Horiuchi who uses Microsoft Excel to paint scenery? Four years later, he’s still at it. Watch below. Horiuchi is my favorite example of someone who shows that the tool is secondary to what you want to make. Spend less time debating about what software you should use to visualize your data, and spend more time deciding what you want to show. Tags: Excel, paintings, tools

0 0
Data distributed as clipart

Government data isn’t always the easiest to use with computers. Maybe it’s in PDF format. Maybe you have to go through a roundabout interface. Maybe you have to manually request files through an email address that may or may not work. However, this file that OpenElections received might take the cake. It’s a spreadsheet, but the numbers are clipart. City of Detroit produced a lookup tables for its absentee precincts...

0 0
R for Excel users

For Excel users getting started with R, pain oftentimes finds its way into the learning process. Gordon Shotwell feels your pain and provides a primer to shifting to a different approach to your data. At the beginning, when you are trying to accomplish simple things like balancing a budget or entering some data by hand, R is definitely harder to learn than Excel. However, as the task gets more complex,...

0 0