Working on Spreadsheets/Presentations

At Wonder, we frequently get large projects where multiple analysts work on a Google Spreadsheet or Google Slides presentation simultaneously. The spreadsheet or presentation is then cited in the Introduction section of the Research report so the client can easily find its link.

In these types of projects, analysts are given specific instructions on which slides (for a presentation) and which rows, columns, and/or tabs (for a spreadsheet) to work on, and what information to provide in their designated sections.

Requirements for Spreadsheet/Presentation Projects

Follow the directions provided below when working on a spreadsheet/presentation project:

• [ ] Cite a link to the spreadsheet or presentation in the Introduction section as soon as you start working on the project. Put the deliverable on a bolded, separate row.
• [ ] Only work in your assigned rows, columns, tabs, or slides (as instructed in the Research Criteria).
• [ ] Sometimes, spreadsheet or presentation projects have very specific formatting and content instructions, including instructions for formatting within the cells/slides, writing numbers and adding sources, among others. These formatting parameters may be written in the Research Criteria, the spreadsheet/presentation, or both. Make sure you fully understand each instruction before beginning research or entering data.
• [ ] When working in spreadsheets or slide presentations, use citations in the form of hyperlinks, unless otherwise instructed in the Research Criteria. Check out this YouTube video on how to add multiple hyperlinks in a single cell in spreadsheets.
• [ ] Do not remove or duplicate another analyst’s work.
• [ ] If there are instructions or example rows/columns/tabs/slides provided in the spreadsheet/presentation, do not alter, edit, or remove them.
• [ ] Do not edit the title of the client’s spreadsheet or presentation.
• [ ] Click on a cell to type or paste information within it. Use the “paste special” and “paste values only” feature or the ctrl+shift+v shortcut when copy-pasting information. This retains the formatting of the spreadsheet/presentation.
• [ ] Do not add or delete columns, rows, or slides unless stated otherwise in the Research Criteria.
• [ ] Do not alter the spreadsheet/presentation formatting in any way, unless stated otherwise in the Research Criteria.
• [ ] If you remove your claim from the project after entering some information in the spreadsheet or presentation, remove the information you have entered before releasing the job. Take care to not delete another analyst’s work.
• [ ] When you create a spreadsheet yourself, make sure the header row is bolded and frozen.
• [ ] Use Arial font in 10 pt. size and black font color.