Data scraping web pages with Google sheets, scraping PDFs with Tabula and PDFtoExcel.com. Building graphics with Flourish.studio. Prior to the session, set up a free account at https://flourish.studio/ and also download free Tabula software here: https://tabula.technology/ Enroll here.
Google Fact-Check Explorer, Google Public Data Explorer, Google Trends, Google search shortcuts/advanced search), MapChecking.com for crowd size estimates, Google Earth Measure tool, Google Earth Engine Timelapse. Enroll here.
Google Earth Studio, Google Earth Pro, Google Earth Timelapse and Earth Measure Tool. Prior to the session, participants should create a free account at Google Earth Studio. Also: Download Google Earth Pro (download the link on the right side of the page, Earth Pro for Desktop). Enroll here.
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 […]
Is it OK to use this? Find out during a briefing with Tom Curley from our legal team. Jan. 11, 3 pm ET. Register here.
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 […]
Numbers gives us the facts, but images tell us the story. In this session, we'll show you how to create charts from your data, leverage Excel's suggestions, modify them to put the focus where you want it: Recommended Charts; Customizing Charts; Exploring Different Chart Types; Working with Chart Elements. Register here.
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: Pivot table Basics; 10 Pivot Tables in […]
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. Feb. 7, 1:30 pm ET. Register here.