This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
This video shows you how to easily access the hidden Motorola Droid menu and how to improve call quality. The first thing you have to do is dial and call: ##7764726 . Then, type in the SPC Password, which usually is 000000 (six 0s) and hit OK. Next, click 04.Vocode in the popped up menu and choose either EVRC or EVRC-B for the highest call quality. Tap apply. Please note that better call quality requires more battery, so the battery will go down easier. That's it! Good Luck!
Windows 7 is the hot, new operating system replacing the past XP and Vista systems. Windows 7 is the most simplified, user-friendly version that Microsoft has developed - ever. Get acquainted with your new version of Windows straight from Microsoft.
Restaurant City is a Facebook game that allows you to create your own restaurant. Watch this video tutorial to learn how to hack Restaurant City (09/25/09). See how to hack stamina, cook fast, work fast, serve fast and bill fast!
This is a Restaurant City 3 in 1 Hack (Working From 12th May 2009).
Are you playing through Dark Souls and having flash backs to all those times you died in Demon Souls? IGN is here to help you with several tips and tricks on surviving. This guide shows you good spots to grind, what gift to pick for your character, and where to get the Sorcerer's Catalyst item that will allow you to cast magic in the game, even if you aren't a magic user.
If you're interested in finding out how to play Xerath in League of Legends, take a look at the Xerath Champion Spotlight from Riot Games. In it, you'll see what runes, masteries, and items Xerath can be built with, and how Phreak plays him on both Summoner's Rift and the Dominion map of Crystal Scar.
The low price of speakers and MP3 players today make them ideal for adding a bit of sound to different items, and this tip from CNET reveals a few ideas. Add an MP3 player and a pair of speakers to a decoration, for example.
If you want to put the finishing touches on your new BioShock cosplay outfit, of if you just think it would be awesome to charge at your friends with the favorite weapon of Big Daddys across Rapture, this is a guide for you.
A perfect project for the budding roboticist in you! This video shows you how to make a small robot gripper using basic household items. Press the button and make the robot's come together! You will need: a small blow torch or butane lighter, a glue gun, a dremel or rotary tool (along with several different bits), the free cutting pattern, a permanent marker, a micro servo, some small nails or pins, a small piece of Plexiglass and a paperclip. If you don't have access to a dremel, you can fak...
Wilderness survival requires smarts, know how and a well equiped emergecy kit to make sure you stay dry, warm and fed. This excellent video tells you what you need to know to put together the essential items of your personal emergency/survival kit. The items include:
In this video, we learn how to use a rotary cutter with Kenneth D King. Before you begin, make sure to use a cutting mat so you don't damage the top of your surface. To cut your item, you simply place the rotary cutter on the bottom of the item, then run it through until you have reached the top, or the desired area you want to cut. If you want to cute with a different shape, then you can purchase different cutters that will create shaped edges on what you are cutting. After this, place your ...
In this video tutorial, viewers learn how to speed up the Windows XP Start menu. Begin by clicking on the Start menu and select the Run program. Then type in "regedit" and click on OK. Now select H KEY_CURRENT_USER, go to Control Panel and click on Desktop. On the right side of the window, scroll down the list to find Menu Show Delay. Double-click on it, change the value to 0 and click OK. This video will benefit those viewers who use a Windows computer, and would like to learn how to speed u...
It's time to teach your kids about animals! To get your little one thinking like an animal, why not help them look like one? In this tutorial, featuring John Lithgow, learn how to turn common household items like paper plates and paints to create fun, realistic looking animal masks with your kids! You will also learn how to make special doggy treats and bird feeders so that you can really get on all fours with your animal buddies! Have fun!
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
In this instructional video, the young host demonstrates an excellent method for cleaning your DVD's, CD's, and Game discs using simple, easily found items that you always have laying around your house. The toothpaste he uses acts as a super mild abrasive (almost exactly the same that is used in professional kits, except they don't get the benefit of a minty fresh smell) that removes minute dirt and debris that gets stuck on the disc. When cleaning your discs, be sure to rub the toothpaste in...
Hurricanes can occur any time with out any warning. So it is prudent to prepare you self for disaster recovery in case of any hurricane. To protect your self from hurricane by staying at home or to flee from a hurricane you will need some items ready. The main thing is water. So arrange for one gallon of fresh water for one person per day. It is good to store water sufficient for one week. So store enough quantity of water for all the persons in the home sufficient for one week. Make sure tha...
This video illustrate us how to make a hovercraft with common household items. To build one, first of all, collect all of the items required for making it. You need a CD, bottle cap, balloon and super glue. Then start by applying glue to the lower end of the cap and sticking it to the center of the CD and let it dry. After it has dried, blow up the balloon and secure it up on the bottle cap tightly. Now open the bottle cap and let the balloon deflate.
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
Do Try This at Home brings us video on how to create a cloud in a container. With just a few simple items household items we can create a cloud. He explains to us the science behind what he is doing and why is works the way it does. After that he demonstrates how to create the cloud with quite amazing results. He easily has created a cloud and suggests that we try this at home because it much easier to see and enjoy in person.
Club Penguin is a flash-based website with an a virtual world of online games for kids to play. Learn how to hack Club Penguin with tricks and cheats. Watch this video tutorial to learn how to find hidden items in the Club Penguin catalog (09/29/09).
Get into a menu in the Coke machine. This video offers the code for hacking into a Coke machine menu. This may not work for every machine, but should work for some.
A downloaded application that allows you to change your menu bar look to open up some more stats you can check up on.
This tutorial demonstrates how to quickly and easily create graphical navigation bars with DHTML menus for your website, using Xara Menu Maker.
Twitter can be a wonderful place for people to express their emotions and chat with each other in brief. However, it can also be a breeding ground for hateful comments, foul language, and a whole lot of political talk.
Android 6.0 introduced a new feature called Direct Share that allows apps to pin a more specific set of targets to Android's share menu. You've probably seen it already—messaging apps will allow you to share a file directly to a specific contact instead of just to the main app, and there are several other implementations like this.
Whether scheduling meetings, events, tasks, or even keeping tabs on the weather, a good digital calendar can help you stay on top of your game in ways that a normal calendar could never do. Indeed, there are many calendars to choose from, but Google Calendar is one of the best due to Google's excellent cloud service, feature-rich web-client, and their easy-to-use Android and iOS applications.
Android 6.0 Marshmallow is bringing in lots of changes to our favorite smartphone operating system, ranging from battery-saving tweaks like Doze to a Now on Tap feature that essentially bakes Google right into every app on your phone. But for folks that like to tweak the interface of their device, a new hidden menu might be the most exciting addition of them all.
We recently showed you 8 menu bar apps that ever Mac power user should have, covering apps that allow you to control iTunes, eject drives, organize screenshots, and more—all from that tiny strip at the top of your screen.
The world's most commonly-used desktop operating system is getting a huge makeover in the form of Windows 10. While there are many sweeping changes in this new version, some of the smaller tweaks may prove to be the most useful.
The menu bar is a great place to perform quick searches, track battery life, and switch Wi-Fi networks on your Mac, but it can do way more than that if you let it. I've rounded up some menu apps below that not only have features that will boost your productivity, but are lightweight enough to run entirely from the menu bar.
AMOLED display panels like the one found in most Samsung Galaxy devices, including the Galaxy S6 models, are known for their deep blacks and vivid colors. The downside here is that the colors tend to be over-saturated and not very realistic.
For those of you who have been taking full advantage of the jailbreak for iOS 8 that's available, you can understand and appreciate what this really offers iPhone users—sovereignty.
Windows 8 may have introduced a new, intuitive touch-based interface, but plenty of Microsoft loyalists were unhappy with the absence of the classic start menu that they were so accustomed to.
Android 5.0's Material Design is truly a sight to behold. With beautiful transition animations and brand new system menus, Android has never looked better.
Many of our everyday apps include a menu tab or search bar, like Chrome and Twitter. In fact, a lot of times those are the first things we go for, as search is universal in most apps, and app settings are just about always accessible through the menu.
Ever since Android 3.0 Honeycomb, Google has been trying to push phone manufacturers to do away with physical menu buttons. Samsung has been one of the lone holdouts, retaining the menu key up until the Galaxy S5, where they finally replaced it with a "recent apps" multitasking button.
Overview of pre-built navigation menus in Xara Web Designer designs gallery. The navigation menus in Xara Web Designers designs gallery allows you to choose from a list of navigation designs without having to design it by hand. If you need assistance using Xara Web Designer let us know and we will do our best to create web design tutorials to help you.
Throughout history, almost every superstition dealing with evil has had something to do with left hands. In the seventeenth century, it was thought that the Devil himself baptised his followers using his left hand. Today, studies show that left-handed people are more likely to be schizophrenic, alcoholic, delinquent, dyslexic, have Crohn's disease and ulcerative colitis, and a slew of other medical problems. To top it all off, left-handed people have an average lifespan that is 9 years shorte...
