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