Difference between revisions of "Office Productivity Hacks"

From TeleCafeWiki
Jump to navigation Jump to search
(See Also + Migrated Quick Edit Sheets from Spreadsheet Tricks to here.)
(→‎Google Drive: Moved content from Computer Productivity Hacks.)
Line 1: Line 1:
 
{{RightTOC}}
 
{{RightTOC}}
 
== Google Drive ==
 
== Google Drive ==
 +
* [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).
 +
: <code>Ctrl+?</code> to see other such keyboard shortcuts.
 +
 +
* [https://support.google.com/drive/answer/179738?hl=en Keyboard shortcuts for Google documents]
 +
 
=== Mail Merge ===
 
=== Mail Merge ===
 
; Yet Another Mail Merge
 
; Yet Another Mail Merge

Revision as of 12:16, 28 March 2015

Google Drive

Select what you want to strike and click Alt+Shift+5. (Option+Shift+5 for Mac).
Ctrl+? to see other such keyboard shortcuts.

Mail Merge

Yet Another Mail Merge

Keyboard Shortcuts

MS Word

  • Key command for inserting non-updating date:
Alt-Shift-D, Backspace, Ctrl-Shift-F9

Quick Edit Sheets

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.

Dearly Departed Quick Edit Sheets

Unfortunately, EditGrid's service is ending May 1, 2014.[1]

Other Edit Pads (Non-Spreadsheet)

Firepad is an open source collaborative text editor you can add to your own website.
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.

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 Readers

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

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

Miscellaneous Tools

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

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.
Claim's it's "Truly Free Internet Faxing." Also appears to not require account set-up to use.
Further Reading

Zip+4 Lookups

Melissa Data Address Check
http://www.melissadata.com/lookups/AddressCheck.asp
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.
Melissa Data Batch Address Check
http://www.melissadata.com/lookups/batchaddresscheck.asp
Must register to use this tool. Delivers zip+4 and cleaned up addresses in multiple address batches.

See Also

References