In this session we’ll start at A1 and introduce you to the basics of Excel, how it’s structured, and how to get around in it. We’ll show you how you can start using formulas to take Excel beyond just a list of stuff.
- What is a spreadsheet?
- Worksheets vs tabs
- Columns vs Rows
- Simple Formulas
- Simple Sorting
- Turning Data Sets into Tables
More training on Reporting & Writing:
Google tools for journalists
Google Fact-Check Explorer, Google Public Data Explorer, Google Trends, Google search shortcuts/advanced search), MapChecking for crowd size estimates, PhantomBuster, VisualPing for tracking website updates and other cool tools and hacks.
Microsoft 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.
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.
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.