Difference between revisions of "Office Productivity Hacks"

From TeleCafeWiki
Jump to navigation Jump to search
(Added SharePoint section.)
m (Added Additional Resource Wiki Pages Template.)
 
(87 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{RightTOC}}
 
{{RightTOC}}
 +
== Cloud Storage & File Sharing Platforms ==
 +
* [https://beebom.com/google-drive-alternatives/ Google Drive Alternatives: 10 Best Cloud Storage Services] | November 11, 2017
 +
: Services described include: Dropbox, Tresorit, pCloud, OneDrive, Sync.com, Box, Mega, SpiderOak One, Backblaze, Jottacloud.
 +
 +
* [https://alternativeto.net/software/google-drive/ Google Drive Alternatives and Similar Software] - AlternativeTo.net
 +
: '''Q:''' What's in this list?
 +
: '''A:''' Alternatives to Google Drive for Web, Windows, Mac, iPhone, Android and more. Filter by license to discover only free or Open Source alternatives. This list contains a total of 183 apps similar to Google Drive.
 +
 +
* [http://www.cyberciti.biz/cloud-computing/7-awesome-open-source-cloud-storage-software-for-your-privacy-and-security/ 7 Awesome Open Source Cloud Storage Software For Your Privacy and Security]
 +
: Learn about seven "amazingly awesome open source cloud storage engines that you can use to access and sync your data privately for security and privacy reasons."
 +
 +
* [https://destructible.io/ Destructible.io]: Self-destructing, human-readable file storage.
 +
: Upload a file, set time to self-destruct. Download as many times as you'd like from a page with a url that's easy to read and say. That's it!
 +
 +
* [https://owncloud.org/ ownCloud]
 +
: Access your data from all your devices, on an open platform you can extend and modify.
 +
 +
* [https://pyd.io/ Pydio] - Master Your Universe of Files
 +
: Pydio (formerly AjaXplorer) is a mature open source software solution for file sharing and synchronization.
 +
 +
* [https://snapdrop.net/ Snapdrop]
 +
: Snapdrop is an easy way to transfer files. Instantly share images, video, PDF, and links across devices. Peer2Peer, Private, Secure and Open Source. No Setup, No Signup.
 +
 +
* [http://sparkleshare.org/ SparkleShare]
 +
: File synchronisation. Version control. Self hosted. Client side encryption. Free and Open Source.
 +
 +
* [https://wetransfer.com/ WeTransfer]
 +
: Provide a send-to email address, your email address, include a brief note then upload file and send.
 +
:: [[User:Dave|Editor]]'s Note: Used this service to send photos and video of technical issues to scanner manufacturer.
 +
 
== Google Apps ==
 
== Google Apps ==
 +
* [http://www.techrepublic.com/article/six-tips-for-supporting-successful-meetings-with-google-apps/ Six tips for supporting successful meetings with Google Apps]
 +
# Create a Google Doc for each meeting
 +
# Move the document to the right folder(s)
 +
# Share the document with participants
 +
# Create Calendar event: Invite guests and attach document(s)
 +
# Edit during the meeting
 +
# Share the document link after the meeting
 +
 +
;Keyboard Shortcuts
 
* [http://webapps.stackexchange.com/questions/4672/a-faster-way-to-access-strikethrough-on-google-docs A faster way to access Strikethrough on Google Docs]
 
* [http://webapps.stackexchange.com/questions/4672/a-faster-way-to-access-strikethrough-on-google-docs A faster way to access Strikethrough on Google Docs]
 
: Select what you want to strike and click <code>Alt+Shift+5</code>. (<code>Option+Shift+5</code> for Mac).
 
: Select what you want to strike and click <code>Alt+Shift+5</code>. (<code>Option+Shift+5</code> for Mac).
Line 6: Line 45:
  
 
* [https://support.google.com/drive/answer/179738?hl=en Keyboard shortcuts for Google documents]
 
* [https://support.google.com/drive/answer/179738?hl=en Keyboard shortcuts for Google documents]
 +
 +
==== Google Apps | 3rd Party Resources ====
 +
* [http://fastdocs.co/ FastDocs ⚡: Shortcuts to create new Google Docs]
 +
: Direct links to create new documents for Google Apps.
 +
 +
=== Google App Engine ===
 +
* [http://24ways.org/2008/using-google-app-engine-as-your-own-cdn/ Using Google App Engine as Your Own Content Delivery Network]
 +
: A content delivery network, or CDN, is a system of servers spread around the world, serving files from the nearest physical location. Instead of waiting for a file to find its way from a server farm in Silicon Valley 8,000 kilometres away, I can receive it from London, Dublin, or Paris, cutting down the time I wait. The big names — Google, Yahoo, Amazon, et al — use CDNs for their sites, but they’ve always been far too expensive for us mere mortals. Until now.
 +
 +
=== Google Mail Merge ===
 +
; Yet Another Mail Merge
 +
* [https://chrome.google.com/webstore/detail/yet-another-mail-merge/mgmgmhkohaenhokbdnlpcljckbhpbmef Yet Another Mail Merge] (Installation script.)
 +
* [https://sites.google.com/site/scriptsexamples/available-web-apps/mail-merge Yet Another Mail Merge] (App web page.)
 +
* [https://docs.google.com/a/evolvnet.com/document/d/114E9ovPQZlu3Pcyv_GMuaV9r_KfL6fzIc295eFaWg1U/edit Yet Another Mail Merge (YAMM) - FAQ]
 +
* [https://www.youtube.com/watch?v=B6Ehz2i6eU4 Create a Mail Merge with Gmail and Google Drive / Docs] (Video tutorial for using Yet Another Mail Merge.)
  
 
=== Google Drive ===
 
=== Google Drive ===
 
* [http://www.editey.com Editey: Edit Websites on Google Drive]
 
* [http://www.editey.com Editey: Edit Websites on Google Drive]
 +
 +
=== Google Docs ===
 +
==== Add Page Numbers, Footer Info, Etc. ====
 +
* [https://support.google.com/docs/answer/86629 Add footnotes, page numbers, headers & footers]
 +
: Want page number & count (eg: <tt>Page 2 of 4</tt>)?
 +
::- <tt>Insert > Page number</tt> to insert a page number.
 +
::- <tt>Insert > Page count</tt> to get the count of number of pages in document.
 +
 +
==== Link to Section Heading ====
 +
# Select the text you want to link from.
 +
# Insert > Link
 +
# Click on the little pointer (triangle) to the left of "Headings".
 +
# Select the Heading you want to link to.
 +
# Click the "Apply" button.
 +
 +
=== Google Sites ===
 +
* [https://productforums.google.com/forum/#!topic/sites/7xUZQZF9WcE Can I create a password protected area for my site? ie a "members only" section]
 +
:- [https://productforums.google.com/forum/#!profile/sites/APn2wQdUxgOXdV0q-4Kp5lEyPwEi3pZocC9rp2-YOAPKyYF9KnjNEWE3DEkLtq_LUl5PNFpHVutn k8oms]: Yes, you can create a separate member's only site, make it private, invite your members as viewers and link to it from your main site.
 +
:- [https://productforums.google.com/forum/#!profile/sites/APn2wQdUxgOXdV0q-4Kp5lEyPwEi3pZocC9rp2-YOAPKyYF9KnjNEWE3DEkLtq_LUl5PNFpHVutn k8oms]: You could (also) invite a Google Group to the site. All of your members would have to join the group. They would have to have Google accounts in order to join.
  
 
=== Google Voice ===
 
=== Google Voice ===
Line 14: Line 87:
 
: Instead of having to send out a conference number and access code to people calling in, you can now just ask them to call you at a preset time and you can conference them in as they call.
 
: Instead of having to send out a conference number and access code to people calling in, you can now just ask them to call you at a preset time and you can conference them in as they call.
  
=== Mail Merge ===
+
== LibreOffice ==
; Yet Another Mail Merge
+
=== LibreOffice in the Cloud ===
* [https://chrome.google.com/webstore/detail/yet-another-mail-merge/mgmgmhkohaenhokbdnlpcljckbhpbmef Yet Another Mail Merge] (Installation script.)
+
* [https://www.collaboraoffice.com/solutions/collabora-cloudsuite/ Collabora CloudSuite]
* [https://sites.google.com/site/scriptsexamples/available-web-apps/mail-merge Yet Another Mail Merge] (App web page.)
+
: Collabora CloudSuite is a powerful LibreOffice-based office suite that works across platforms and devices. It enables you to access documents from any location, author new content, and share your work.
* [https://docs.google.com/a/evolvnet.com/document/d/114E9ovPQZlu3Pcyv_GMuaV9r_KfL6fzIc295eFaWg1U/edit Yet Another Mail Merge (YAMM) - FAQ]
+
:: [https://www.collaboraoffice.com/try-collabora-cloudsuite/ Request a Free Demo].
* [https://www.youtube.com/watch?v=B6Ehz2i6eU4 Create a Mail Merge with Gmail and Google Drive / Docs] (Video tutorial for using Yet Another Mail Merge.)
+
 
 +
* [https://www.collaboraoffice.com/press-releases/collabora-productivity-releases-collabora-online-cool-1-0-engine-for-hosters-and-clouds/ Collabora Productivity releases Collabora Online 1.0 “Engine” for Hosters and Clouds.] (Cambridge – 2 June 2016)
 +
: Collabora Productivity, the driving force behind putting LibreOffice in the Cloud, has released the first production grade version of Collabora Online, its flagship cloud document suite solution.
 +
 
 +
* [https://owncloud.org/blog/libreoffice-online-has-arrived-in-owncloud/ Collabora brings LibreOffice Online to ownCloud]
 +
 
 +
* [https://www.collaboraoffice.com/code/ Collabora Online Development Edition (CODE)]
 +
: CODE is the unsupported, Development version of Collabora CloudSuite‘s commercial on-line component. It makes things easy for you to play with the latest unstable developments – of course at some risk of loosing your data, and with no strong upgrade or continuity guarantees. If it breaks – you get to keep both halves.
 +
 
 +
* [http://www.zdnet.com/article/libreoffice-finally-to-go-online/ LibreOffice finally to go online]
 +
: It's been years since The Document Foundation announced that LibreOffice would be ported to an online version. It looks like it will finally arrive... in 2016.
 +
 
 +
=== Regular Expressions &amp; LibreOffice ===
 +
;Important Reminder When Working with Regular Expressions in LibreOffice<nowiki>:</nowiki>
 +
''With the <tt>Find &amp; Replace</tt> window open, make sure to click on the "<tt>+</tt>" icon next to "<tt>Other Options</tt>" and check the "<tt>Regular expressions</tt>" tic box.''
 +
 
 +
* [http://ask.libreoffice.org/en/question/3122/find-replace-doesnt-find-paragraph-marks/ Find & Replace doesn't find paragraph marks]
 +
: Do you want to add a blank paragraph after of each non-empty paragraph? Find <code>.$</code> (dot-dollar) Replace with <code>&\n</code> (ampersand-backslash-n).
 +
 
 +
* [http://ask.libreoffice.org/en/question/1491/findreplace-not-recognizing-t-for-tabs/ Find/replace not recognizing \t for tabs]
 +
: You need to click on the More Options button (bottom of Find & Replace dialog) and check the Regular Expressions box since \t is a regex code.
  
 
== Keyboard Shortcuts ==
 
== Keyboard Shortcuts ==
Line 25: Line 118:
 
: ShortcutWorld.com is an open, wiki-style Reference Database for Keyboard Shortcuts. Created and edited by Users like You.
 
: ShortcutWorld.com is an open, wiki-style Reference Database for Keyboard Shortcuts. Created and edited by Users like You.
  
=== MS Word ===
+
== Microsoft Office ==
* Key command for inserting non-updating date:
+
=== Embed Excel Data in Word ===
 +
* [https://support.office.com/en-in/article/Copy-Excel-data-or-charts-to-Word-35f668e8-671a-4b78-b064-7a4ca61250d4 Copy Excel data or charts to Word]
 +
* [http://www.excel-easy.com/examples/embed.html Embed]
 +
: Embed an Excel worksheet in a Word document and work with Excel in Word. You can also embed files in Excel.
 +
 
 +
=== Linking Data Between Files ===
 +
* [http://wordprocessing.about.com/od/wordquicktips/qt/linktext.htm Automatically Update Text in Many Documents]
 +
* [http://www.k2e.com/tech-update/tips/158-linking-excel-data-into-word-documents Linking Excel Data Into Word Documents]
 +
* [http://answers.microsoft.com/en-us/office/forum/office_2007-office_other/inserting-linked-excel-spreadsheet-into-publisher/40745746-5815-4d96-ad32-bb318c9444d6?auth=1 inserting linked excel spreadsheet into publisher]
 +
 
 +
=== Microsoft Outlook ===
 +
* [http://www.techrepublic.com/blog/microsoft-office/five-ways-to-add-a-note-to-an-outlook-email-message/ Five ways to add a note to an Outlook email message]
 +
: Annotating an Outlook message or thread requires a creative approach. Here are a few easy ways to add meaningful notes to your Outlook messages.
 +
 
 +
=== Microsoft Word ===
 +
* [http://word.tips.net/T001733_Centering_a_Table.html Centering a Table]
 +
* [http://wiki.smartsimple.com/wiki/Adding_Form_Fields_to_a_MS_Word_Document Adding Form Fields to a MS Word Document]
 +
: ''For MS Word 2007'':
 +
# Click on the Menu button and select Word Options.
 +
# In the Popular section, select Show Developer Tab in the Ribbon, then click "OK".
 +
# Click in your Word document wherever you wish to insert a Form Field.
 +
# On the Developer Menu select the Legacy Tools icon which is in the Controls section.
 +
# On the Legacy Forms menu click the first icon to insert a Form Field.
 +
# Right-click on the Form Field and select Properties. Then provide a name for the field in the Bookmark section.
 +
 
 +
* [https://support.office.com/en-us/article/Convert-text-to-a-table-or-vice-versa-b5ce45db-52d5-4fe3-8e9c-e04b62f189e1 Convert text to a table or vice versa]
 +
* [https://support.office.com/en-us/article/Format-a-table-e6e77bc6-1f4e-467e-b818-2e2acc488006 Format a table]
 +
* [https://support.office.com/en-us/article/Add-the-file-name-to-the-header-or-footer-dc62245f-b6af-45b2-a521-17753fc3539e Add the file name to the header or footer]
 +
* [https://social.technet.microsoft.com/Forums/office/en-US/3270fcd8-9b1d-4570-8582-9734cd3409dc/word-2007-using-numbered-list-number-in-hyperlink?forum=word Word 2007 - Using numbered list number in hyperlink]
 +
: Do you need to create a dynamic link to a specific list number/letter of a list item in your Word document? The above tutorial will help. In a nutshell, to the following:
 +
# Select the "References" menu tab.
 +
# In the "Captions" group, select "Cross-reference". A new little window pops up.
 +
# Under "Reference type:" (in the new little window) choose "Numbered item". Make sure the little "Insert as hyperlink" tic-box is check, just below.
 +
# Under "Insert reference to:" choose "Paragraph number".
 +
# In the "For which numbered item:" section, choose the paragraph you want to reference.
 +
# Click the "Insert" button.
 +
 
 +
* [http://word.tips.net/T003779_ScreenTips_without_Hyperlinks.html ScreenTips without Hyperlinks]
 +
: Do you want "hover text" when mousing over a word or number? Try the above tip.
 +
 
 +
==== Password Protect Issues ====
 +
* [http://www.nextofwindows.com/how-to-remove-password-from-protected-word-file-in-word-2007-and-2010 How To Remove Password From Protected Word File in Word 2007 and 2010]
 +
# Rename file extension from DOCX to ZIP.
 +
# Open document in Windows Explorer and navigate to Word folder.
 +
# Delete the Settings.XML file from the folder, then close the Windows Explorer window.
 +
# Rename document extension back to DOCX from ZIP.
 +
 
 +
==== Field Codes ====
 +
Fields in Microsoft Word are used as placeholders for data that might change in a document and for creating form letters and labels in mail-merge documents.
 +
* [https://support.office.com/en-us/article/Field-codes-in-Word-893e86ef-6623-457b-b551-788ea2ee93c8 Field codes in Word]
 +
* [https://support.office.com/en-us/article/Insert-and-format-field-codes-in-Word-2007-1c27736e-9624-45da-946c-2b3050a9491f Insert and format field codes in Word 2007]
 +
* [https://onedrive.live.com/redir?resid=18D3C89A0E2B3BB4!527&authkey=!ALFU60BUeN16C28&ithint=file%2cdocx Shortcut Keys For Use With Field Codes] (Word Online)
 +
* [http://wordribbon.tips.net/T009719_Inserting_the_Date_Your_Document_was_Last_Saved.html Inserting the Date Your Document was Last Saved]
 +
: Every time you save a document in Word, some of the document properties information is automatically updated. Part of the information is the date on which the document was last saved. You can insert this date into your document using a <tt>field code</tt> so that it will update automatically.
 +
* [http://mikefrobbins.com/2010/05/10/how-to-toggle-field-codes-off-or-on-in-word/ How to Toggle Field Codes Off or On in Microsoft Word]
 +
: Do codes like <code>{ FORMCHECKBOX }</code> or <code>{ =SUM(C29,F30) \# "#,##0.00" }</code> or <code>{ FILENAME \p }</code> all of a sudden start showing up when you open a Word document? If so, and you want to fix it, the above tutorial is for you.
 +
 
 +
==== Calculating Numbers in Word ====
 +
* [http://geekgirls.com/2010/02/using-words-hidden-calculator/ Using Microsoft Word’s hidden calculator]
 +
: Because Microsoft has buried the calculator so thoroughly, you’ll need to resurrect it before putting it to use. That means sticking it on a toolbar. In Word 2007, you’ll have to put it on the Quick Access toolbar:
 +
# Right-click the Quick Access toolbar and select Customize Quick Access Toolbar from the pop-up menu.
 +
# Make sure For All Documents is selected in the Customize Quick Access Toolbar drop-down box.
 +
# In the Choose Commands From drop-down box, select Commands Not In The Ribbon. (Side note: Perusing this list is highly educational for old-time Word users pining for lost commands.)
 +
# Locate Calculate in the list and double-click it to add it to the list of Quick Access commands, then click OK.
 +
 
 +
* [http://wordfaqs.mvps.org/ToolsCalculate.htm Using the Calculate Command - Word FAQ site - MVPs.org]
 +
: Among Word's many undocumented features are some legacies from previous versions. One of these is the ToolsCalculate command.
 +
{| class="wikitable" style="height:100px; width:700px; text-align:center;"
 +
! Use || To || Example || Expression || Result
 +
|-
 +
| -<br />or<br />( ) || Subtract || Budget for the rest<br />of the month || 1500-976<br />or<br />1500 (976) || 524
 +
|-
 +
| / || Divide || Cost per month || $7000/12 || $583.33
 +
|-
 +
| * || Multiply || Rent per year || 12*$583 || $6996.00
 +
|-
 +
| +<br />or<br />space || Add || Joint income || 19,000+16,500<br />or<br />19,000 16,500 || 35,500
 +
|-
 +
| % || Calculate percentage || Taxes due || $155.79*6% || $9.35
 +
|-
 +
| ^ || Calculate power || Six squared || 6^2 || 36
 +
|-
 +
| ^ || Calculate power || Cube root of eight || 8^(1/3) || 2
 +
|}
 +
 
 +
==== Calculating Numbers in a Table Using Formulas ====
 +
You can add, subtract, multiply, and divide numbers in Word table cells. Also you can calculate averages, percentages, and minimum as well as maximum values.
 +
;Examples
 +
: <code>=SUM(C28,F28)</code>
 +
: <code>=(F30-F28)</code>
 +
: <code>=SUM(C29,F30)-(C28)</code>
 +
: <code>=SUM(ABOVE)</code> Adds the numbers in the column above the cell you’re in.
 +
: <code>=SUM(LEFT)</code> Adds the numbers in the row to the left of the cell you’re in.
 +
: <code>=SUM(BELOW)</code> Adds the numbers in the column below the cell you’re in.
 +
: <code>=SUM(RIGHT)</code> Adds the numbers in the row to the right of the cell you’re in.
 +
 
 +
* [https://support.office.com/en-us/article/Use-a-formula-in-a-Word-or-Outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27 Use a formula in a Word or Outlook table]
 +
: You can perform calculations and logical comparisons in a table by using formulas. The Formula command is found on the Table Tools, Layout tab, in the Data group.
 +
 
 +
* [https://support.office.com/en-us/article/Sum-a-column-or-row-of-numbers-in-a-table-2e373a5f-2d8a-478a-9b85-275c8668bebb Sum a column or row of numbers in a table]
 +
: To add up a column or row numbers in a table, use the Formula command. (A stripped-down version of the [https://support.office.com/en-us/article/Use-a-formula-in-a-Word-or-Outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27 above tutorial].)
 +
 
 +
* [http://www.officetooltips.com/word_2007/tips/calculations_in_the_table.html Calculations in the table]
 +
 
 +
==== Using Bookmarks ====
 +
'''Useful Bookmarks Example:''' Use bookmarks to refer to the prices of multiple products in your Word document. Bookmark each price, then display the sum of the bookmarked prices using a formula field to calculate the total.
 +
* [http://makeofficework.com/bookmarks_the_basics.htm Bookmarks: The Basics]
 +
* [http://makeofficework.com/bookmarks_their_full_power.htm Bookmarks: Their Full Power]
 +
 
 +
===== Use Bookmarks to Repeat Text Within a Document =====
 +
* [https://cybertext.wordpress.com/2011/01/03/word-repeating-text-within-a-document/ Word: Repeating text within a document]
 +
: Assign a bookmark to the text you want to re-use, then insert a cross-reference to the bookmark text. Whenever you change the original text, you only need to update the fields in the document for the changes to apply to the second (or third) instance of that text.
 +
 
 +
===== Use Bookmarks to Calculate Numbers in Tables Across Multiple Tables =====
 +
Do you want to calculate numbers located in one or more tables in your Word document and display the results outside of the table(s)? Here's how:<br />
 +
'''1.''' [https://support.office.com/en-us/article/Add-or-delete-bookmarks-f68d781f-0150-4583-a90e-a4009d99c2a0 Bookmark] each of the tables you want to refer to.
 +
:- Highlight your first table.
 +
:- Word > Insert Tab > click on "Bookmark" (icon in "Links" section).
 +
:- Enter name of bookmark (eg: "table1") and click "OK".
 +
:- Do the same for each table you want to bookmark.
 +
'''2.''' Refer to the table name you used in your bookmark (eg: <tt>table1</tt>, <tt>table2</tt>, etc.) like shown in the code examples below.
 +
 
 +
;Code Examples'''<nowiki>:</nowiki>'''
 +
 
 +
* <code>{ =SUM(table1 B2:B3) }</code>
 +
: The above example SUMs two numbers located in <tt>table1</tt>.
 +
* <code>{ =SUM(table1 B2,table2 C2) }</code>
 +
: The above example SUMs two numbers – one located in <tt>table1</tt> and another located in <tt>table2</tt>.
 +
;PLEASE NOTE
 +
: Word's Formula (<tt>fx</tt>) function (<tt>Table Tools</tt> > <tt>Layout</tt> > <tt>Data</tt> > <tt>Formula</tt>) is extremely finicky. When inserting a formula using this tool, make sure to insert the entire formula at one go. Subsequent edits seem to generate error messages.
 +
: ''If you are NOT using Word's Formula Function'': Don't type in the curly braces (<tt>{}</tt>) yourself. For your code to actually work, you must insert curly braces into your Word document by pressing <code>CTRL+F9</code> on your keyboard.
 +
 
 +
* [https://support.office.com/en-us/article/Use-a-formula-in-a-Word-or-Outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27#__toc281293383 Use bookmarknames or cell references in a formula]
 +
: This tutorial is a subsection of the [https://support.office.com/en-us/article/Use-a-formula-in-a-Word-or-Outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27 Use a formula in a Word or Outlook table] tutorial. It describes how to bookmark specific objects on a Word document, then refer to those bookmarks in a formula. You can use this technique to calculate across multiple tables.
 +
 
 +
* [http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macword/bookmark-a-word-table-cell-and-all-i-get-is-sentex/48ddf117-8ee2-450c-b9f0-c1621bd6c087 Bookmark a word table cell and all I get is sentex errors this is the mac for word version]
 +
 
 +
* [http://superuser.com/questions/571051/reference-to-a-cell-in-an-other-table-in-a-word-document-from-a-field Reference to a cell in an other table in a Word document from a field]
 +
 
 +
===== Use Bookmarks to Calculate Numbers in Specific Cells Across Multiple Tables =====
 +
# Highlight the number in first table.
 +
# Word > Insert Tab > click on "Bookmark" (icon in "Links" section).
 +
# Enter name of bookmark (eg: "first_total") and click "OK".
 +
# Do the same for each value in each table you want to bookmark.
 +
# Place cursor where you want to sum the totals you just bookmarked.
 +
# Press <code>CTRL+F9</code> and type in an <code>=</code> character.
 +
# Go To: Insert Tab > select "Quick Parts" > (icon in Text section) > Pull down to "Field".
 +
# Scroll down the list of "Field names" and choose "Ref".
 +
# Select the first bookmark name you created, then click the "OK" button.
 +
# Type "+" next to the value you just inserted, then select the second bookmark and click "OK." Do the same for each bookmark you want to add.
 +
# Right-click on the field set you just created by going through the above steps and choose "Update Field".
 +
# To view and/or edit the formula for the number you just updated, right-click on the number and choose "Toggle Field Codes".
 +
 
 +
;Sources for above steps'''<nowiki>:</nowiki>'''
 +
* [http://www.projectwoman.com/articles/02tablemath.htm#.Vxft3EwrK70 Math in Word Tables]
 +
* [http://windowssecrets.com/forums/showthread.php/99905-Sum-multiple-tables-(Word-2003) Thread: Sum multiple tables (Word 2003)]
 +
 
 +
==== Formatting Section-Specific Header & Footer Info (Section Names, Page Numbers, Etc.) ====
 +
'''Goal''': Set header/footer labels, file paths, <tt>X of Y</tt> formatted page numbering and other properties so they apply only to a specific section within a word document.<br />
 +
''Applies to Microsoft Word 2007.''
 +
* [https://support.office.com/en-us/article/Insert-headers-and-footers-f22334fb-4455-4b18-9354-7c9c70c3b032?ui=en-US&rs=en-US&ad=US&fromAR=1#bm5 Make the header or footer different in each section or chapter]
 +
;Add section breaks to a document
 +
:If your document is not divided into sections, you can insert section breaks where you want the header or footer to vary.
 +
#Starting at the beginning of the document, place the cursor at the beginning of the page where you want to start varying the header or footer.
 +
#On the '''Page Layout''' tab, in the '''Page Setup''' group, click '''Breaks''', and then under '''Section Breaks''', click '''Next Page'''.
 +
#Place the cursor at the beginning of the next page where you want to vary the header or footer, such as the first page of a new chapter.
 +
#On the '''Page Layout''' tab, in the '''Page Setup''' group, click '''Breaks''', and then under '''Section Breaks''', click '''Next Page'''.
 +
#Repeat steps 3 and 4 for every section break that you want in the document.
 +
;Use a document's section breaks to vary the header or footer
 +
:If your document is already divided into sections, you can use the section breaks to configure headers and footers.
 +
#Starting at the beginning of the document, click in the first section for which you want to vary the header or footer.
 +
#On the '''Insert''' tab, in the '''Header & Footer''' group, click '''Header or Footer'''.
 +
#Click '''Edit Header''' or '''Edit Footer'''.
 +
#On the '''Headers & Footers''' tab, in the '''Navigation''' group, click '''Link to Previous''' to break the connection between the header or footer in this section and the previous section.
 +
#Change the existing header or footer, or create a new header or footer for this section.
 +
#In the '''Navigation''' group of the '''Design''' tab (Header & Footer contextual tab), click '''Next Section''' to advance the cursor to the header or footer of the next section.
 +
#On the '''Headers & Footers''' tab, in the '''Navigation''' group, click '''Link to Previous''' to break the connection between the header or footer in this section and the previous section.
 +
#Change the existing header or footer, or create a new header or footer for this section.
 +
#Repeat the previous three steps for all of the sections in the document.<ref>[https://support.office.com/en-us/article/Insert-headers-and-footers-f22334fb-4455-4b18-9354-7c9c70c3b032?ui=en-US&rs=en-US&ad=US&fromAR=1#bm5 Make the header or footer different in each section or chapter]</ref>
 +
 
 +
* [https://support.office.com/en-us/article/Headers-and-footers-for-document-sections-c7962194-f0f7-42af-b808-f99c34700e14 Headers and footers for document sections]
 +
: Mini Course: Using Word 2007, create headers and footers in a document that has several parts, such as a cover page and table of contents, followed by chapters. Includes a Quick Reference Card at the end of the tutorial.
 +
* [https://support.office.com/en-us/article/Number-pages-differently-in-different-sections-1ba9047e-4534-460f-8003-12a81bb527f3 Number pages differently in different sections]
 +
: Good tutorial for adding section-specific ''single'' page numbers (ie. <tt>Page 1</tt>), but ''not'' <tt>Page X of Y</tt> formatted page numbering.
 +
#Click at the beginning of the page where you want to start, stop, or change the header, footer, or page numbering.
 +
#On the '''Page Layout''' tab, in the '''Page Setup''' group, click '''Breaks'''.
 +
#Under '''Section Breaks''', click '''Next Page'''.
 +
#On the page that follows the section break, double-click in the header area or the footer area (near the top of the page or near the bottom of the page). This opens the Design tab under Header & Footer Tools.
 +
#On the '''Design''' tab, in the '''Navigation''' group, click '''Link to Previous''' to turn it off.<br />'''IMPORTANT:'''  If your page number is in the header, be sure that you turn off linking for headers. If your page number is in the footer, be sure that you turn off linking for footers. Headers and footers are linked or unlinked separately.
 +
#Follow the instructions for adding page numbers or for adding a header and footer with a page number.<br />'''NOTE:'''  Choose an alert and enter text here. You may also set it's AlertPosition property.
 +
#To choose a numbering format or the starting number, click '''Page Number''' in the '''Header & Footer''' group, click '''Format Page Numbers''', click the format that you want and the Start at number that you want to use, and then click '''OK'''.
 +
#To return to the body of your document, click '''Close Header and Footer''' on the Design tab (under Header & Footer Tools).
 +
 
 +
* [https://support.office.com/en-us/article/Add-page-number-X-of-Y-to-a-document-1f273c7c-661c-4444-97b5-c7ec07270f16 Add page number X of Y to a document]
 +
: Good tutorial for simply adding <tt>Page X of Y</tt> formatted page numbering.
 +
* [https://support.office.com/en-us/article/Field-codes-NumPages-field-536fa716-025b-4dd6-8a04-8a190b5b1490 Field codes: NumPages field] &amp; [https://support.office.com/en-us/article/Field-codes-SectionPages-field-66f025dd-bc6c-4391-b223-886da61b8ade Field codes: SectionPages field]
 +
: Use these tutorials to configure <tt>Page X of Y</tt> formatted page numbering that is specific to each document section.
 +
 
 +
===== SectionPages =====
 +
:The <tt>SectionPages</tt> field inserts the total number of pages in a section. When using this field, you should restart page numbering from 1 in each section after the first section.
 +
:'''NOTE:''' A field code tells the field what to show. Field results are what’s shown in the document after having evaluated the field code. To toggle between viewing the field code and the field code results, press <code>Alt+F9</code>.
 +
:'''Example:''' To print text such as "Page 4 of 29." on each page of a document you've divided into sections, insert the following fields and text in the header or footer:
 +
::Page <code>{ PAGE }</code> of <code>{ SECTIONPAGES }</code>.
 +
# Place your cursor where you want the <code>{ PAGE }</code> field code.
 +
# Go To: Insert (tab) > select "Quick Parts" > (located in Text section) > Pull down to "Field".
 +
# Scroll down the list of "Field names" and choose "Page".
 +
# In the "Format" window, choose the numbering format you want to use (eg: <tt>1, 2, 3, ...</tt>).
 +
# Repeat the steps above to place your <code>{ SECTIONPAGES }</code> field code (but choose the <code>{ SECTIONPAGES }</code> field code instead of <code>{ PAGE }</code>).
 +
 
 +
==== Word Keyboard Shortcuts ====
 +
* [[wikipedia:Table of keyboard shortcuts|Table of keyboard shortcuts]] (Wikipedia)
 +
* Key command for inserting non-updating date in MS Word:
 
: <tt>Alt-Shift-D</tt> + <tt>Backspace</tt> + <tt>Ctrl-Shift-F9</tt>
 
: <tt>Alt-Shift-D</tt> + <tt>Backspace</tt> + <tt>Ctrl-Shift-F9</tt>
  
== Quick Edit Sheets ==
+
== ONLYOFFICE™ - Cloud Office Applications ==
* [https://ethercalc.org EtherCalc]
+
* [https://github.com/ONLYOFFICE/CommunityServer ONLYOFFICE/CommunityServer]
 +
: Free open source office suite with business productivity tools: document and project management, CRM, mail aggregator.
 +
 
 +
* [https://github.com/ONLYOFFICE/DocumentServer ONLYOFFICE/DocumentServer]
 +
: ONLYOFFICE Document Server is an online office suite comprising viewers and editors for texts, spreadsheets and presentations, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
 +
 
 +
* [https://github.com/ONLYOFFICE ONLYOFFICE · GitHub] (GitHub)
 +
 
 +
* [https://personal.onlyoffice.com OnlyOffice Personal - Get Free Office In The Cloud]
 +
: Free Alternative to Microsoft® Office | Edit word docs, spreadsheets and presentations online.
 +
 
 +
* [http://onlyoffice.org/ ONLYOFFICE™ - Cloud Office Applications](.ORG)
 +
: Your Free and Open Source Web-Office | ONLYOFFICE™ is a multifunctional office suite that enables you to store and co-edit documents, manage projects, email correspondence and customer relations in one place.
 +
 
 +
* [http://www.onlyoffice.com ONLYOFFICE™ - Cloud Office Applications](.COM)
 +
: Edit Documents with #1 Online Office Apps | Built using HTML5′s Canvas element, it claims to combine the best of Google’s online collaboration features with Microsoft Word’s high quality formatting.
 +
 
 +
== Portable Document Format (PDF) ==
 +
* [https://www.techradar.com/news/the-best-free-pdf-editor The best free PDF editor 2019]
 +
: Edit, split and merge PDFs without paying for premium software
 +
:: By Catherine Ellis | March 05, 2019
 +
 
 +
* [http://www.cnet.com/how-to/how-to-fill-out-a-pdf-form-without-software/ How to fill out a PDF form without software]
 +
: Need to add text to a PDF that doesn't support editing? No problem -- and no extra software required.
 +
 
 +
=== Comprehensive PDF Editors ===
 +
* [https://www.sejda.com/ Sejda.com] - Helps with your PDF tasks
 +
: Quick and simple online service, no installation required! Split, merge or convert PDF to images, alternate mix or split scans and many other features.
 +
::- Combine and Reorder PDF Pages: Merge pages from different documents, reorder pages if needed
 +
::- Split PDF by pages: Split specific page ranges or extract every page into a separate document
 +
::- Process PDF from free, no-login online account or from downloadable software. Premium accounts available.
 +
 
 +
* [http://www.sejda.org/ Sejda.org]
 +
: Open source!
 +
::- Shell interface for performing pdf manipulations such as merge or split from the command line.
 +
::- The shell interface requires Java runtime 1.8 or higher to be installed. It works on Linux, Windows and Mac.
 +
 
 +
=== Online PDF Form Builders ===
 +
* [https://www.cognitoforms.com Cognito Forms]
 +
: Free Online Form Builder, create HTML forms and surveys.
 +
:: [https://www.cognitoforms.com/features/calculations Calculations] — Build forms with powerful calculations that can total costs, compare dates, and so much more.
 +
 
 +
=== Free Online PDF Creators ===
 +
* [http://www.jotform.com/fillable-pdf-form-creator/ JotForm's Fillable PDF Form Creator]
 +
: JotForm makes it simple to create PDF forms. Using JotForm’s easy drag-and-drop form builder, you can quickly generate a submittable PDF form that lets people send responses directly to your email and JotForm account. Create a form in minutes that can be used anywhere, regardless of device or internet access.
 +
 
 +
=== Free Online PDF Editors ===
 +
* [https://www.apowersoft.com/pdf-editor ApowerPDF]
 +
: Dave's Note: This editor written about in this article: [https://www.techradar.com/news/the-best-free-pdf-editor The best free PDF editor 2019], which recommends using the online version. Unclear if online version will not add watermarks (need to investigate===  will update here afterward).
 +
 
 +
* [https://dochub.com/ DocHub]
 +
: Edit, send & sign PDFs online for free.
 +
: Free Plan:
 +
::- View and edit unlimited documents
 +
::- Sign 5 documents / month
 +
::- Up to 3 signers / document
 +
::- Send 3 / month
 +
::- Email up to 3 documents / day
 +
::- Up to 3 recipients / email
 +
::- Faxes: $1.99 / fax
 +
 
 +
* [https://lightpdf.com/ LightPDF]
 +
: The Best Free Online PDF Editor & Converter: Free PDF Tools to Solve All PDF Problems With One Click
 +
 
 +
* [https://www.tryexcalibur.com/ Excalibur]: Extract tables from PDFs into Excels
 +
: Excalibur makes PDF table extraction very easy, by automatically detecting tables in PDFs and letting you save them into CSVs and Excels through a web interface.
 +
 
 +
* [https://www.pdfbuddy.com/ PDF Buddy | Online PDF Editor]
 +
: Pricing: Start Using PDF Buddy for Free. No credit card required.
 +
: FREE PLAN: 3 PDFs/month | 1 GB storage
 +
 
 +
* [https://www.pdfescape.com/ PDFescape - Free PDF Editor & Free PDF Form Filler]
 +
 
 +
* [https://www.pdfpro.co/ PDF Pro: The Best Online PDF Editor]
 +
: Create, Edit & Convert up to 3 PDF Files a month for FREE! No sign up required.
 +
 
 +
* [https://www.pdfyeah.com/ PDFYeah]: All-in-One Online PDF Solution
 +
: Free online PDF converter that helps with your everyday PDF tasks, making it easy to compress, convert and edit PDF files online. An all-in-one free PDF solution to solve all your PDF problems.
 +
 
 +
;Also See: [[Data Analysis#PDF_Conversion|Data Analysis#PDF Conversion]]
 +
 
 +
== Quick Text Edit Spreadsheets ==
 +
* [https://ethercalc.org EtherCalc.org] -or- [https://ethercalc.net/ EtherCalc.net]
 
: EtherCalc is a web spreadsheet. Your data is saved on the web, and people can edit the same document at the same time. Everybody's changes are instantly reflected on all screens. No sign-up required; start writing instantly. Drag and drop a .csv, .ods, or a .xlsx file to import it.
 
: EtherCalc is a web spreadsheet. Your data is saved on the web, and people can edit the same document at the same time. Everybody's changes are instantly reflected on all screens. No sign-up required; start writing instantly. Drag and drop a .csv, .ods, or a .xlsx file to import it.
 
* [https://ethersheet.org/ Ethersheet]
 
* [https://ethersheet.org/ Ethersheet]
 
: Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also [https://github.com/ethersheet-collective/EtherSheet download the code on GitHub].
 
: Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also [https://github.com/ethersheet-collective/EtherSheet download the code on GitHub].
 +
* [http://www.gelsheet.org/ Gelsheet: The Opensource Web spreadsheet]
 +
: GelSheet is a free and open source web spreadsheet that allow users to create, edit and export in many formats your everyday work. It's intended to run either standalone or integrated within another web tool. It was born as a part of Opengoo web office.
  
=== Dearly Departed Quick Edit Sheets ===
+
=== Dearly Departed Quick Edit Spreadsheets ===
 
* [http://www.editgrid.com/ EditGrid]
 
* [http://www.editgrid.com/ EditGrid]
: Unfortunately, EditGrid's service is ending May 1, 2014.<ref>[http://www.editgrid.com/ EditGrid service is ending May 1, 2014]</ref>
+
: Unfortunately, EditGrid's service was shut down on May 1, 2014.<ref>[[wikipedia:EditGrid|EditGrid was a Web 2.0 spreadsheet service, operated via Internet access.]]</ref>
  
=== Other Edit Pads (Non-Spreadsheet) ===
+
=== Other Text Edit Pads (Non-Spreadsheet) ===
 
* [http://etherpad.org/ Etherpad.org]
 
* [http://etherpad.org/ Etherpad.org]
 
* [http://www.firepad.io/ Firepad]
 
* [http://www.firepad.io/ Firepad]
 
: Firepad is an open source collaborative text editor you can add to your own website.
 
: Firepad is an open source collaborative text editor you can add to your own website.
 +
* [https://hushpad.org/ HushPad]
 +
: What is HushPad?<ref>[https://hushpad.org/about What is HushPad?]</ref>
 +
::- Pastebin, but secured
 +
::- Latest browser built-in Web Crypto API is used for strong password-based key generation
 +
::- Password protection is always on, even if you don't specify password
 +
::- Removable notes with unrecoverable deletion
 +
::- No logs and fancy tracking: no Google analytics, Disqus, IP logging, etc.
 +
* [https://itextpad.com/ iTextpad] Online Notepad
 +
: Free online notepad | No Registration Required | Password protect options. Take notes anywhere, anytime & any device.
 
* [https://www.piratepad.ca/ PiratePad.ca]
 
* [https://www.piratepad.ca/ PiratePad.ca]
 
* [http://piratepad.net/front-page/ Piratepad.net]
 
* [http://piratepad.net/front-page/ Piratepad.net]
Line 53: Line 450:
 
* [https://titanpad.com TitanPad]
 
* [https://titanpad.com TitanPad]
 
: TitanPad lets people work on one document simultaneously. "We are rescuing EtherPad for your use." No sign-up required; start writing instantly.
 
: TitanPad lets people work on one document simultaneously. "We are rescuing EtherPad for your use." No sign-up required; start writing instantly.
 +
* [https://txxt.app/ txxt.app]: sms notepad
 +
: Write notes as text messages & view them on the web.
  
 
== Screen Grabs ==
 
== Screen Grabs ==
Line 59: Line 458:
 
== SharePoint ==
 
== SharePoint ==
 
* [https://portal.slac.stanford.edu/sites/inc_public/pages/how-to-shorten-url.aspx How-To Shorten SharePoint URLs]
 
* [https://portal.slac.stanford.edu/sites/inc_public/pages/how-to-shorten-url.aspx How-To Shorten SharePoint URLs]
: Have you noticed that, when working in SharePoint, the URL in your browser's [[wikipedia:Address bar|address bar]] pointing to any SharePoint file or folder is a super-long, ugly mess? Good news! You can still get a shorter, prettier URL for that file or folder, as the above tutorial explains.
+
: Have you noticed that--when working in SharePoint--the URL in your browser's [[wikipedia:Address bar|address bar]] pointing to any SharePoint file or folder is a super-long, ugly mess? Good news! You ''can'' get a shorter, prettier URL for that file or folder, as the above tutorial explains.
 +
 
 +
* [https://truapps.portalfront.com/how-to-copy-and-move-files-between-sharepoint-document-libraries-and-folders.html How to copy, move, and clone files and folders in SharePoint - Exploring All Options]
 +
: Despite all the typos in the text of this tutorial, it is a pretty good step-by-step guide for moving files and folders around in SharePoint.
 +
 
 +
=== SharePoint Workspace ===
 +
* [[wikipedia:Microsoft SharePoint Workspace|Microsoft SharePoint Workspace]]
 +
: Microsoft SharePoint Workspace, previously known as Microsoft Office Groove, is a discontinued desktop application designed for [[wikipedia:document collaboration|document collaboration]] in teams with members who are regularly [[wikipedia:off-line|off-line]] or who do not share the same network security clearance. It is no longer included with [[wikipedia:Microsoft Office 2013|Microsoft Office 2013]] or [[wikipedia:Office 365|Office 365]], the latter of which includes Microsoft's [[wikipedia:OneDrive for Business|OneDrive for Business]] instead. The latter does not fully replace the former.
 +
 
 +
* [https://support.office.com/en-sg/article/Basic-tasks-in-SharePoint-Workspace-2010-77d8016f-f508-440f-bba6-a590f2527d38 Basic tasks in SharePoint Workspace 2010]
  
 
== Slide Decks ==
 
== Slide Decks ==
Line 69: Line 477:
  
 
== Text Editors ==
 
== Text Editors ==
 +
* [http://lifehacker.com/five-best-text-editors-1564907215 Five Best Text Editors]
 +
: Whether you’re a developer or a writer, a good text editor is a must-have on any computer, in any operating system. The humble text editor is great for managing code, writing down quick notes, or just as a distraction-free writing tool.
 +
 +
* [http://www.sublimetext.com/ Sublime Text]
 +
: Sublime Text is available for OS X, Windows and Linux. It is heavily favored among coders. It’s distributed as evaluation software (meaning it’s free to try, but there’s no time limit on how long you can use it for free) and a full license will cost you $70. A full license is per user, so you can use it on as many computers as you like once you have one.<ref>[http://lifehacker.com/five-best-text-editors-1564907215 Five Best Text Editors: #1 Sublime Text]</ref>
 +
 
* [[wikipedia:List of text editors|List of Text Editors]] (Wikipedia)
 
* [[wikipedia:List of text editors|List of Text Editors]] (Wikipedia)
  
Line 76: Line 490:
  
 
== Text Readers ==
 
== Text Readers ==
 +
;Screen Readers | Text To Speech
 +
* [http://responsivevoice.org/ ResponsiveVoice.JS: Instant Text-To-Speech with Voice Consistency Across Devices]
 +
: ResponsiveVoice is a HTML5-based Text-To-Speech library designed to add voice features to web sites and apps across all smartphone, tablet and desktop devices. It supports 51 languages through 168 voices, no dependencies and weighs just 14kb.
 +
 
* [https://www.yakitome.com/ YAKiToMe!]
 
* [https://www.yakitome.com/ YAKiToMe!]
 
: Copy text and past it into YAKiToMe!'s web site text box, then press the "play" button. A computerized female voice will read the text back to you.
 
: Copy text and past it into YAKiToMe!'s web site text box, then press the "play" button. A computerized female voice will read the text back to you.
  
== Tools ==
+
== Tools &amp; Resources ==
 
=== Source Citation ===
 
=== Source Citation ===
 
* [http://www.easybib.com/ EasyBib: The Free Automatic Bibliography Composer]
 
* [http://www.easybib.com/ EasyBib: The Free Automatic Bibliography Composer]
Line 100: Line 518:
 
;10 Tools for Creating Infographics and Visualizations: http://moz.com/blog/10-tools-for-creating-infographics-visualizations
 
;10 Tools for Creating Infographics and Visualizations: http://moz.com/blog/10-tools-for-creating-infographics-visualizations
  
=== Miscellaneous Tools ===
+
=== Web Fax Services ===
;Zamzar - free online converter: http://www.zamzar.com/
 
: http://www.zamzar.com/conversionTypes.php
 
: File convert service between document, image, music, video, e-book, compressed and CAD formats. No account or signup required.
 
 
 
== Web Fax Services ==
 
 
* [http://faxzero.com/ FaxZero]
 
* [http://faxzero.com/ FaxZero]
 
: Looks like it ''does not'' require account set-up for free fax service. Inserts ad on fax cover page.
 
: Looks like it ''does not'' require account set-up for free fax service. Inserts ad on fax cover page.
  
 
* [http://www.gotfreefax.com/ GotFreeFax.com]
 
* [http://www.gotfreefax.com/ GotFreeFax.com]
: Looks like it ''does not'' require account set-up for free fax service. Claims that it ''does not'' place ad(s) on fax.
+
: Looks like it ''does not'' require account set-up for free fax service. Claims that it ''does not'' place ad(s) on fax. '''2015-10-15 Update''': The maintainer of this wiki has used [http://www.gotfreefax.com/ GotFreeFax.com] on multiple occasions. Service is free, and includes email verification after fax transmission completes successfully.
  
 
* [http://www.freepopfax.com/ Popfax.com]
 
* [http://www.freepopfax.com/ Popfax.com]
: Claim's it's "Truly Free Internet Faxing." Also appears to not require account set-up to use.
+
: <s>Claim's it's "Truly Free Internet Faxing." Also appears to not require account set-up to use.</s> '''2015-10-15 Update''': It appears this service now requires an account; charges also now apply.
  
 
;Further Reading
 
;Further Reading
 
* [http://webseasoning.com/technology/10-best-free-online-fax-services/1106/ 10 Best Free Online Fax Services]
 
* [http://webseasoning.com/technology/10-best-free-online-fax-services/1106/ 10 Best Free Online Fax Services]
 +
 +
=== File Conversion Tools ===
 +
* [https://cloudconvert.com/ CloudConvert]: Convert Anything To Anything
 +
: CloudConvert supports the conversion between more than 200 different audio, video, document, ebook, archive, image, spreadsheet and presentation formats.
 +
 +
* [http://www.zamzar.com/ Zamzar - free online converter]
 +
: File convert service between document, image, music, video, e-book, compressed and CAD formats. No account or signup required.
 +
:: [http://www.zamzar.com/conversionTypes.php Zamzar Conversion Types]
 +
 +
== URL Shorteners ==
 +
* [http://xn--dk8h6i.ws/ Mosho (🎉🐙.ws)]
 +
: You know bitly? Mosho is like that but with emojis.
 +
 +
; Also See'''<nowiki>:</nowiki>'''
 +
: [[wikipedia:URL shortening#URL_shortening_services|URL Shortening Services (List on Wikipedia.)]]
  
 
== Web-Based Productivity Apps ==
 
== Web-Based Productivity Apps ==
; What Should I Do Now that Google Apps Accounts Are No Longer Free?: http://lifehacker.com/5967154/what-should-i-do-now-that-google-apps-accounts-are-no-longer-free
+
* [http://lifehacker.com/5967154/what-should-i-do-now-that-google-apps-accounts-are-no-longer-free What Should I Do Now that Google Apps Accounts Are No Longer Free?]
; Going Google-Free<nowiki>:</nowiki> The Best Alternatives to Google Services on the Web: http://lifehacker.com/5876794/going-google+free-the-best-alternatives-to-google-services-on-the-web
+
* [http://lifehacker.com/5876794/going-google+free-the-best-alternatives-to-google-services-on-the-web Going Google-Free: The Best Alternatives to Google Services on the Web]
 
: (Scroll down the article a little ways to get to the discussion on productivity apps.)
 
: (Scroll down the article a little ways to get to the discussion on productivity apps.)
 +
 +
== Writing Resources ==
 +
=== Bibliography | Cite | Citation | End Notes | Footnotes ===
 +
* [https://owl.english.purdue.edu/owl/resource/949/01/ Purdue University Online Writing Lab - Citation Style Chart]
 +
: This media file contains a PDF with a side-by-side comparison of APA, MLA, and CMS styles.
 +
:: [https://owl.english.purdue.edu/media/pdf/20110928111055_949.pdf The Purdue OWL: Citation Chart]
 +
 +
* [https://www.library.georgetown.edu/tutorials/research-guides/turabian-footnote-guide Turabian Footnote/Endnote Style]
 +
: The examples in this guide are meant to introduce you to the basics of citing sources using Kate Turabian's A Manual for Writers of Term Papers, Theses, and Dissertations (seventh edition).  Kate Turabian created her first "manual" in 1937 as a means of simplifying for students The Chicago Manual of Style; the seventh edition of Turabian is based on the 15th edition of the Chicago Manual.
 +
: For types of resources not covered in this guide (e.g., government documents, manuscript collections, video recordings) and for further detail and examples, you can consult the websites listed at the end of this guide, the handbook itself (LAU Ref Desk LB 2369 .T8 2007) or a reference librarian.
 +
 +
* [[wikipedia: Note (typography)|Note (typography)]]
 +
: Typographical devices such as the asterisk (*) or dagger (†) may also be used to point to footnotes; the traditional order of these symbols in English is *, †, ‡, §, ‖, ¶.[1] Historically, ☞ was also at the end of this list.[2] In documents like timetables, many different symbols, as well as letters and numbers, may be used to refer the reader to particular notes. In John Bach McMaster's multi-volume History of the People of the United States the sequence runs *, †, ‡, # (instead of §), ‖, Δ (instead of ¶), ◊, ↓, ↕, ↑.
 +
 +
* [http://content.easybib.com/citation-guides/mla-format/how-to-cite-a-parenthetical-citations-mla/ MLA Basics: Parenthetical Citations]
 +
: How to format in-text citations.
 +
 +
* [https://www.typewolf.com/cheatsheet Typography Cheatsheet]
 +
: A comprehensive guide to using proper typographic characters, including correct grammatical usage.
 +
:: Editor's note: Includes keyboard shortcuts for Windows and Mac.
 +
 +
; Also See<nowiki>:</nowiki> [[Office Productivity Hacks#Source_Citation|Source Citation Tools]] on this wiki page.
 +
 +
=== Book Publishing ===
 +
* [https://www.sourcefabric.org/en/booktype/ Booktype]
 +
: Booktype allows authors to create beautiful books for print and digital distribution. Publishers use Booktype to manage their entire catalogue in one place, providing authors, translators and proofreaders with all the tools they need. '''Open source''' Sourcefabric Booktype software gives you seamless publishing in EPUB format to all major sellers of e-books with one click.
  
 
== Zip Codes ==
 
== Zip Codes ==
Line 127: Line 581:
 
: Map of the USA where you can specify a point and a radius to search within and return all the ZIP codes found inside that radius.
 
: Map of the USA where you can specify a point and a radius to search within and return all the ZIP codes found inside that radius.
  
=== Zip+4 Lookups ===
+
=== Quick Zip Code Lookups ===
 +
Is the [https://tools.usps.com/go/ZipLookupAction_input USPS Zip Code Lookup Tool] a little too tedious for your tastes? Good news! There are less tedious alternatives.
 +
* [https://smartystreets.com/ SmartyStreets]
 +
: Address verification, validation, and autocomplete. One of the nice features about this tool is you can toss an entire street address into the "street address" field (while ignoring the city, state and zip code fields) and still get a USPS-compliant address.
 +
 
 +
=== Zip+4 & Address Lookups ===
 
* [http://www.melissadata.com/lookups/AddressCheck.asp Melissa Data Address Check]
 
* [http://www.melissadata.com/lookups/AddressCheck.asp Melissa Data Address Check]
 
: Input entire address (minus zip) into text field and Melissa Data will quickly generate a zip+4 code.
 
: Input entire address (minus zip) into text field and Melissa Data will quickly generate a zip+4 code.
Line 136: Line 595:
  
 
== See Also ==
 
== See Also ==
* [[Data Analysis]]
+
{{Additional Resource Wiki Pages}}
* [[Computer Productivity Hacks]]
 
* [[Social Networking Tips]]
 
* [[Spreadsheet Tricks]]
 
* [[User:Dave/Web Hack Notes (Non-Wiki)]]
 
  
 
== References ==
 
== References ==
 
{{Reflist}}
 
{{Reflist}}

Latest revision as of 18:10, 20 October 2019

Cloud Storage & File Sharing Platforms

Services described include: Dropbox, Tresorit, pCloud, OneDrive, Sync.com, Box, Mega, SpiderOak One, Backblaze, Jottacloud.
Q: What's in this list?
A: Alternatives to Google Drive for Web, Windows, Mac, iPhone, Android and more. Filter by license to discover only free or Open Source alternatives. This list contains a total of 183 apps similar to Google Drive.
Learn about seven "amazingly awesome open source cloud storage engines that you can use to access and sync your data privately for security and privacy reasons."
Upload a file, set time to self-destruct. Download as many times as you'd like from a page with a url that's easy to read and say. That's it!
Access your data from all your devices, on an open platform you can extend and modify.
  • Pydio - Master Your Universe of Files
Pydio (formerly AjaXplorer) is a mature open source software solution for file sharing and synchronization.
Snapdrop is an easy way to transfer files. Instantly share images, video, PDF, and links across devices. Peer2Peer, Private, Secure and Open Source. No Setup, No Signup.
File synchronisation. Version control. Self hosted. Client side encryption. Free and Open Source.
Provide a send-to email address, your email address, include a brief note then upload file and send.
Editor's Note: Used this service to send photos and video of technical issues to scanner manufacturer.

Google Apps

  1. Create a Google Doc for each meeting
  2. Move the document to the right folder(s)
  3. Share the document with participants
  4. Create Calendar event: Invite guests and attach document(s)
  5. Edit during the meeting
  6. Share the document link after the meeting
Keyboard Shortcuts
Select what you want to strike and click Alt+Shift+5. (Option+Shift+5 for Mac).
Ctrl+? to see other such keyboard shortcuts.

Google Apps | 3rd Party Resources

Direct links to create new documents for Google Apps.

Google App Engine

A content delivery network, or CDN, is a system of servers spread around the world, serving files from the nearest physical location. Instead of waiting for a file to find its way from a server farm in Silicon Valley 8,000 kilometres away, I can receive it from London, Dublin, or Paris, cutting down the time I wait. The big names — Google, Yahoo, Amazon, et al — use CDNs for their sites, but they’ve always been far too expensive for us mere mortals. Until now.

Google Mail Merge

Yet Another Mail Merge

Google Drive

Google Docs

Add Page Numbers, Footer Info, Etc.

Want page number & count (eg: Page 2 of 4)?
- Insert > Page number to insert a page number.
- Insert > Page count to get the count of number of pages in document.

Link to Section Heading

  1. Select the text you want to link from.
  2. Insert > Link
  3. Click on the little pointer (triangle) to the left of "Headings".
  4. Select the Heading you want to link to.
  5. Click the "Apply" button.

Google Sites

- k8oms: Yes, you can create a separate member's only site, make it private, invite your members as viewers and link to it from your main site.
- k8oms: You could (also) invite a Google Group to the site. All of your members would have to join the group. They would have to have Google accounts in order to join.

Google Voice

Instead of having to send out a conference number and access code to people calling in, you can now just ask them to call you at a preset time and you can conference them in as they call.

LibreOffice

LibreOffice in the Cloud

Collabora CloudSuite is a powerful LibreOffice-based office suite that works across platforms and devices. It enables you to access documents from any location, author new content, and share your work.
Request a Free Demo.
Collabora Productivity, the driving force behind putting LibreOffice in the Cloud, has released the first production grade version of Collabora Online, its flagship cloud document suite solution.
CODE is the unsupported, Development version of Collabora CloudSuite‘s commercial on-line component. It makes things easy for you to play with the latest unstable developments – of course at some risk of loosing your data, and with no strong upgrade or continuity guarantees. If it breaks – you get to keep both halves.
It's been years since The Document Foundation announced that LibreOffice would be ported to an online version. It looks like it will finally arrive... in 2016.

Regular Expressions & LibreOffice

Important Reminder When Working with Regular Expressions in LibreOffice:

With the Find & Replace window open, make sure to click on the "+" icon next to "Other Options" and check the "Regular expressions" tic box.

Do you want to add a blank paragraph after of each non-empty paragraph? Find .$ (dot-dollar) Replace with &\n (ampersand-backslash-n).
You need to click on the More Options button (bottom of Find & Replace dialog) and check the Regular Expressions box since \t is a regex code.

Keyboard Shortcuts

ShortcutWorld.com is an open, wiki-style Reference Database for Keyboard Shortcuts. Created and edited by Users like You.

Microsoft Office

Embed Excel Data in Word

Embed an Excel worksheet in a Word document and work with Excel in Word. You can also embed files in Excel.

Linking Data Between Files

Microsoft Outlook

Annotating an Outlook message or thread requires a creative approach. Here are a few easy ways to add meaningful notes to your Outlook messages.

Microsoft Word

For MS Word 2007:
  1. Click on the Menu button and select Word Options.
  2. In the Popular section, select Show Developer Tab in the Ribbon, then click "OK".
  3. Click in your Word document wherever you wish to insert a Form Field.
  4. On the Developer Menu select the Legacy Tools icon which is in the Controls section.
  5. On the Legacy Forms menu click the first icon to insert a Form Field.
  6. Right-click on the Form Field and select Properties. Then provide a name for the field in the Bookmark section.
Do you need to create a dynamic link to a specific list number/letter of a list item in your Word document? The above tutorial will help. In a nutshell, to the following:
  1. Select the "References" menu tab.
  2. In the "Captions" group, select "Cross-reference". A new little window pops up.
  3. Under "Reference type:" (in the new little window) choose "Numbered item". Make sure the little "Insert as hyperlink" tic-box is check, just below.
  4. Under "Insert reference to:" choose "Paragraph number".
  5. In the "For which numbered item:" section, choose the paragraph you want to reference.
  6. Click the "Insert" button.
Do you want "hover text" when mousing over a word or number? Try the above tip.

Password Protect Issues

  1. Rename file extension from DOCX to ZIP.
  2. Open document in Windows Explorer and navigate to Word folder.
  3. Delete the Settings.XML file from the folder, then close the Windows Explorer window.
  4. Rename document extension back to DOCX from ZIP.

Field Codes

Fields in Microsoft Word are used as placeholders for data that might change in a document and for creating form letters and labels in mail-merge documents.

Every time you save a document in Word, some of the document properties information is automatically updated. Part of the information is the date on which the document was last saved. You can insert this date into your document using a field code so that it will update automatically.
Do codes like { FORMCHECKBOX } or { =SUM(C29,F30) \# "#,##0.00" } or { FILENAME \p } all of a sudden start showing up when you open a Word document? If so, and you want to fix it, the above tutorial is for you.

Calculating Numbers in Word

Because Microsoft has buried the calculator so thoroughly, you’ll need to resurrect it before putting it to use. That means sticking it on a toolbar. In Word 2007, you’ll have to put it on the Quick Access toolbar:
  1. Right-click the Quick Access toolbar and select Customize Quick Access Toolbar from the pop-up menu.
  2. Make sure For All Documents is selected in the Customize Quick Access Toolbar drop-down box.
  3. In the Choose Commands From drop-down box, select Commands Not In The Ribbon. (Side note: Perusing this list is highly educational for old-time Word users pining for lost commands.)
  4. Locate Calculate in the list and double-click it to add it to the list of Quick Access commands, then click OK.
Among Word's many undocumented features are some legacies from previous versions. One of these is the ToolsCalculate command.
Use To Example Expression Result
-
or
( )
Subtract Budget for the rest
of the month
1500-976
or
1500 (976)
524
/ Divide Cost per month $7000/12 $583.33
* Multiply Rent per year 12*$583 $6996.00
+
or
space
Add Joint income 19,000+16,500
or
19,000 16,500
35,500
% Calculate percentage Taxes due $155.79*6% $9.35
^ Calculate power Six squared 6^2 36
^ Calculate power Cube root of eight 8^(1/3) 2

Calculating Numbers in a Table Using Formulas

You can add, subtract, multiply, and divide numbers in Word table cells. Also you can calculate averages, percentages, and minimum as well as maximum values.

Examples
=SUM(C28,F28)
=(F30-F28)
=SUM(C29,F30)-(C28)
=SUM(ABOVE) Adds the numbers in the column above the cell you’re in.
=SUM(LEFT) Adds the numbers in the row to the left of the cell you’re in.
=SUM(BELOW) Adds the numbers in the column below the cell you’re in.
=SUM(RIGHT) Adds the numbers in the row to the right of the cell you’re in.
You can perform calculations and logical comparisons in a table by using formulas. The Formula command is found on the Table Tools, Layout tab, in the Data group.
To add up a column or row numbers in a table, use the Formula command. (A stripped-down version of the above tutorial.)

Using Bookmarks

Useful Bookmarks Example: Use bookmarks to refer to the prices of multiple products in your Word document. Bookmark each price, then display the sum of the bookmarked prices using a formula field to calculate the total.

Use Bookmarks to Repeat Text Within a Document
Assign a bookmark to the text you want to re-use, then insert a cross-reference to the bookmark text. Whenever you change the original text, you only need to update the fields in the document for the changes to apply to the second (or third) instance of that text.
Use Bookmarks to Calculate Numbers in Tables Across Multiple Tables

Do you want to calculate numbers located in one or more tables in your Word document and display the results outside of the table(s)? Here's how:
1. Bookmark each of the tables you want to refer to.

- Highlight your first table.
- Word > Insert Tab > click on "Bookmark" (icon in "Links" section).
- Enter name of bookmark (eg: "table1") and click "OK".
- Do the same for each table you want to bookmark.

2. Refer to the table name you used in your bookmark (eg: table1, table2, etc.) like shown in the code examples below.

Code Examples:
  • { =SUM(table1 B2:B3) }
The above example SUMs two numbers located in table1.
  • { =SUM(table1 B2,table2 C2) }
The above example SUMs two numbers – one located in table1 and another located in table2.
PLEASE NOTE
Word's Formula (fx) function (Table Tools > Layout > Data > Formula) is extremely finicky. When inserting a formula using this tool, make sure to insert the entire formula at one go. Subsequent edits seem to generate error messages.
If you are NOT using Word's Formula Function: Don't type in the curly braces ({}) yourself. For your code to actually work, you must insert curly braces into your Word document by pressing CTRL+F9 on your keyboard.
This tutorial is a subsection of the Use a formula in a Word or Outlook table tutorial. It describes how to bookmark specific objects on a Word document, then refer to those bookmarks in a formula. You can use this technique to calculate across multiple tables.
Use Bookmarks to Calculate Numbers in Specific Cells Across Multiple Tables
  1. Highlight the number in first table.
  2. Word > Insert Tab > click on "Bookmark" (icon in "Links" section).
  3. Enter name of bookmark (eg: "first_total") and click "OK".
  4. Do the same for each value in each table you want to bookmark.
  5. Place cursor where you want to sum the totals you just bookmarked.
  6. Press CTRL+F9 and type in an = character.
  7. Go To: Insert Tab > select "Quick Parts" > (icon in Text section) > Pull down to "Field".
  8. Scroll down the list of "Field names" and choose "Ref".
  9. Select the first bookmark name you created, then click the "OK" button.
  10. Type "+" next to the value you just inserted, then select the second bookmark and click "OK." Do the same for each bookmark you want to add.
  11. Right-click on the field set you just created by going through the above steps and choose "Update Field".
  12. To view and/or edit the formula for the number you just updated, right-click on the number and choose "Toggle Field Codes".
Sources for above steps:

Formatting Section-Specific Header & Footer Info (Section Names, Page Numbers, Etc.)

Goal: Set header/footer labels, file paths, X of Y formatted page numbering and other properties so they apply only to a specific section within a word document.
Applies to Microsoft Word 2007.

Add section breaks to a document
If your document is not divided into sections, you can insert section breaks where you want the header or footer to vary.
  1. Starting at the beginning of the document, place the cursor at the beginning of the page where you want to start varying the header or footer.
  2. On the Page Layout tab, in the Page Setup group, click Breaks, and then under Section Breaks, click Next Page.
  3. Place the cursor at the beginning of the next page where you want to vary the header or footer, such as the first page of a new chapter.
  4. On the Page Layout tab, in the Page Setup group, click Breaks, and then under Section Breaks, click Next Page.
  5. Repeat steps 3 and 4 for every section break that you want in the document.
Use a document's section breaks to vary the header or footer
If your document is already divided into sections, you can use the section breaks to configure headers and footers.
  1. Starting at the beginning of the document, click in the first section for which you want to vary the header or footer.
  2. On the Insert tab, in the Header & Footer group, click Header or Footer.
  3. Click Edit Header or Edit Footer.
  4. On the Headers & Footers tab, in the Navigation group, click Link to Previous to break the connection between the header or footer in this section and the previous section.
  5. Change the existing header or footer, or create a new header or footer for this section.
  6. In the Navigation group of the Design tab (Header & Footer contextual tab), click Next Section to advance the cursor to the header or footer of the next section.
  7. On the Headers & Footers tab, in the Navigation group, click Link to Previous to break the connection between the header or footer in this section and the previous section.
  8. Change the existing header or footer, or create a new header or footer for this section.
  9. Repeat the previous three steps for all of the sections in the document.[1]
Mini Course: Using Word 2007, create headers and footers in a document that has several parts, such as a cover page and table of contents, followed by chapters. Includes a Quick Reference Card at the end of the tutorial.
Good tutorial for adding section-specific single page numbers (ie. Page 1), but not Page X of Y formatted page numbering.
  1. Click at the beginning of the page where you want to start, stop, or change the header, footer, or page numbering.
  2. On the Page Layout tab, in the Page Setup group, click Breaks.
  3. Under Section Breaks, click Next Page.
  4. On the page that follows the section break, double-click in the header area or the footer area (near the top of the page or near the bottom of the page). This opens the Design tab under Header & Footer Tools.
  5. On the Design tab, in the Navigation group, click Link to Previous to turn it off.
    IMPORTANT: If your page number is in the header, be sure that you turn off linking for headers. If your page number is in the footer, be sure that you turn off linking for footers. Headers and footers are linked or unlinked separately.
  6. Follow the instructions for adding page numbers or for adding a header and footer with a page number.
    NOTE: Choose an alert and enter text here. You may also set it's AlertPosition property.
  7. To choose a numbering format or the starting number, click Page Number in the Header & Footer group, click Format Page Numbers, click the format that you want and the Start at number that you want to use, and then click OK.
  8. To return to the body of your document, click Close Header and Footer on the Design tab (under Header & Footer Tools).
Good tutorial for simply adding Page X of Y formatted page numbering.
Use these tutorials to configure Page X of Y formatted page numbering that is specific to each document section.
SectionPages
The SectionPages field inserts the total number of pages in a section. When using this field, you should restart page numbering from 1 in each section after the first section.
NOTE: A field code tells the field what to show. Field results are what’s shown in the document after having evaluated the field code. To toggle between viewing the field code and the field code results, press Alt+F9.
Example: To print text such as "Page 4 of 29." on each page of a document you've divided into sections, insert the following fields and text in the header or footer:
Page { PAGE } of { SECTIONPAGES }.
  1. Place your cursor where you want the { PAGE } field code.
  2. Go To: Insert (tab) > select "Quick Parts" > (located in Text section) > Pull down to "Field".
  3. Scroll down the list of "Field names" and choose "Page".
  4. In the "Format" window, choose the numbering format you want to use (eg: 1, 2, 3, ...).
  5. Repeat the steps above to place your { SECTIONPAGES } field code (but choose the { SECTIONPAGES } field code instead of { PAGE }).

Word Keyboard Shortcuts

Alt-Shift-D + Backspace + Ctrl-Shift-F9

ONLYOFFICE™ - Cloud Office Applications

Free open source office suite with business productivity tools: document and project management, CRM, mail aggregator.
ONLYOFFICE Document Server is an online office suite comprising viewers and editors for texts, spreadsheets and presentations, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
Free Alternative to Microsoft® Office | Edit word docs, spreadsheets and presentations online.
Your Free and Open Source Web-Office | ONLYOFFICE™ is a multifunctional office suite that enables you to store and co-edit documents, manage projects, email correspondence and customer relations in one place.
Edit Documents with #1 Online Office Apps | Built using HTML5′s Canvas element, it claims to combine the best of Google’s online collaboration features with Microsoft Word’s high quality formatting.

Portable Document Format (PDF)

Edit, split and merge PDFs without paying for premium software
By Catherine Ellis | March 05, 2019
Need to add text to a PDF that doesn't support editing? No problem -- and no extra software required.

Comprehensive PDF Editors

Quick and simple online service, no installation required! Split, merge or convert PDF to images, alternate mix or split scans and many other features.
- Combine and Reorder PDF Pages: Merge pages from different documents, reorder pages if needed
- Split PDF by pages: Split specific page ranges or extract every page into a separate document
- Process PDF from free, no-login online account or from downloadable software. Premium accounts available.
Open source!
- Shell interface for performing pdf manipulations such as merge or split from the command line.
- The shell interface requires Java runtime 1.8 or higher to be installed. It works on Linux, Windows and Mac.

Online PDF Form Builders

Free Online Form Builder, create HTML forms and surveys.
Calculations — Build forms with powerful calculations that can total costs, compare dates, and so much more.

Free Online PDF Creators

JotForm makes it simple to create PDF forms. Using JotForm’s easy drag-and-drop form builder, you can quickly generate a submittable PDF form that lets people send responses directly to your email and JotForm account. Create a form in minutes that can be used anywhere, regardless of device or internet access.

Free Online PDF Editors

Dave's Note: This editor written about in this article: The best free PDF editor 2019, which recommends using the online version. Unclear if online version will not add watermarks (need to investigate=== will update here afterward).
Edit, send & sign PDFs online for free.
Free Plan:
- View and edit unlimited documents
- Sign 5 documents / month
- Up to 3 signers / document
- Send 3 / month
- Email up to 3 documents / day
- Up to 3 recipients / email
- Faxes: $1.99 / fax
The Best Free Online PDF Editor & Converter: Free PDF Tools to Solve All PDF Problems With One Click
  • Excalibur: Extract tables from PDFs into Excels
Excalibur makes PDF table extraction very easy, by automatically detecting tables in PDFs and letting you save them into CSVs and Excels through a web interface.
Pricing: Start Using PDF Buddy for Free. No credit card required.
FREE PLAN: 3 PDFs/month | 1 GB storage
Create, Edit & Convert up to 3 PDF Files a month for FREE! No sign up required.
  • PDFYeah: All-in-One Online PDF Solution
Free online PDF converter that helps with your everyday PDF tasks, making it easy to compress, convert and edit PDF files online. An all-in-one free PDF solution to solve all your PDF problems.
Also See
Data Analysis#PDF Conversion

Quick Text Edit Spreadsheets

EtherCalc is a web spreadsheet. Your data is saved on the web, and people can edit the same document at the same time. Everybody's changes are instantly reflected on all screens. No sign-up required; start writing instantly. Drag and drop a .csv, .ods, or a .xlsx file to import it.
Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also download the code on GitHub.
GelSheet is a free and open source web spreadsheet that allow users to create, edit and export in many formats your everyday work. It's intended to run either standalone or integrated within another web tool. It was born as a part of Opengoo web office.

Dearly Departed Quick Edit Spreadsheets

Unfortunately, EditGrid's service was shut down on May 1, 2014.[2]

Other Text Edit Pads (Non-Spreadsheet)

Firepad is an open source collaborative text editor you can add to your own website.
What is HushPad?[3]
- Pastebin, but secured
- Latest browser built-in Web Crypto API is used for strong password-based key generation
- Password protection is always on, even if you don't specify password
- Removable notes with unrecoverable deletion
- No logs and fancy tracking: no Google analytics, Disqus, IP logging, etc.
Free online notepad | No Registration Required | Password protect options. Take notes anywhere, anytime & any device.
Your notes. Protected. Enter any URL, e.g. protectedText.com/anything - you find it - its yours! Encrypt all your notes, access anywhere. Simple. Fast. Free. No ads. Secure - don't trust us, check the code yourself.
Sync.in is a web based word processor for people to collaborate in real-time. When multiple people edit the same document simultaneously, any changes are instantly reflected on everyone's screen. The result is a new and productive way to collaborate with text documents, useful for meeting notes, brainstorming, project planning, training, and more.
TitanPad lets people work on one document simultaneously. "We are rescuing EtherPad for your use." No sign-up required; start writing instantly.
Write notes as text messages & view them on the web.

Screen Grabs

SharePoint

Have you noticed that--when working in SharePoint--the URL in your browser's address bar pointing to any SharePoint file or folder is a super-long, ugly mess? Good news! You can get a shorter, prettier URL for that file or folder, as the above tutorial explains.
Despite all the typos in the text of this tutorial, it is a pretty good step-by-step guide for moving files and folders around in SharePoint.

SharePoint Workspace

Microsoft SharePoint Workspace, previously known as Microsoft Office Groove, is a discontinued desktop application designed for document collaboration in teams with members who are regularly off-line or who do not share the same network security clearance. It is no longer included with Microsoft Office 2013 or Office 365, the latter of which includes Microsoft's OneDrive for Business instead. The latter does not fully replace the former.

Slide Decks

Web-Based Slide Decks Done Right
http://luigimontanez.com/2011/web-based-slide-decks-done-right/
SlideGo - Interactive Slides
http://www.slidego.com/home/
Speaker Deck
http://speakerdeck.com/
"Speaker Deck is the best way to share presentations online. Simply upload your slides as a PDF, and we’ll turn them into a beautiful online experience. View them on SpeakerDeck.com, or share them on any website with an embed code."
Prezi - The Zooming Presentation Editor
http://prezi.com/

Text Editors

Whether you’re a developer or a writer, a good text editor is a must-have on any computer, in any operating system. The humble text editor is great for managing code, writing down quick notes, or just as a distraction-free writing tool.
Sublime Text is available for OS X, Windows and Linux. It is heavily favored among coders. It’s distributed as evaluation software (meaning it’s free to try, but there’s no time limit on how long you can use it for free) and a full license will cost you $70. A full license is per user, so you can use it on as many computers as you like once you have one.[4]

Text Editor Tricks

To get to the Find in Files function, open up the Find / Replace dialog CTRL-H and click on the Find in Files tab.

Text Readers

Screen Readers | Text To Speech
ResponsiveVoice is a HTML5-based Text-To-Speech library designed to add voice features to web sites and apps across all smartphone, tablet and desktop devices. It supports 51 languages through 168 voices, no dependencies and weighs just 14kb.
Copy text and past it into YAKiToMe!'s web site text box, then press the "play" button. A computerized female voice will read the text back to you.

Tools & Resources

Source Citation

Generate citations in MLA, APA & Chicago formats for your bibliography. Save time by making a Works Cited page automatically!
Citation Machine automatically generates citations in MLA, APA, Chicago, and Turabian.

Email Validation Services

With this free email validation service, you can easily verify an email address and confirm if it is valid, properly formatted and really exists.
  • Verifalia (Online service that will check emails at about a penny a pop.)
Email address validation, email list cleaning, email list hygiene, email list scrubbing.
Validate single email addresses for free, or up to 100 email addresses with a trial account.

Reporting Tools

10 Tools for Creating Infographics and Visualizations
http://moz.com/blog/10-tools-for-creating-infographics-visualizations

Web Fax Services

Looks like it does not require account set-up for free fax service. Inserts ad on fax cover page.
Looks like it does not require account set-up for free fax service. Claims that it does not place ad(s) on fax. 2015-10-15 Update: The maintainer of this wiki has used GotFreeFax.com on multiple occasions. Service is free, and includes email verification after fax transmission completes successfully.
Claim's it's "Truly Free Internet Faxing." Also appears to not require account set-up to use. 2015-10-15 Update: It appears this service now requires an account; charges also now apply.
Further Reading

File Conversion Tools

CloudConvert supports the conversion between more than 200 different audio, video, document, ebook, archive, image, spreadsheet and presentation formats.
File convert service between document, image, music, video, e-book, compressed and CAD formats. No account or signup required.
Zamzar Conversion Types

URL Shorteners

You know bitly? Mosho is like that but with emojis.
Also See:
URL Shortening Services (List on Wikipedia.)

Web-Based Productivity Apps

(Scroll down the article a little ways to get to the discussion on productivity apps.)

Writing Resources

Bibliography | Cite | Citation | End Notes | Footnotes

This media file contains a PDF with a side-by-side comparison of APA, MLA, and CMS styles.
The Purdue OWL: Citation Chart
The examples in this guide are meant to introduce you to the basics of citing sources using Kate Turabian's A Manual for Writers of Term Papers, Theses, and Dissertations (seventh edition). Kate Turabian created her first "manual" in 1937 as a means of simplifying for students The Chicago Manual of Style; the seventh edition of Turabian is based on the 15th edition of the Chicago Manual.
For types of resources not covered in this guide (e.g., government documents, manuscript collections, video recordings) and for further detail and examples, you can consult the websites listed at the end of this guide, the handbook itself (LAU Ref Desk LB 2369 .T8 2007) or a reference librarian.
Typographical devices such as the asterisk (*) or dagger (†) may also be used to point to footnotes; the traditional order of these symbols in English is *, †, ‡, §, ‖, ¶.[1] Historically, ☞ was also at the end of this list.[2] In documents like timetables, many different symbols, as well as letters and numbers, may be used to refer the reader to particular notes. In John Bach McMaster's multi-volume History of the People of the United States the sequence runs *, †, ‡, # (instead of §), ‖, Δ (instead of ¶), ◊, ↓, ↕, ↑.
How to format in-text citations.
A comprehensive guide to using proper typographic characters, including correct grammatical usage.
Editor's note: Includes keyboard shortcuts for Windows and Mac.
Also See: Source Citation Tools on this wiki page.

Book Publishing

Booktype allows authors to create beautiful books for print and digital distribution. Publishers use Booktype to manage their entire catalogue in one place, providing authors, translators and proofreaders with all the tools they need. Open source Sourcefabric Booktype software gives you seamless publishing in EPUB format to all major sellers of e-books with one click.

Zip Codes

Map of the USA where you can specify a point and a radius to search within and return all the ZIP codes found inside that radius.

Quick Zip Code Lookups

Is the USPS Zip Code Lookup Tool a little too tedious for your tastes? Good news! There are less tedious alternatives.

Address verification, validation, and autocomplete. One of the nice features about this tool is you can toss an entire street address into the "street address" field (while ignoring the city, state and zip code fields) and still get a USPS-compliant address.

Zip+4 & Address Lookups

Input entire address (minus zip) into text field and Melissa Data will quickly generate a zip+4 code.
Limited to 25 lookups a day to non-registered users, and 100 per day to registered users.
Must register to use this tool. Delivers zip+4 and cleaned up addresses in multiple address batches.

See Also

Additional Resource Wiki Pages

HomeDave

References