Transcript Slide 1

50 Tech Tips for Tough Economic
Times
July 08, 2009
Panelists
Glenn Rawdon - Program Counsel for
Technology, Legal Services Corporation
 Rachel Medina - Training Coordinator,
LSNTAP
 Matthew Burnett - Project Coordinator,
Immigration Advocates Network/PBN
 David Bonebrake - Project Coordinator,
LSNTAP

Multiple Servers in One Box
VMware, the Virtual Server!
Individual Configurations
Virtual Window to Control Server
Test Desktop Systems for
Compatibility
Four Processors, No Waiting
Portable Apps
Operating System on a Stick
A Wealth of Free Applications
Open Office Portable – Word processing,
spreadsheet, database, presentation and
more
 Mozilla Firefox Portable – All your
favorites, all the time
 Cool Player and VLC media players
 Sumatra PDF Portable
 Sodoku Portable!

Office Live Online Workspaces
Access to Documents from
anywhere
Easy to Share for
Collaborations and Comments
Acrobat.com
Buzzword – Write and collaborate on
documents anywhere, anytime
 ConnectNow – Meet live over the Web and
share your screen with anyone (2 others)
 CreatePDF – Convert up to five files to
Adobe PDF online
 Share – Send files to others for easy access
while you maintain control
 MyFiles – Store your files online for easy
access from anywhere (5 GB)

Create and Share PDF
PDF Portfolios
Available in Adobe Acrobat 9
 Integrate multiple file formats into a single
PDF file

◦ Supports PDF, Emails, word processing,
spreadsheets, CAD drawing, presentations,
video and more
Can open and edit any file independently
of other files
 Easier to use than Zip files

Unlock the Power of Acrobat
Reader
(from Adobe Acrobat Pro)
Google Voice
(formerly Grand Central)
One Number for Life
Many Other Free Features

Voice Mail
◦ Hear online
◦ Have transcribed to text, then view online
Call Screening
 Record outgoing calls
 SMS
 Free outbound calls in US

Fasting Growing Segment of the
Computer Market - Netbooks








Based on the Intel Atom processor 1.6 GHz
Screen size 8.9” to 10”
SSD or HD
Windows XP or Linux
Weigh 2 – 3 lbs.
Battery life 2 hours (3 cell) to 7 hours (6
cell)
Every accessory but DVD/CD drive
The best part – below $400!
Rachel Medina
SAVE MONEY
FREE/LOW COST
PROJECT MANAGEMENT
TOOLS &
COLLABORATIVE
WORKSPACES
Low Cost Project Management Tool
Project Management – Zoho Projects

Price Comparison available
◦ http://projects.zoho.com/html/price-comparison-calculator.html
Free Project Management Tool
Project Management - Collanos
Tour: http://www.collanos.com/en/products/workplace/tour
 Download here: http://www.collanos.com/en/downloads

SAVE TIME
WORK MORE
EFFICIENTLY
WITH EXISTING TOOLS
PowerPoint Shortcuts

Last year……remember “b” for blackout?
◦ Well how ‘bout these great shortcuts….
F5
• Start
N&P
• Next Slide
• Previous Slide
# + [Enter]
• Jump to slide #
W
Home & End
Esc
• “whiteout”
• Go to first slide
• Go to last slide
• End Show
PowerPoint 2003 ONLY (sorry 2007)
1

Create a summary or agenda slide
with a few clicks!
2
3
WORD –
SHORTCUTS “YOU
SHOULD KNOW BY
NOW” & DIACRITIC
MARKS
Keyboard Short-cuts:
The Standard Short-cuts “You should know by now”
Short-cuts
Open a new word doc; Open a previously saved doc
Ctrl+N; Ctrl+O
Closes the active window, but does not Exit Word
Ctrl+W
Closes Microsoft Word (or other open program)
Alt+F4
Searches for specified text in the active document
Ctrl+F
Selects all text and graphics in the active window
Ctrl+A
Remove selection from active document (place on clipboard)
Ctrl+X
Copies the selection to the clipboard
Ctrl+C
Inserts the contents of the clipboard at the insertion point
(cursor) or whatever is selected
Ctrl+V
Saves active document with its current file name, location and
format
Ctrl+S
Prints the active file
Ctrl+P
Undo the last action. Reinstate the last action.
Ctrl+Z; Ctrl+Y
Format / Unformat text (Bold, Italic, Underline)
Ctrl+B, Ctrl+I, Ctrl+U
Keyboard Short-cuts:
Diacritic Marks
Diacritic Mark
Keyboard Short-cut
The acute accent –
(café or fiancé)
Ctrl+ ' (quote) before typing the vowel.
The grave accent - (là or où)
Use Ctrl+ ` (tick) before typing the vowel.
The circumflex accent –
(côte, fête)
Use Ctrl+Shift+ ^ before typing the vowel
The tilde - (piñata, jalapeño)
Use Ctrl+Shift+ ~ before typing the letter.
The umlaut- (Chloë, naïve)
Use Ctrl+Shift+ : (colon) before the vowel
The cedilla – (façade, soupçon)
Use Ctrl+ , (comma) before the letter
The ring –
(the Angstorm symbol - Å)
Use Ctrl+Shift+@ before the letter
The compound AE (hæmoglobin)
Use Ctrl+ & before a
The German S - (straße)
Use Ctrl + & + s
Word - Set up Custom Categories
for Tables of Authorities
Setting Up Categories


Insert>Reference>
Index and Tables>
Mark Citation>
Category,
OR
Alt+Shift+I>Category
The first seven
categories are predefined. Scroll down
until you find an unused
option (8, 9, 10, etc.)
Replace the # with your
own custom category.
Outlook – Quickly View Your
Agenda for Multiple Random Dates

Ctrl + “click”
Outlook – Calculate “Tickler” Dates

Use special instructions in “Start Time” to
calculate important dates!
Syntax for Calculating “Tickler” Dates
Days
• 30 days before 3/23/2010
• 30 days after 3/23/2010
Weeks
• 6 weeks before 3/23/2010 [or 6 wk before 3/23/2010]
• 6 weeks after 3/23/2010 [or 6 wk after 3/23/2010]
Months
• 5 months before 3/23/2010 [or 5 mo before 3/23/2010]
• 5 months after 3/23/2010 [or 5 mo after 3/23/2010]
Excel – Calculate Days Between
Dates (NETWORKDAYS)
NETWORKDAYS – how it works…
A3 →
A4 →
A5 →
.
.
.
A14 →

# of Business Days (or “court” days)
=NETWORKDAYS(B17,B18,A3:A14)

B17  First Day
B18  Last Day
A3:A14  refers to
the range of dates
included in the list
←B17
←B18
of holidays
Excel – paste special/transpose
Flip your data!
Highlight and Copy
the spreadsheet
 Select Paste Special
 Check “Transpose”
 Click OK

Excel - Shortcuts
F4
Alt+Enter
Ctrl+Shift+A
Ctrl+A
Data/Subtotal
• Switch from absolute to relative reference &
vice-versa
• Line break within a single cell
• Reveal formula format
• Formula wizard
• Auto subtotal and grand total lines inserted
by Excel; simply sort your data, then select !
Excel - Shortcuts

Ctrl+A gives you the formula wizard!
Data/Subtotal Creates Quick
Subtotals and a Grand Total!
Data/Subtotal Creates Quick
Subtotals and a Grand Total!

Collapse to
view just
the totals
Cool Google Stuff…
(from PC Mag)
•Sky
•Search nearby
•Use business name/
category in directions
search
•Public transit directions
•My Maps
•Check gas prices
•Check traffic
•Street view
•Editing Google Maps
•Weather in Google Earth
•Weather
•Movies
•Area codes
•Package tracking
•Flight status
•Measurement
conversions
•Currency conversions
•Calculator
•Definitions
•Q&A
One for fun!......Track This
http://www.usetrackthis.com/
 Get the whereabouts of shipments sent
to you anywhere!

Matthew Burnett
drop.io
PrinterShare
Evernote
Pidgin
Jing
ZumoDrive
ManyEyes
Zamzar
Writeboard
Create
Versions
Invite
Track & Edit
Dabble DB
Image Resizer
PINs
Quarkbase
David Bonebrake
Website Grader
http://www.websitegrader.com/
 Assigns a grade on how well your site is
doing on search engine optimization
(SEO)
 Provides practical tips on how to improve
your search engine rankings

Website Grader
Quick (and Easy) SEO Tips
Links are crucial: have partners link to you
 Update content regularly – blog, Twitter,
create YouTube videos for clients
 Use keywords within your links:

◦ Meet our Pro Bono lawyers vs.
◦ Click here to learn about pro bono efforts

Join NTAP’s free SEO training for over an
hour of great SEO tips:
lsntap.org/upcomingtrainings
Online Reputation Management

See who is linking to your website using
Google’s link: operator
Finding Who Links to Your Site
Google Apps for Your Domain

www.google.com/a
Gmail Labs
Added in 2008, Gmail labs allows users to
test new or experimental features of
Gmail.
 Currently about 45 features available,
including:

◦
◦
◦
◦
Offline Access
Tasks to-do list
Undo Send
Multiple Inbox
Gmail Labs
GMinder
YouTube Nonprofit Channel
http://www.youtube.com/nonprofits
 Free YouTube upgrade for 501(c)(3)
organizations
 Users get free nonprofit branding,
fundraising tools, and increased upload
capacity
 Don’t know how to make a quality web
video on a small budget? YouTube has
resources that can help.

Nonprofit Video Help
Open Office for WPD Conversions
Open Office - A free, open source
productivity suite featuring word
processing, spreadsheets, presentation
software
 One area where OpenOffice tops
Microsoft is opening legacy files,
specifically older Word Perfect files

Remora
http://download.cnet.com/Remora-USBDisk-Guard/3000-2092_4-10420433.html
 Free, easy-to-use encryption tool
 Great for encrypting a storage device
such a USB thumbdrive so that your
documents and data would not be
exposed if your lost your device

Install Remora on Your USB
Now Encrypt Your Files
Google Analytics
Quikmaps.com
Add a Map to Your Webpage
Thank You!

Slides, the recorded presentation, and
Rachel’s Excel calculator will be on
LSNTAP.org shortly.