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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
In this video tutorial, viewers learn how to make a tea bag fly with a home experiment. Viewers learn how to make a tea bag fly using convection. The materials required for this experiment are: tea bags, matches, tin foil and scissors. Begin by cutting the top of the tea bag and open it. Empty out the tea. The tea bag should be a cylinder shape. Place the tea bag on top of a piece of tinfoil and use your matches to light the top of the tea bag. This video will benefit those viewers who enjoy ...
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. In this Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
In this tutorial, Kandee shows us how to tie a wrist bandanna. First, roll up your bandanna and lay it on your hand. Wrap it around your wrist several times and tie at the bottom of your wrist! This is not only a cute way to make a fashion statement, it can also be used for when you're doing your makeup! If you mess up, it's an easy way to clean up any messes. You can choose different colors and designs for your bandanna and match them to your different outfits. You can also wear bracelets an...
This video explains how to properly fold fitted sheets. The first step is hold the sheet with the pattern, outer side closest to you and put your left hand into the first pocket and your right hand to the second pocket. Put your right hand over your left hand and flip the sheet on top of itself. Keep your hand on the top sheet and follow the edge all the way down to the third pocket. Place your hand on the underside (non-patterned part) and match it to the first two pockets, and then flip it ...
This video teaches you how to become a DJ. In this session we can learn how to keep the beat off beat by keeping the timing of the beats the same. This video shows the specific way of increasing the beats and decreasing the beats according to the tracks that are played. This tutorial also has a live sample of how a beat can be matched off and a how to maintain a constant interval between the beats. It also has some specific instructions on how to maintain a constant interval between the track...
In this video Threadbanger Projects shows how Anne made her nightdress out of a pillow case to match panties up loader Clare Bear showed how to previously for Valentines Day. Materials needed are a pillowcase to match the frilly panties, elastic, ribbon, scissors, and a sewing machine. She explains how to measure elastic points using your body and shows how to attach the elastic using pins and a sewing machine. She finishes the nightdress with ribbon for the straps and a bow on the back.
In this video the author shows how to find out if a Point lies on a Line in Slope Intercept Form. He shows it by an example where he takes a point, which is an ordered pair in the form (x, y) and a line, which is an first degree equation. Now he substitutes the values of x and y in the equation and checks if both the sides of the equation match. If it matches we can conclude that the point lies on the line. By following the method given in this tutorial you can find out if a given point lies ...
Almost everybody knows this trick, but do you? Just watch this science experiment video that you can do in your own home, in your own kitchen, to see how to suck an egg into a glass bottle and hear a crazy sound.
OnePlus unveiled its latest device — the OnePlus 7 Pro — Tuesday, May 14. Usually, the company touts a device with impressive specs, build quality, and price, all without sacrificing too much. This time around, however, OnePlus decided to include a Pro device without compromise, while retaining those core values, making the 7 Pro highly competitive against the "low end" phones of their competitors (the iPhone XR and Samsung S10e).
This year will be an interesting one for iPhones. With speculation that the expensive iPhone X is underperforming, rumors have circulated that Apple will release three "bezel-less" devices, one of which will cost less by omitting the OLED panel for a traditional, yet large, 6.1" LCD. Now, thanks to the source of this rumor, we have an idea how much that lower-tier iPhone will cost.
Although expected to be only a modest upgrade over the S8, we can't help but be excited about the Galaxy S9's unveiling late next month. Among the many rumors and questions we're looking to see addressed, one of the biggest queries we have is, of course, with the price tag. We might not have to wait a month for the goods, however, thanks to a new pricing announcement out of South Korea.
Not many smartphones are announced at CES these days — instead, you'll mostly see other types of electronics like Energeous's WattUp and Li-Fi. However, ASUS decided to share some good news for their US customers, and it comes in the form of a new phone with some interesting specs and a budget-friendly price tag.
Kazendi, a London-based HoloLens development and rapid prototyping studio, just released a new iOS app in Apple's App Store that lets developers stream HoloLens applications live from the headset to an iPad or iPhone. It's called HoloStream, and is the first iOS/HoloLens crossover app we've seen so far.
Amazon makes it exceptionally easy to purchase anything you want in just a few minutes. From textbooks for school to live ladybugs, its more surprising when you can't have something delivered to your doorstep in a few day's time.
This past Halloween, 26-year-old Gabrielle Wathen learned the hard way about Uber's ridiculously expensive surge prices. After a night out and an Uber ride home, she learned that the 20-minute drive cost her more than $360.
Tricking out your phone is nice, but there's nothing better than saving money in the process. Google Play is full of apps that offer great functionality, but some of them are not always cheap, and that's why AppSales was made. AppSales is an app browser that lists apps that are currently on sale, and can also keep track of those you are interested in buying in case the price drops.
A month ago, we showed you what I, and many around the web, dubbed the "Nexus Killer". That device is the OnePlus One, a low-priced, high-powered, CyanogenMod-run Android device.
Because Matthew Price likes her. He REALLY likes her. Sally Field's is nominated for Best Supporting Actress for her outstanding performance in Spielberg's Lincoln! Oh, and Matthew Price tells you why she's VERY important in film history.
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.
Clip Art from Microsoft Office allows you to insert stock photos into you PowerPoint, Word, Excel and Entourage documents easily. You can gain access to the Office Clip Art site easily in any of the mentioned applications. The Microsoft Office for Mac team shows you just how to download and use clipart from Office Online in this how-to video. You can get free stock images of low-priced professional quality photos.
Shopping at a thrift store can be a fun adventure, a daunting task, a way to save money, or a combination of any or all of those. There's no question that buying secondhand is almost always cheaper and buying at a thrift store undoubtedly so. But it can also be a lot of work. Here are a few simple tips to make the process a little easier.
At some point, we all go from organized to disorganized. Let's assume you are a business executive working in a busy corporate building. Chances are you are going to get a heavy workload and it will impact how clean your workspace is. However, this article is about keeping your desktop clean and clutter free, along with the use of software to find documents you have misplaced.
We're ending the week with a lot of big announcements and updates. To date, Google+ has updated its name policy, but is still forbidding pseudonyms. Blocking people on Google+ became even easier, and yesterday, games on Google+ launched.
Kipkay demonstrates how to extract the laser from a DVD burner and mount it in a small flashlight to create a handheld laser burner that can light matches and burst balloons, all in this how-to video. All you need is a 16x DVD burner, a laser housing, and a flashlight. Watch this video tutorial and learn how to modify a flashlight into a relatively strong laser.
There aren't a lot of games with 3D maps where you can't break out of the levels in some way, and Black Ops is not different. This video will teach you a barrier breaker that you can use to get out of every multiplayer map in the game. Only use this in private matches unless you want it to go away!
The best part of science class for many was the awesome demonstrations and experiments teachers use to demonstrate scientific principles. This video will teach you how to capture some of that magic by performing ten awesome science party / magic tricks, like relighting a match with smoke and rolling a can around on it's rim.
Being more physically gifted than your opponent is only part of successful tennis. You have to have a keen mind well versed in the tactics of the game as well. This video will teach you some basic tactics for singles tennis that will help you win matches you would have lost otherwise.
In FIFA 11 there's a feature that's a first for the series called "Be The Goalkeeper" which allows you play an entire match as the keeper, all 90 minutes of it! You can do things such as call out plays and also defend the goal and perform various goalkeeping techniques. In this video you will get a basic overview of how to play the mode and what you can do in it.
Want to add an avian specimen to your paper menagerie? Have extra paper and time to match? This video tutorial presents a complete, step-by-step overview of how to make a crane using origami, the traditional Japanese folk art of paper folding. For more information, and to get started making your own paper birds, watch this arts-and-crafts guide.
Is it magic or is it an illusion? See for yourself when you watch this video tutorial on how to make a matchstick stand up on its head. There's an easy solution to this magic trick, easier than you think. You don't need to be a magician to perform this match standing on its head trick. Anyone can do it!
Petrilude brings you this Halloween makeup tutorial on how to create a look based on Tim Burton's movie 'The Corpse Bride'. Petrilude only did her face, but he HIGHLY suggests if you do this Halloween Corpse bride look, that all exposed skin is painted to match the face! Corpse bride is a hot look for your Halloween party.
This may/will take some practice to do but the risk makes the glory. You simply put a match in your mouth and inhale. Yes, that simple...or so you think.
Need to make a survival fire, but don't have any matches and your lighter is out of fluid. Fear not, this how-to video can help. An empty flintwheel lighter can save the day when you need a fire. Dandelion seed puffs can be the perfect tinder for your spark. Watch this video tutorial to see how it works & learn a great survival tip.
Watch Ray Mears from the BBC give you a how-to guide for making fire in the desert. (You don't even have to carry matches!) Put on your gloves to handle the fauna for cutting wood. Make a notch in the wood--good luck trying to make fire by friction!
Are you so hot you're smokin'? Well you will be if you can pull the magic trick in this how-to video off! Watch this instructional video and see just how to make your fingers smoke. This trick can be tried out any time you've got a box of matches and a water faucet handy.
While sheltering at home orders are lifting, companies are still conducting most business online. Case in point, hackers have been having a field day over the last few months. Securing your identity has always been important, but never as much as it is at this moment.
With all the talk about the impending release of the Magic Leap One, some have forgotten a very important, competing release on the near horizon: the HoloLens 2.0. Well, now we have new information that tells us when (roughly) the device will be released, as well as a few other exciting tidbits.
Augmented reality headsets with larger eye boxes than any device currently available could make their way to market by the end of next year if current timelines hold true.
Shapr is a new networking app that aims to help professionals connect more efficiently, and draws much of its format from dating-focused social networking apps. Shapr could be especially useful for those who have recently moved into their industry or location, and for those seeking employers or employees. For example, the app already has 65,000 users just in New York City alone.
