850 likes | 1.05k Views
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
E N D
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
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!
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)
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
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 MoneyFree/Low Cost Project Management Tools & Collaborative Workspaces
Project Management – Zoho Projects • Price Comparison available • http://projects.zoho.com/html/price-comparison-calculator.html
Project Management - Collanos • Tour: http://www.collanos.com/en/products/workplace/tour • Download here: http://www.collanos.com/en/downloads
PowerPoint Shortcuts • Last year……remember “b” for blackout? • Well how ‘bout these great shortcuts….
PowerPoint 2003 ONLY (sorry 2007) • Create a summary or agenda slide with a few clicks! 1 2 3
Keyboard Short-cuts: The Standard Short-cuts “You should know by now”
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!
NETWORKDAYS – how it 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 A3 → A4 → A5 → . . . A14 → ←B17←B18
Excel – paste special/transpose Flip your data! • Highlight and Copy the spreadsheet • Select Paste Special • Check “Transpose” • Click OK
Excel - Shortcuts • Ctrl+A gives you the formula wizard!
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!