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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
After watching Samsung's exploding phone fiasco this past year, I took comfort knowing that the likelihood my iPhone would suddenly combust was slim. However, after hearing about a recent incident in Wisconsin, iPhone owners may have reason to worry.
Needing to trip the feral cat population in your neighborhood. Well, it's time to make a trap, fill it with cats, and shut your trap. This good how to shows a trap you can build yourself, and the necessary tequinique to catch those cats.
Regression functions are a vital part of statistical analysis of populations, and if you're involved in business, science, or nearly any academic field you should understand how it works. This series of videos will show you how standard regression functions, ANOVA, ordinary least squares, and everything else you need to know.
In this video tutorial, viewers learn how to do the "Doctor of the Peggle Arts" achievement in the Xbox360 game. The purpose of this achievement is to clear all the pegs and bricks in the Quick Play or Adventure mode and gain exploding fame. Begin the level by shooting from all the way to the right or left for balance. This video provides a demonstration for viewers to easily understand and follow along. This achievement is worth 30G. This video will benefit those viewers who play the Xbox360...
Need help with Satellite Uplinks in Battlefield: Bad Company 2 on the Xbox 360? Jack and Geoff from Achievement Hunter give you this two-part video guide on finding all 24 M-Com Stations. In the first video, see the locations of the first 12 M-COM Stations that you must explode for great glory! Part two of this tutorial reveals the last 12 locations, along with the location of the Holy Grail. They also finally break that barrier and hug each other. And they also pick up the Complete Blackout ...
Watch this science video tutorial from Nurd Rage on how to make a test tube thunderstorm. They show you how to make the thunderstorm in a test tube using alcohol, sulfuric acid and potassium permanganate.
The Diet Coke and Mentos Explosion prank is one of those classic pranks that everyone should experience at some point. When combined the Diet Cola and Mentos become volatile, basting your victim in stickiness. Watch this video to learn how to make a Diet Coke and Mentos bomb, a simple, yet devious exploding prank. Next up: how to con your victim into cleaning up the mess. Use this as inspiration for one of your April Fools Day pranks!
In excel a left click is made on box A1 and the X title is typed in as year. In A2 the year 2001 is typed and in A3 the year 2002. Both A2 and 3 boxes are highlighted and the bottom right hand corner is used to drag the work into a copied sequence down to A12. In B1 "population in billions" is typed. From the web site the data is copied and typed in as it appeared and the numbers are rounded off. A click is made on the "insert" tab and line is selected from the menu which appears. The upper l...
At any given time, about 10% of the UK population have warts, which costs the NHS a staggering £40m a year in treatment. In this exclusive guide, Dr McKenna discusses the various types of wart – from the common wart to the genital wart – and advises on both preventative measures and treatment options available, to ensure that these little blighters will blight you no more. This video tutorial shows how to diagnose and treat warts.
Learn how to make saltines explode in midair with WSOP champion Chris "Jesus" Ferguson slices them with a deck of cards.
Make a DIY internal combustion engine that explodes into action just like the real thing! Make Magazine shows you how in this video.
Got a friend who you want to help quit smoking? If you prank them with an exploding cigarette it might help. Use this as inspiration for one of your April Fools Day pranks!
Learn how to explode from half court to the three point line and practice your three point shots in this 3 point shot off the fast break basketball drill.
Learn how to do this crossover drill and explode into a sprint, improving your balance and multi-directional movement skills for soccer.
Learn how to explode correctly from the ready position when playing football. This video shows you how to teach correct footwork for pulling guards and players in motion.
In this tutorial, Bert will show you quickly how to use a bunch of different layers to create a ray gun shooting and exploding it's target. It will help if you already have some Photoshop knowledge for this one.
Could possibly be the most evil prank you can pull off. Use the noise maker found in a party popper to set up this evil prank that will just about scare the living $#?# out of anyone that puts it on.
Here is a cool trick that you can do to amaze your friends: make a beer bottle explode right in front of their eyes! All you need is a little skill and your bare hands, and that sturdy bottle will smash to pieces in your palms.
Worried about your or someone you love's relationship with alcohol? Not all alcoholics fit the stereotype of the down-and-out drunk. Learn to recognize the warning signs in yourself or a loved one.
Using mathematical modeling, researchers suggest weather and warming created the "perfect storm" that drove the Zika outbreak in 2016.
It turns out that the new Galaxy Samsung S8 Active (codenamed Cruiser) will be headed for AT&T in the US later this year, just like previous Active models. SamMobile revealed that the device would be exclusive to the network with a model number SM-G892A.
Rabbits have been a persistent problem in Australia for over 150 years. Now the Peel Harvey Catchment Council (PHCC) and Peel-Harvey Biosecurity Group have released a strain of the rabbit haemorrhagic disease virus (RHDV), called RHDV1 K5, to reduce the number of pests in the Murray region of New South Wales.
Ecosystem changes caused by agricultural choices in Brazil are creating a dangerous microbe mix in exploding populations of vampire bats and feral pigs.
What's the only thing better than chocolate? More chocolate, of course! Satisfy your chocolate tooth (we're sure there's such a thing, especially around that time of month) by baking this oh-so-delicious molten chocolate lava cake.
Kitana from "Mortal Kombat" was the original gal whos looks literally could kill. Killer curves plus killer butt-whooping skills? The girl knew how to work it.
Melt and pour soaps are some of the easiest soaps to make, given that actually making a soap by yourself from scratch - you know, harnessing glycerin, coloring, etc. - could easily explode into your face, literally, if you mix things in the wrong order.
No little boy's birthday cake is complete without exploding bombs and viscious reptiles. Make your son's cake exotically sweet with a fondant alligator.
This video shows how sublimation works. The instructor shows how to mix bubbled water, ice water and dry ice to create dry ice smoke. He is essentially making a hand made fog machine. This task must be done carefully because if the solution is isolated and concealed it will build pressure and possibly explode. Take extreme caution in doing this home experiment. The instructor also shows you how to make music spoons using temperature changes on the metal.
These are great running drills by Lauren Fleshman! They're useful for runners both sprinters, hurdlers and long distance runners. She talks about body position, range of motion, posture and gait. The karaoke drill is a sideways drill. The high knee drill is to recreate the perfect running position by using a knee lifting skip. It freezes your body frame in proper position and exploding with your back foot off of the ground.
When "Hannah Montana: The Movie" came out, Miley Cyrus' song "The Climb" exploded and even made it to the top of the Billboard 100, obscuring several equally good though not as highly publicized singles. One of these excellent tunes is "Butterfly Fly Away," sung by the chanteuse and her father, Billy Ray Cyrus.
For on-the-go lighting of birthday candles (those surprise birthday parties really get you), homemade explosives (because making stuff explode is fun), and cigarettes, a cheapo BIC lighter is a totally awesome fix. But most BIC lighters run out pretty quickly and get tossed without second thought.
In this tutorial, we learn how to break an arm in half & blow up a head in film. To do this, you will need: a tripod, after effects, and actors. First, you need to record a shot with the background and the person whose head you want to blow up. After this, put the clean plate clip over the head of your actor. Now, you will be able to clear out the person and add a mask that is exploding in the frame instead of the head. Add in some fake blood and sound effects, then you will be finished with ...
How cool are smoke grenades? You toss 'em into the air and they explode into a vision of thick clouds and smoke, preventing your enemy from seeing you as you stealthily sneak past him and shoot him upside the head with a paintball gun.
East meets, well, east in this cross cultural stir fry dish by Guy Fieri. Fieri takes classic Chinese stir fry up a notch on the heat meter by adding spicy Korean kimchi.
In this clip, learn all about prosopagnosia, otherwise known as "face blindness". This condition is rare and occurs at different levels of severity, usually as the result of autism or brain damage. Recently, Amanda Green graduated from high school in Minnesota despite her inability to remember or recognize people.
In this video tutorial the instructor shows how to perform basic lighting corrections in Adobe Photoshop. The levels tool is the Photoshop's most used command which has many features to it. Its most basic function is as a lighting correction tool. In this video open an image and work on its adjustment layer so that you do not damage the original picture. Now choose the levels option by right clicking and it shows a pop up window which contains a histogram which shows the population of the col...
To identify characteristics of a sample in your survey, there are many factors to consider of your samples. The first four characteristics you need to focus on are gender, age, income level, and education level. All four of these characteristics must be proportional to that of the population. You also need to consider the geographic location. Only take samples from the immediate geographical area. Finally, an important characteristic of the survey is the sample size. You do not want to ask to...
If you're looking to get on top of the game Plock for Facebook, then sometimes cheating is the best answer (and easiest). With Cheat Engine, you can easily hack Plock.
There's nothing to this Plock hack using Cheat Engine. If you want to get 5000000 points and totally impress your buddies, this is the cheat for you.
