Difference between revisions of "Office Productivity Hacks"

Revision as of 20:26, 16 November 2014

Google Drive

Mail Merge

Yet Another Mail Merge

Yet Another Mail Merge (Installation script.)
Yet Another Mail Merge (App web page.)
Yet Another Mail Merge (YAMM) - FAQ
Create a Mail Merge with Gmail and Google Drive / Docs (Video tutorial for using Yet Another Mail Merge.)

Keyboard Shortcuts

MS Word

Key command for inserting non-updating date:

Alt-Shift-D, Backspace, Ctrl-Shift-F9

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/

Tools

Email Validation Services

Cobisi - Free email validation service

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.

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

FaxZero

Looks like it does not require account set-up for free fax service. Inserts ad on fax cover page.

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.

Popfax.com

Claim's it's "Truly Free Internet Faxing." Also appears to not require account set-up to use.

Further Reading

10 Best Free Online Fax Services

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.

@@ Line 7: / Line 7: @@
 * [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.)
-== Tools ==
-=== 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.
 == Keyboard Shortcuts ==
@@ Line 21: / Line 12: @@
 * Key command for inserting non-updating date:
 : <tt>Alt-Shift-D, Backspace, Ctrl-Shift-F9</tt>
-== 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.
 == Slide Decks ==
@@ Line 35: / Line 19: @@
 :"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/
+== Tools ==
+=== Email Validation Services ===
+* [http://cobisi.com/email-validation/validate-address Cobisi - Free email validation service]
+: With this free email validation service, you can easily verify an email address and confirm if it is valid, properly formatted and really exists.
+* [http://verifalia.com/ 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.
+=== 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 ==
@@ Line 48: / Line 48: @@
 ;Further Reading
 * [http://webseasoning.com/technology/10-best-free-online-fax-services/1106/ 10 Best Free Online Fax Services]
+== 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.