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. These cheatsheets have the keyboard shortcuts for mainpulating files, editing content, changing formatting and navigating around workbooks. 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
Harry Potter 7.1: The Drinking Game | FM Though it may be hard to believe, it’s already been nine years since Potter-heads around the world were introduced to the silver-screen personalities of Harry, Ron, and Hermione in the movie “Harry Potter and the Sorcerer’s Stone.” Maybe it seems kind of creepy that we’ve been watching them grow up right before our eyes (oh hey, Emma Watson), but we’ve been growing up right alongside them, and now it’s time to celebrate the bittersweet—but still triumphant —beginning-of-the-end. FM thought of no better way to celebrate than to grab our friends and a mug of our favorite wizarding libation (toss-up butterbeer or firewhiskey) and get in touch with our inner spell-caster as we watched “The Deathly Hallows: Part 1.” —Whenever somebody casts a spell, take a sip (take a gulp if Hermione casts it). —If you hear the full name “Harry Potter,” take a sip (two if the person saying “Harry Potter” sounds particularly surprised or confounded). —If somebody casts “Avada Kedavra,” kill your drink.
HOW TO Use the CTRL Key to Dominate Your Computer Jun 15, 2010 Ahoy hoy friends! Here’s my first attempt at the ever-popular infographic. I really wanted it to be helpful and informative. I figured that any tips that can save you time and make you more efficient is a beautiful thing! If you’re like me, you probably spend a lot of time in front of a computer. If you enjoyed this article, the Sifter highly recommends: HOW TO GRASP SIZE, SCALE AND TEMPERATURE WITH THREE GIANT INFOGRAPHICS
Top 11 Weirdest Burgers: A Tribute Beef: It's what's on the Web! At least it seems there is no shortage of crazy burger pics and impressive (if not a little gross) works of "hamburger art." This homage to the all-American love of beef patties is enough to bring a tear to your eye (and cholesterol to your arteries!). To all my carnivores out there -- here are our fave Web Hamburgers: The Sneaker Burger The Burger Pumpkin The Wooden Burger The "Hamburger Fatty Melt" (the buns are grilled cheese sandwiches) The World's Smallest Burger (yes, it's 100% edible!) The 15 Pound Burger (he ate the whole thing - in one sitting!) The Hamburger Dress Lego Burgers Burger Cakes The Inflatable Burger Climb Fabric Burger + Fries And just to round out this ode to artery-clogging goodness: BEEF FONT! [Click Images for Photo Sources]
How to Make Facebook Emoticons Instructions Things you will need: A Facebook account Someone to talk to on Facebook Step To do the common smiley face, simply do :). To get a bit more creative with your emotions, you can be sad by typing :(, and to show that you are crying, :'(. To make a smiley that is very happy, type in ^_^. If you'd like to get a bit more creative, make a devil by entering 3:), and if you've been good, an angel is O:). To make a smiley with glasses, 8).
Everything you ever wanted to know about C types, Part 1: What's in a type? The C language provides a fairly elaborate system for data types. This series provides an overview of the C type system, as well as some detailed discussions of some of the musty corners people don't normally know about. It is worth learning. As Henry Spencer wrote: A programmer should understand the type structure of his language, lest great misfortune befall him. The C type system has been adapted to a great number of architectures. If you learn nothing else from these articles, learn this: On any C language implementation compliant with any C standard ever written, sizeof(char) is exactly one, whether char is eight bits, 16, 60, or 64. The first article of the series introduces the type system itself, explaining the basic types and the system of type qualifiers and storage-class specifiers. What do we mean by a type? The type of an object in C describes the way in which a chunk of memory is associated with a value. One of the most fundamental aspects of a type is its size. Listing 1.
Coolest Events Around The World Here are the most bizarre/amazing events around the the world that you are missing out on every year by not exploring. This is motivation for you to go out and see what else is out in the world! (I apologize in advance for making your local concerts and street fairs look like petting zoos) Bunyol, Spain — August 26th – 11am Every year 30,000 people assemble in the streets of Bunyol, Spain to participate in the largest tomato fight in the world. 125,000 kg of tomatoes are brought into the city via truck so ammunition is never short. 5 massive tomato-packed rockets are exploded in the air to commence the fight. 1) You must squish each tomato before throwing it so that the force of the vegetable against you target’s head will not cause injury 2) Only tomatoes can be thrown ‘Black Rock City’, Nevada, USA — September 3rd-5th The official site for Burning Man describes the event as “a city in the desert dedicated to radical self reliance, radical self-expression and art.” Thailand — April 13-15
How to win Rock-paper-scissors every time I admit it. When I first heard there are actual tournaments for Rock-paper-scissors, sanctioned by the World Rock Paper Scissors Society, I laughed. I mean seriously, $50k to the winner of a game that requires no skill whatsoever? Absurd. Rock-paper-scissors isn't just a silly game kids play or a way to decide who has to be the designated driver at parties. Males have a tendency to throw rock on their first try, inexperienced RPS players will subconsciously deliver the item that won previously, and paper is thrown least often, so use it as a surprise. Nokia Liquid Phone by Rune Larsen A Phone That’s Not Afraid to Mess with Water Among the grievous wrongs done by touchscreen technology, the worst is its disregard for tactile feedback. Without the pleasant sensation of a button being pressed, we are woefully incapable of using any gadget without complete visual attention. Designer: Rune Larsen
Help - Tip: Give Your Browser a Windows 8 Look Tips, Solutions & How Tos You'll have to wait a year for the real thing, but in the meantime, if you want a dash of Windows 8, here's a little sustenance for you. A clever Czech Web programmer/designer named Ľubomír Krupa has come up with a way to give your browser the tiled Windows 8 Metro UI look. Of course, this tip won't give you the full Windows 8 tile functionality—it won't update the current weather or stock prices in tiles, but if you crave the Metro look, it's a start. Krupa offers the customization under the MIT license, which means it's free to use, copy, modify, merge, publish, distribute, sublicense, and/or sell, as long as the copyright info stays intact. To start your move toward a Windows 8 look, you first need to download the zipped folder contents used by the start page. You can get it from this DeviantArt download page. Next, copy the full pathname by clicking in the Windows Explorer address bar: on my PC, this was C:\Users\mmuchmor\Downloads\Win8Start to this:
Dictionary of Algorithms and Data Structures This web site is hosted by the Software and Systems Division, Information Technology Laboratory, NIST. Development of this dictionary started in 1998 under the editorship of Paul E. Black. This is a dictionary of algorithms, algorithmic techniques, data structures, archetypal problems, and related definitions. Algorithms include common functions, such as Ackermann's function. Problems include traveling salesman and Byzantine generals. Don't use this site to cheat. Currently we do not include algorithms particular to business data processing, communications, operating systems or distributed algorithms, programming languages, AI, graphics, or numerical analysis: it is tough enough covering "general" algorithms and data structures. Some terms with a leading variable, such as n-way, m-dimensional, or p-branching, are under k-. To look up words or phrases, enter them in the box, then click the button. The URL is an alias which should continue to refer to DADS.
Winners and Losers from Roller Coasters (62 Pics) Today we present you Roller Coaster picdump.. Moments when people make the most weird faces without knowing how they look. 100 Websites You Should Know and Use In the spring of 2007, Julius Wiedemann, editor in charge at Taschen GmbH, gave a legendary TED University talk: an ultra-fast-moving ride through the “100 websites you should know and use.” Six years later, it remains one of the most viewed TED blog posts ever. Time for an update? We think so. To see the original list, click here. And now, the original list from 2007, created by Julius Wiedemann, editor in charge at Taschen GmbH.
Anthropomorphic + Futuristic = Fantastic Floating Homes Futuristic, yet, but not the far-fetched science-fiction fantasy industrial design you might think – the Oculus by Schoepfer Yachts may not be for sale yet but it is already in pre-production mode with naval architects on board, so to speak. Hardly your typical houseboat, it is a virtual cruise ship for the rich and famous who can afford to buy it when it is fully planned and built. The anthropomorphism of this luxury floating home is of course intentional – the front deck like the gaping mouth of a gigantic sea creature and the sleek curves mimicking streamlined oceanic animals. Complete with a swimming pool on top and a futuristic interior design this is far more like a permanent mobile home than a cruising yacht. The smaller and simpler (both adjectives applied relative to its bigger brother of course) version of this spectacular design is the Infinitas, with a more sleek and streamlined profile and a semi-enclosed on-board swimming pool in the center but underneath the shell.