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...
How to pick the right RAM for your computer
Check out this video tutorial to see how you can make a paper role playing game. This is a fun little fantasy game that you can download and print on your computer, then cut out, assemble, and play! It is called "Enter the Labyrinth and Rescue the Princess".
WHERE TO USE THIS CODE: Most videos DO NOT have "View in Higher Quality" links below them like this video does. So by using this code, you'll be able to watch ANYTHING in higher quality! TRY IT! : )
Wish there were a way to search Twitter using Google Search? Well, there is! With Google's Update Search tool, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, and to get started searching tweets with Google, take a look.
Apple's Reminders app is essential for those of us with a forgetful memory. But a standard Reminders entry isn't foolproof. They aren't great if you need to do something right when you get somewhere, since it can be tricky to set a specific time for that reminder. That's why Apple's location-based reminders are so darn useful.
Search engines index websites on the web so you can find them more efficiently, and the same is true for internet-connected devices. Shodan indexes devices like webcams, printers, and even industrial controls into one easy-to-search database, giving hackers access to vulnerable devices online across the globe. And you can search its database via its website or command-line library.
After years of user complaints, Samsung is finally letting us remap the Bixby button without the need of a third-party app. The new feature requires One UI a simple app update to Bixby, but there's one major downside: Samsung won't let you remap the button to open other digital assistants like Amazon Echo, Microsoft Cortana, and Google Assistant. Luckily, there's an easy workaround.
The most essential part of a healthy lifestyle is managing your diet — after all, what would be the point of a daily workout regimen if you were eating junk food? Thankfully, Samsung Health makes it easy to record your calorie and nutrient intake to get a clear picture of your dietary habits and how you can make them better.
You can easily deck out your favorite phone with great wallpapers, ringtones, and icons, but what about fonts? Not all Android skins let you change the system font, and even when they do, the options are often limited to a few choices. Certain root apps can open up the system font to customization, but some of these can cause problems now that Google introduced a security measure called SafetyNet.
Deep down inside, Android is really just a fork of Linux, the popular open source desktop OS. You can see traces of its roots everywhere, and this lineage still holds a certain appeal with many Android fans. If you're in that boat, you'll love the newest notes app we just found.
If you need to scan a large number of domains for a specific web app vulnerability, Dorkbot may be the tool for you. Dorkbot uses search engines to locate dorks and then scan potentially vulnerable apps with a scanner module.
Automated bots are growing on Facebook Messenger, and while they can be helpful, they also have the potential to get very annoying, very quickly. That's because these bots are enabled by default to send you "sponsored messages," or, you know, spam.
Apple makes it easy to access your favorite and most recently used applications and documents in Mac OS X. You can simply add your favorite apps and folders to the dock, and you can always visit the Apple menu from the menu bar to see a list of your most recently used apps and docs.
Hello all! In this tutorial, I'd like to show you one way of getting root on OS X. Check out this GitHub page for a recent privilege escalation exploit that was recently discovered. I've tested it and it works on both OS X 10.9 Mavericks and OS X 10.10 Yosemite, but appears to have been patched with OS X 10.11 El Capitan. If you check out the file main.m you can see where most of the magic is happening. This source code can very easily be changed to make it do more than just the system("/bin/...
Amazingly enough, some of us still have to worry about exceeding our monthly mobile data limits. You'd figure carriers would have given the customers what they want by now by offering truly unlimited plans, but with two conglomerates sitting atop the U.S. cellular market with fat pocketbooks that make for limitless lobbying, they can basically do whatever they want.
Thanks to a couple of photoshopped images that made rounds across Twitter last year, iPhone users were duped into thinking that iOS 8 included a security feature that would lock individual apps. Of course, none of it ended up being true, but we covered other features and apps that could accomplish roughly the same thing.
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.
You wouldn't send your GPS coordinates to a completely random stranger just because he or she asked you for it, right? So why are you constantly sharing your location (and other data) to apps on a daily basis?
By now, you've probably already installed 10.10 Yosemite, the newest version of Mac OS X, on your computer. While you most certainly noticed the visual changes, you might have missed some of the really cool additions.
BlinkFeed completely changed the way I access new updates from Facebook and Twitter, but when I switched to the Google Play Edition of the HTC One, I lost access to the launcher. BlinkFeed is available in the Google Play Store, but HTC has not opened it up yet for all devices yet. While there are ways to port BlinkFeed over to other devices, it's reliability is dependent on the ROM, sometimes causing bugs and crashes.
There are over one million apps in the Google Play Store, and many of them are restricted to certain device types, brands, and Android systems.
You've probably used Google to search for recipes, or to find out what the heck that mystery food on the ingredients list is. But with all its built-in features, there are plenty of other ways the search engine can help you out in the kitchen.
It was just released a few days, but Facebook Paper has already taken the world by storm. CNET said it was a better way to use Facebook. TIME said it's the future of Facebook. The Verge called it the best Facebook app ever. There's one problem, though...
The Xbox One is the quintessential jack of all trades. It can be your browser, music player, gaming system, and cable box, but in order to benefit from all of these goodies, you're going to have to set it all up.
For the most part, keyboard shortcuts are great. They save you some time and make it easier to do everything right from the push of a button. But like most things in life, there is always a caveat, and in this case, for me—it's a huge one.
If you want to enter the police station armory in Detroit while playing Deus Ex: Human Revolution, you either need to have enough credits to afford it, or you need a high hacking skill. This video from Game Front will allow you to skip both of those requirements by giving you the password to the armory so you can take all the weapons you want.
Electronic waste is becoming more and more of a problem for the industrialized world, especially since most electronics are full of precious and rare-earth metals that should be recycled. Even gold! Enter this video. It will show you how you can use chemistry to strip the gold from your old computer and other electronic parts and, well, have more gold! Who doesn't want gold?
Tinder is difficult to come by in the best of conditions, but in a damp wilderness survival situation finding it can be downright impossible. Enter this video. It will teach you how to make solid fuel fire starters out of cotton balls and candle wax, which you can use to start a fire even in wet conditions.
Oil is vital to maintaining the health of your engine, but if it's leaving the areas of the car where it's needed it can cause major damage. Watch this video to learn how to diagnose whether a misfire is being caused by a cracked cylinder head or leaking head gasket allowing oil to enter your coolant and spark plugs.
Those damn Romulus followers and their shrines! Finding all of the shrines in Assassin's Creed Brotherhood is difficult but rewarding. If you're having trouble, watch this video to learn how to find and enter the Palazzo Laterno shrine and get the One-Man Wrecking Crew achievement / trophy.
Most combinations locks like the one you have / had on your locker need to be turned right, left, then right again to enter the combination and open the lock. Or so you thought! Watch this video to learn how you can unlock a lock with turns in the opposite direction by using a different combination.
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
Prank calls are almost as old as the phone itself, but have entered a beautiful renaissance in the digital era. No need for the phonebook or a pay phone service anymore! This video will show you how to make really good, funny prank calls in the 21st century, including a rundown of necessary equipment and help with technique.
Swyping is not just for letters anymore! In this tutorial, learn how to text numbers with super fast speed using your Swype app. Swype is a cool new way to send messages on your phone without ever taking your finger away from the screen. Check out this clip and Swype numbers, symbols, anything!
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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
In this video tutorial, find out how to copy and paste HTML links embedded in the text with a breeze. No longer will you have to worry about re-entering every single link one by one. This video will give you a quick and easy solution to solving your most worrisome problem. Enjoy!
Are you in college? Too lazy to make a proper meal? Too cheap or poor to go out to dinner? But, still have that sophisticated pallet, this video will show you exactly how to eat like you deserve and make yummy super cheesy stuffed burgers to enjoy any night of week. Don't be afraid to enter the kitchen, after watching this video you'll be eager to have dinner guest.
Are you in college? Too lazy to make a proper meal? Too cheap or poor to go out to dinner? But, still have that sophisticated pallet, this video will show you exactly how to eat like a king and make a perfectly juicy meatloaf to enjoy any night of week. Don't be afraid to enter the kitchen after watching this video you'll be eager to have dinner guest.
"From the 1930s through the 1950s, the looks of various movie stars defined vogue magazine. From Mary Pickford's baby-doll face to Audrey Hepburn's cat-eyes eyeliner. The '60s ushered in a slew of makeup fad and the heavy eyeliner look remained through the late '70s and '80s, with wide color ranges entering the wearer's palette."