Analyzing batches of PDFs Skill: Level: Investigative Intermediate Learn tools and techniques for working with data buried in PDF files. Python experience is recommended. Download the presentationDownload More training on Investigative: Google Earth Studio Learn how to use Google Earth Studio, Google Earth Pro, Google Earth Timelapse and Earth Measure Tool with training by author and data journalism expert Mike Reilley. Skill: Level: Investigative All Levels Reporting & Writing All Levels Microsoft Excel 05 – What if The more data you have, the more questions you will have about it, and the more answers it can provide. Excel has a variety of conditional formulas that let you evaluate subsets of your data to find the stories to tell: If…Then formulas; Conditional Functions; XLOOKUP; Array Functions. Skill: Level: Investigative Intermediate Reporting & Writing Beginner Foundations of data journalism – Scraping Data scraping web pages with Google sheets, scraping PDFs with Tabula and PDFtoExcel. Build graphics with Flourish Studio. We’ll also explore how to scrape data from a photograph using Excel. Skill: Level: Investigative Beginner Microsoft Excel 04 — Pivot tables Pivot table are the simple solution for some, and a rare kind of magic to others. In this session, we’ll demystify pivot tables and show you how you can use them to simplify your analysis and give you more options than ever in how you extract your story. Skill: Level: Investigative Beginner Reporting & Writing Expert