The Ultimate Excel Cheatsheet Working with the new Excel 2007 is now more frustrating than ever when it comes to finding the right commands. Sometimes it seems like part magic and part luck. That’s why we’ve put together the cream of the crop of Excel shortcuts in easy to use cheatsheets you can print up and keep handy. Highlighting the most commonly used and commonly looked for Excel commands, this list puts it all at your fingertips. Learn how to get around Excel using only the keyboard. Excel Function Cheatsheets The key to being efficient with Excel is knowing which functions to use. Excel Formula Cheatsheets If you need specific calculations, this is a good place to start. How To Read Cell References Simple Math Formulas From Microsoft.com Adding Numbers Calculate Percentages Rounding Numbers Advanced Excel Tips From Microsoft.com Guidelines and Examples Of Array Formulas How to import data from Microsoft SQL Server into Microsoft Excel Macro to Extract Data from a Chart In Excel Date And Time VBA Code From cpearson.com
How-To Install Android SDK On Windows, Mac and Linux Here’s a quick start installation guide to get you up and running with the Google Android Software Development Kit (SDK). This guide will describe how to install the Android SDK and set up your chosen development environments. If you’ haven’t already done so you can download the Android SDK from the link below, then we can get started. First you’ll need to download the Android SDK source files: ( ) System Requirements In order to first use the Android SDK code and tools for development you will of course need a suitable environment develop from. Currently the following operating systems are supported: Windows XP or VistaMac OS X 10.4.8 or later (x86 only)Linux (tested on Linux Ubuntu Dapper Drake) You will also need to install a suitable development environment such as: Eclipse Eclipse 3.2, 3.3 (Europa) Android Development Tools plugin (optional) Other development environments or IDEs Installing The Android SDK To add /tools: Linux Mac OS X Alternatively:
The Ultimate Dropbox Toolkit & Guide Dropbox, the app we all (at least many of us) know and love, has a plethora of advanced uses to make life so much easier in managing data between multiple computers and online. We’ve posted several roundups of tips and tricks for Dropbox and now we present our ultimate toolkit and guide. We’ve pulled all our tips and tricks together and added quite a few more. Additionally, share your Dropbox tips and tricks and we’ll update the list to share the fun with everyone. Dropbox? Not familiar with Dropbox? Is Dropbox a web app? Dropbox is software that syncs your files online and across your computers. Dropbox Tour The secondary component of Dropbox is the web app. So what else can you do with Dropbox? Tips & Tricks Dropbox seems to have an ever growing list of fun things you can do with the app, so instead of scrolling through one massive list to find something that interests you, use the list below to skip straight to the section you’d like to read. Basic Tips List Advanced Tips List Basic Tips Mac
Geekzine.info How to bypass SOPA restrictions Congress will probably vote on SOPA soon. We don’t yet know what the outcome will be, but we do know that the copyright industries have donated heavily to nearly every senator and representative in Washington. If the measure (or a slightly modified version, like PIPA) passes, then the internet will be fundamentally altered. As it stands, the internet is like an open highway, where — apart from engaging in blatantly incriminating acts like terrorism, spilling government secrets, or distributing child porn — you’re basically free to do what you want. Though some people find comfort living in a world of rules and authority figures, most modern thinkers would rather lean in the direction of personal liberty. DeSOPA One clever developer wasted no time in coming up with his own solution. Of course there aren’t yet any SOPA restrictions in place, but the DeSOPA method should be sound. Get DeSOPA Browse by IP address This is the DIY version of DeSOPA. ping geek.com Tor What are the drawbacks?
15 Free Guides That Really Teach You USEFUL Stuff Advertisement Over the past months, we’ve written quite a few PDF manuals for you, on all kinds of diverging subjects, including BitTorrent, iTunes, iPhone, Twitter, Mac, Linux, Photoshop and several other topics. Freely available to MakeUseOf subscribers, there are now multiple manuals released every month, for everyone to enjoy. After releasing 15 manuals and nearly half a million downloads we thought it was about time to look back and review what has been published so far. Enjoy! Do us a favor by sharing those manuals friends! 1 – Internet Guide for the Movie Addict Written by Saikat Basu, this entirely free PDF production will show you anything you’ve ever dreamed about knowing related to movies on the web. Original Post | Download NOW 2 – Internet Guidebook for An Audiophile Original Post | Download NOW 3 – The Incredible Free Manual for Every Mac User Original Post | Download NOW 4 – The Underground Guide to the iPhone Written by Stefan Neagu. Update: The guide is no longer available.
Need a Basecamp Alternative? | PM-Sherpa Basecamp prides itself on providing their customers, for 17 years now, with the utmost user-friendly program. Their goal is to continue providing their basecampers with a product that is at the highest level of integrity and quality. Oh but wait! Subtasks – Task Dependencies – Gantt Charts – Kanban Boards – Export to Excel Workload Reports – Cost Tracking – Time Tracking – Import Microsoft Project Files As Basecamp is simply not up to par, what do you do? Not Satisfied with Basecamp?
Unifi – Bring your digital world together Korben - Actualité informatique high tech et geek The Beginner’s Guide to Using QoS (Quality of Service) on Your Router Not all Internet traffic is equal. Streaming HD video or having a stutter-free Skype call is probably more important to you than downloading a big file. The Quality of Service feature on your router lets you prioritize the things you care about, so they happen faster than the things you don’t. What Exactly Is Quality of Service? Quality of Service is an excellent and underutilized tool that allows you to train your router to divvy up your available bandwidth between applications. It may help to think about Quality of Service like this: Let’s pretend, for a moment, that your Internet connection is a hospital where the available bandwidth is the number of doctors available to treat patients. On a normal network, the triage nurse is indifferent to the condition of the incoming patients and simply assigns them to any available doctors, progressively spreading the staff of the hospital thinner and thinner with no regard for the severity of the patient’s situation. Why use a reduced value?
High Dynamic Range (HDR) Photography: Tutorials, Tips and Stunning Examples Taking amazing photos is something many aspiring amateur photographers strive for. And HDR effects can really make your images pop. Below is a complete toolbox to get you started with HDR photography on your own. HDR – In a nutshell HDR stands for High Dynamic Range. There are two basic types of HDR photos. Basic Equipment for HDR Photography If you’re interested in creating real HDR images, you’ll need slightly higher-end equipment than many amateur photographers have. A camera capable of taking images in RAW formatA good quality tripodSoftware such as Photomatix or Photoshop The RAW format camera is going to be the main sticking point for many photographers. If you want to create faux HDR photos, all you really need is a good point-and-shoot (or DSLR) camera and Photoshop. HDR Tutorials The tutorials included here are based on combining multiple photos with different exposures into a single HDR image, using Photoshop or other tools. Faux HDR Tutorials Great Examples of HDR Photos By caese
Top 100 Tuesday: 100 Best Movies of the Decade EmailEmail Since we first published our 100 Best Movies of the Decade in 2009, films have continued to get bigger and better. Here’s an update to the original list. Here’s what we originally wrote five years ago. We are leaving Kubrick behind and fast approaching Hyams. Quick Year-to-Year by the Numbers: 2009 – 11 2008 – 11 2007 – 7 2006 – 14 2005 – 12 2004 – 8 2003 – 7 2002 – 12 2001 – 10 2000 – 8 100. 99. 98. 97. 96. 95. 94. 93. 92. 91. 90. 89. 88. 87. 86. 85. 84. 83. 82. 81. 28 DAYS LATER… (2002) – Danny Boyle 80. 79. 78. 77. 76. 75. 74. 73. 72. 71. 70. 69. 68. 67. 66. 65. 64. 63. 62. 61. 60. 59. 58. 57. 56. 55. 54. 53. 52. 51. 50. 49. 48. 47. 46. 45. (500) DAYS OF SUMMER (2009) – Marc Webb 44. 43. 42. 41. 40. 25th HOUR (2002) – Spike Lee 39. 38. 37. 36. 35. 34. 33. 32. 31. 30. 29. 28. 27. 26. 25. 24. 23. 22. 21. 20. WHO WANTS TO BE A MILLIONAIRE? 19. 18. “My name is Gladiator.” 17. 16. 15. LOST IN TRANSLATION is one of my favorite films of all time. 14. 13. 12. 11. 10. 9. 8. 7. 6. 5. 4.