The spreadsheet books bundle
Bought separately
Bundle Price

The spreadsheet books bundle

About the Bundle

Finding Stories in Spreadsheets deals with a variety of techniques and formulae for getting data to give you answers to your questions, while The Data Journalist Heist is all about getting a quick insight into data using pivot tables and filters. The two work together perfectly - and are available as a bundle for a discounted price

  • Share this bundle
  • Categories

    • Data Science
    • Textbooks
    • Non-Fiction
    • Education

About the Books

Finding Stories in Spreadsheets

Recipes for interviewing data - and getting answers
  • 863


  • 373


  • 103,687


  • PDF

  • EPUB

  • WEB

One spreadsheet can tell many stories. You just have to know the right questions to ask.

Based on a decade of training journalists and working with news organisations on data-driven stories, Finding Stories In Spreadsheets outlines the techniques for asking the right questions of data using tools like Excel and Google spreadsheets.

These aren't just questions about numbers: you'll find out how spreadsheet techniques can help you find the 'needle in the haystack' in text data. You'll learn how to clean up and modify your data so that you can ask it different questions, or get it ready for maps or charts, how to create new data from raw materials, and how to combine datasets to look for connections and trends.

With regular examples from journalism and real life data to work with, Finding Stories In Spreadsheets is *full* of those questions, in the language that spreadsheets understand. 

Cover image concept by @CarolineBeavon. Illustration by Matt Buck at Drawnalism.

Data Journalism Heist

How to get in, get the data, and get the story out - and make sure nobody gets hurt
  • 952


  • 43


  • 10,030


  • PDF

  • EPUB

  • WEB

Data journalism is a key skill for journalists to differentiate themselves in a world where almost anyone can publish, and competition for journalism jobs is fierce.

Whether it's hard stories from government spending and MPs' expenses, or softer stories from sports data, fashion trends or music and social activity, our increasingly digital world is providing a rich range of potential new story sources - and new forms of storytelling too.

This short ebook introduces you quickly to key techniques in finding that data and turning it into stories - through a 'Data Journalism Heist'.

This isn't about the huge investigative projects that you hear about, but the everyday stories that you can do with speed and simplicity. It's about getting in, getting the data, and getting the story out safely. No one gets hurt.

In the process you'll learn about:

  • Sources of data - where to find data stories and leads
  • Typical data stories - how to find simple stories in data
  • Basic spreadsheet techniques - finding the biggest and smallest values; calculating averages and totals.
  • Top techniques for getting stories against a deadline - using filters and pivot tables to get to the story quickly
  • Making a clean getaway - avoiding mistakes in data journalism
  • Telling the story - basic techniques in visualising and humanising your data-led story

As the book is published you'll receive regular updates as you build on previous skills towards the final story. User feedback, examples and ideas will be incorporated as they come in.

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $13 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub