(public).sospep.events ~ view task ~ CREATE-article-google-sheets-cheatsheet

ID/Title: 5302,CREATE-article-google-sheets-cheatsheet,

Description Task: LIST of common spreadsheet tasks with examples, references

Calendar: prj-025-sospep-content-data/plan-projects/CONTENT-Data

Added By: View Owner ON: 2015-06-17-14:29:07

Start Date: 2015-06-17

Start Time: 14:28:13

Estimated Duration: 01:00:00

Est. Completion Time: 2015-06-17-15:28:13

Status: To-Do

Priority: -5

<h1 style="text-align: center;">CREATE-article</h1>
<p style="text-align: center;">google sheets - cheat sheet</p>
<h2>[previously]</h2>
<ol>
<li><strong>] exporting a single column of values as csv</strong></li>
<ol>
<li>]</li>
</ol>
<li><strong>] vlookup function</strong></li>
<ol>
<li>] lookup the value of ... , in a named range of values,</li>
</ol>
<li><strong>] import a named range</strong></li>
<ol>
<li>] specify a name for the range which you want to import</li>
<li>]</li>
</ol>
<li><strong>] reference a value in another worksheet (same workbook)</strong></li>
<ol>
<li>] ='sheet name'!a3</li>
<li>*] note the quotes around the sheetname (not required if name has no spaces or non funky characters, ] exclamation point ] cell reference to the cell you want to reference</li>
</ol>
<li><strong>] reference a value in another workbook, another worksheet</strong></li>
<ol>
<li>] =</li>
</ol>
<li><strong>] importhtml</strong></li>
<ol>
<li>] get data from webpage tables or lists into your spreadshet</li>
</ol>
<li><strong>] formula</strong></li>
<ol>
<li>] =</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>]</li>
</ol>
<h2>[next]</h2>
<ol>
<li>[reference]</li>
<ol>
<li>] <a href="https://support.google.com/docs/table/25273?hl=en&amp;ref_topic=1361471" target="_blank">google spreadsheets functions list</a></li>
</ol></ol>

It appears there are no photos associated with this record

~ view task ~ TaskGroup] CONTENT-Data FROM [ Plan] plan-projects IN [ calendars] prj-025-sospep-content-data