Transcript Slide 1

50 Tech Tips for
Tough Economic Times
Equal Justice Conference
May 15, 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!
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/pricecomparison-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 Shortcuts “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

Do cases, courts, and page numbers haunt
you in your dreams? No fear categorizing
cases in a Table of Authorities is easier
than you think!
Setting Up Categories


Insert>Reference> Index
and Tables>
Mark Citation> Category,
OR Alt+Shift+I>Category
The first seven categories
are pre-defined. 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!
Outlook –
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 fx)
Excel – How NETWORKDAYS
works…

# 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 of holidays
Excel – paste special/transpose

Flip your data!
Make your rows columns
and your columns rows!
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!

drop.io
PrinterShare
Evernote
Pidgin
Jing
ZumoDrive
ManyEyes
Zamzar
Writeboard
Create
Versions
Invite
Track & Edit
Dabble DB
Image Resizer
PINs
Quarkbase
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