Office Productivity Hacks
Revision as of 08:39, 6 April 2015 by Dave (talk | contribs) (→Zip Codes: Find ZIP Codes Inside a Radius)
Google Apps
- Select what you want to strike and click
Alt+Shift+5
. (Option+Shift+5
for Mac). Ctrl+?
to see other such keyboard shortcuts.
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.
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
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 Codes
- Find ZIP Codes Inside a Radius - (A service of Free Map Tools.)
- 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
- 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
- Computer Productivity Hacks
- Social Networking Tips
- Spreadsheet Tricks
- User:Dave/Web Hack Notes (Non-Wiki)