Data visualization: Canva and Venngage 201

Skill:

Level:

    • Students will use a set of data points and data sets to build static and interactive graphics. We also will show how Flourish interfaces with Canva, since Canva now owns it.

    Canva-_-Venngage-ExercisesDownload

    More training on Design:

    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:

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

    • Business tools and investigating companies

    Learn how to scrape real-time and historical stock data from Google Finance into a Google Sheet and track it. It’s useful for anyone covering a specific industry or company.

    Skill:

    Level: