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 176th installment in their series of digital spreadsheet magic tricks, you'll learn how to get the last number or word from a column on a different sheet.
Darci Larocque, Blackberry Expert, explains a quick way to hide sent messages from your inbox folder with a few simple clicks, leaving clutter and needless distractions behind. This easy-to-understand tutorial is fully complete from start to save with visible screen shots and clear concise directions. There is even a simple two-button solution to see your sent messages again as needed. With a few easy steps, your inbox clutter can be a thing of the past.
In this tutorial, you'll learn how to use the ancient Japanese art form of origami to make a butterfly. This is a fairly simple design that's good for beginners, taking only a few minutes to learn. But the results are impressive, making for an elegant decorative item or small gift.
Need a way to hide your small pricey or memorable objects? Well, what better place to hide those cherished items than in a burning candle? Unless your robbers have a thing for scented and aromatic candles.
No one likes having their food messed with. That makes it all the more fun to do so right? This video will show you some fun pranks that you can pull to mess with the food of your friends and neighbors. They include making surprise disgusting layer dip and ordering unusual combinations of items at the grocery store, but are all freakin' hilarious and require relatively little setup or risk.
Don't give us that look. It is possible to make delicious, nutritious meals out of (mostly) dollar-store items, if you know a few tricks. With the bad economy, everyone can afford to save a few dollars here and there, without sacrificing taste. Watch this video cooking and budgeting tutorial and learn how to make delicious dishes out of dollar store food.
Eco...in this case also meaning 'economize' as we take an item that would normally have been thrown away & use it to make a cool fashion statement piece! This project is dedicated to the Green Guru Challenge and just uses household scraps headed for the trash, and turns them into a stylish bracelet. Learn how to craft this bejeweled cuff bracelet by watching this video jewelry-making tutorial.
Add even more personal touches to your crocheted items. This how to video is a tutorial on how to make pom pom balls out of yarn. These pom pom balls are super easy to make and are a great way to decorate scarves and hats.
Learn how you can open handcuffs using common items such as paper clips and more. This can come in handy for those late nights at bars.
This is an instructional video on how to put together a fire starting kit. The kit includes everything from a lighter to fatwood. The second video in this sequence will show you how to use the items detailed in the fire starting kit.
Check out this instructional video and learn how to hack a simple flashlight and transform it into a night vision flashlight! The items you'll need for the project cost less than ten dollars and you get a perfect night vision view. Watch this how-to video and learn how to build a night vision flashlight on the cheap.
This is one of my favorite projects, a wide format pinhole camera that uses 35mm film and is made from $10 in crafts store items.
TOUCHPAD HACK - This video tutorial shows how to transform a touchpad into a useful mini graphics tablet with some simple, everyday items. You will need a 1.5V battery, a small ball bearing, and a Philips head screwdriver. Watch this video tutorial and learn how to transform a touch pad into a miniature graphics tablet.
Usually our 5-Minute Projects involve soldering and LED lights and other such electronic accoutrements, but this week we decided to skip the fancy stuff in favor of an old-school science project: making rheopectic slime from Borax and glue. This is a pretty safe experiment even for kids--just make sure to do it with parental supervision and keep the Borax, slime, and any fingers that have been touching the aforementioned items out of eyes, noses and mouths.
Your goal in Mario Kart Tour is to beat your rivals and come in first place, but that's never easy when you're also trying to avoid banana peels, red shells, flying bombs, and other items. One item you may be familiar with is Blooper, a squid-like creature found in most water levels. It squirts ink all across your screen, making it more challenging to navigate your driver on the track.
Google just rolled out a revolutionary feature to its Pixel devices — Google Lens. Previously, Lens had only been available in the Photos app, but now, whenever you want to learn about something in the real world, you can just bring up Google Assistant, turn on the camera, then let Google's famous AI analyze the scene.
While some companies like IKEA and Lowe's zig towards ARKit to entice shoppers, Target has opted to zag to broader appeal with an augmented reality see-before-you-buy tool for its mobile website.
Imagine walking into a store with your own personal model to show you how any clothing item you want is going to work.
If you use Google Keep, you'll be happy to know that you can add items to lists and even start new ones with "OK Google" voice commands on Android, and it works fairly well. (Hat tip to Reddit user rambantu for finding this trick.)
If you purchased something from iTunes, the iOS App Store, iBooks Store, Apple TV App Store, or the Mac App Store and it doesn't work, didn't download, is buggy, or wasn't what you thought it was, you can get a full refund from Apple—you just have to know how to ask.
When going out to eat with friends, it's inevitable that one person takes charge at the end of the meal to split the bill. They whip out a pen and begin asking everyone what they ordered, carefully dividing, adding, and subtracting on the back of the receipt for everyone to use. Unfortunately, that never seems to work as intended. One person will end up paying a little more, while another will pay less.
Audiobooks are great because they require little-to-no effort on your behalf. When driving in traffic, why not listen to George R.R. Martin's lengthy A Feast for Crows instead of repetitive, commercial-laden radio? Maybe it harks back to prepubescent bedtime readings, but having things read to me is a very satisfying experience.
For the most part, Finder has had the same basic functionality through the various releases of OS X. But Apple's lack of interest in adding new bells and whistles to the backbone of their operating system simply means that 3rd-party developers get to shine, and Tran Ky Nam is one such developer. He created his own extension for Finder that adds tabbed browsing, dual pane mode, cut & paste functionality, and much, much more.
Most of you probably spread ketchup all over hamburgers and fries. Some of you may even drink it straight. But did you know that tame (and slightly addictive) condiment in your fridge is also a powerful cleaning agent?
Let’s be honest: you’ve thrown a few delicate, "hand wash only" clothes into the wash with your jeans. Maybe you’ve even ruined a sweater or two. There are so many things to look out for when doing laundry, and they’re easily ignored or forgotten, especially when it comes to drying.
It's no surprise that Costco has great deals, and that's why millions pay annual fees for the privilege to shop in their wholesale outlets. Just take their hotdog and soda combo for $1.50—it's the same price now as it was 27 years ago.
Tea has been around for thousands of years, and as a result, tons of customs and ceremonies have sprung up around its consumption. Some cultures take their tea plain, while others put things in it. Sometimes there are special tea-holding vessels, other times not. Maybe there will even be special foods meant to be eaten with tea. However, in America, our appreciation of tea has waned. For many, iced tea is their biggest source of tea consumption, and it's imbibed with no ceremony whatsoever in...
Bailey's is such a versatile drink. You can use it for baking, Irish coffee, Irish car bombs, or just over the rocks works too. But, alcohol is expensive, so, in this video, you will learn how to make your own home made Irish cream from scratch with chef Jason Hill. Now go forth and car bomb away! (Save some for the rest of us!)
In this clip, Bobby shows you how to make a completely delicious drink for the summer time. Bobby tackles the classic mojito and shows you how to make it like a real Cuban would. So, mix it up and enjoy the summertime with this refreshing cocktail.
This video will teach you how to make a cocktail called a Flaming Blue Lamborghini. The alcohols are: Barcardi 151, Kahlua, Galiano and Blue Curacao. He uses a martini glass and pours in half an ounce of Bacardi and lights it. The glass is rotated while he adds Kahlua, Galiano and Blue Curacao. All the while, the drink is still flaming. While he continues to rotate the glass, he pours milk into it and the flame turns red and rises while a woman sips the drink with a straw. If you really want ...
This video shows you how to make the Jack Rose cocktail in 12 seconds flat. It goes like this. Three-quarters of an ounce of lemon juice, three-quarters of an ounce of pomegranate syrup, and two ounces of Laird's apple brandy. Shake it over ice, strain it into a cocktail glass, and serve. The video also tells us about how the Jack Rose first appeared in Ernest Hemingway's book, The Sun Also Rises, where the narrator is sitting in the lobby of a Paris hotel sipping a Jack Rose. The popularity ...
Watch this video tutorial from the Polish Guy to see how to polish church appointments, like a chalice and candle. In this demonstration we use a Church Polish & Cleaning Kit that includes Simichrome and Flitz to polish a brass chalice and candle stick. The tutorial includes detailed work instructions and best practices.
This instructional video teaches you how to mix a basic Caipi style cocktail and variants. The Caipi cocktail is a muddled drink from Brazil and this step by step how to guide gives three different variations using vodka, gin and campari. A great cocktail to add to your mixology library!
Learn how to mix the king of cocktails--the Martini! The martini was originated in the middle 19th century.
A professional kit to make your own Absinthe. The absinthe will have the same taste as the original drink from the 19th and early 20th century.
Lindsey Vuolo shows how to make a Long Island Iced Tea. This Prohibition era drink has nothing to do with tea - except color to fool the cops!
Every physician, medical student or resident, from emergency room doctors and nurses to anesthesiologists, need to know of the most fundamental skill sets: airway assessment and management. But before one can be proficient with this skill set, you need to know the tools of the trade.
Is your garage a little more cluttered than it should be? Well, it's time to get organized! And Lowe's is here to help! In this video, Mike Kraft gives some great tips for shaping up your garage or basement, in a neat and organized room that you can finally walk through.
Want to make a Firefly cocktail like a champion bartender? This clip will show you how it's done. With the proper technique, mixing the perfect drink can be easy. So easy, in fact, that this free video bartenders' guide can present an overview of the process in about a minute. For more information, including a full list of ingredients and complete instructions on how to mix this drink yourself, watch this video drink recipe.
Want to make an Old Fashioned like a champion bartender? This clip will show you how it's done. With the proper technique, mixing the perfect drink can be easy. So easy, in fact, that this free video bartenders' guide can present an overview of the process in about a minute. For more information, including a full list of ingredients and complete instructions on how to mix this drink yourself, watch this video drink recipe.
