×

Author: Cynthia Benjamin

Business tools and investigating companies

Skill:

Level:

    • Business-Coverage-Tools-1Download

    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.

    Skill:

    Level:

    • 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.

    Skill:

    Level:

    • 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:

    • 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:

    • Investigating Nonprofits

    Skill:

    Level:

    • Learn how to read a Form 990 and where/how to go about obtaining these documents to track how money flows through non-profit organizations. We’ll also look at other tools for researching charities and also government agencies that investigate them. 

    Business-Coverage-ToolsDownload

    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.

    Skill:

    Level:

    • 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.

    Skill:

    Level:

    • 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:

    • 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:

    • Microsoft Excel 02 – Fill it out

    Skill:

    Level:

    • Adding data to Excel is how you start building a spreadsheet. In this session, we’ll explore how Excel helps you add data in a flash. We’ll explore new data types that pull information from the internet and help you spot the important stuff at a glance: Conditional Formatting; Auto Fill; Flash Fill; Geography and Stock Data Types; Leveraging Tables for Expanding Data Sets  

    Class-Workbook-Excel-01-1Download

    Keyboard shortcuts in Excel: Here’s the link. 

    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.

    Skill:

    Level:

    • 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.

    Skill:

    Level:

    • 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:

    • 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: