Improve Your Spreadsheet Skills

by Jack Dougherty, last updated March 1, 2017

Spreadsheets are wonderful tools to organize data into tables of rows and columns. With a spreadsheet, you can sort, filter, calculate, aggregate, and reorganize information to help you find the stories buried inside.

Four common spreadsheet tools:

Tool Features
Google Sheets Free, online collaborative spreadsheet on Google Drive. Requires free account.
Microsoft Excel Online Free online spreadsheet on Microsoft OneDrive. Requires free account. Cannot open CSV generic spreadsheet files.
Microsoft Excel desktop Not free (US $100+) spreadsheet for Mac or Windows desktop, as part of Microsoft Office.
LibreOffice Free, open-source alternative to Microsoft Office desktop. Donation requested during download.

Which spreadsheet tool should you use? That depends on how you wish to share and store data for your project.

  • If you are the only person working on a data project, use any spreadsheet tool.
  • If you need to protect private data, avoid online tools and use any desktop spreadsheet.
  • If you need to share live data with others, use Google Sheets.

This introductory online book features Google Sheets because it's a free and easy-to-learn tool for collaborating and sharing data with others. The basic spreadsheet methods shown here are very similar across all spreadsheet tools. But advanced users may need more complex tools to manage very large datasets, or relational databases, or to perform deeper analysis.

If you're new to spreadsheets or want to refresh your skills, see the following chapters:

Enroll in our free online course, which offers more spreadsheet exercises and opportunities to interact with instructors and other learners.

Data Visualization For All is copyrighted by Jack Dougherty and contributors and distributed under a Creative Commons Attribution-NonCommercial 4.0 International License. You may freely share and modify this content for non-commercial purposes, with a source credit to http://DataVizForAll.org.
Improve this book: Donate to DataViz students and add comments or revisions.

results matching ""

    No results matching ""