Pre Sale Passes Search Results

How To: Perform 'freeze frame'

Learn awesome freestyle basketball tricks, passes and shots from Professional basketball trickster, Q-Mack! In this video Q-Mack teaches you how to do the freestyle trick called 'freeze frame.' This trick requires two balls!

How To: Make decisions from the high post in basketball

Learn how to practice quick decision making (pass or shoot) when on the high post and establish good basketball game rhythm. Videos two through four cover when and how to execute each option: jump shot, seal the post (pass the ball down to the player at the low post), and swing the ball (after setting the pick and sealing the post).

News: Huawei Gains Ground with High Sales of Mate 9

Huawei is the third biggest smartphone manufacturer in the world and continues to increase its market presence with each new device. The Mate 9, the company's latest high-end phablet, has been available for four months now and has sold five million units so far. This is 36% more than the Mate 8 sold four months after its premiere last year.

How To: Coil a line in sailing

As you coil a rope, place a slight twist in the line to flatten the coils. Near the end of the line, wrap the line three times or more around the coils. Form a loop in the end of the line and pass it between the coils. Now you can either pass the end of the line through the loop to allow the coiled line to be hung for storage or pass the loop over the top of the coil to allow the coiled line to be stored in a compartment. Coil a line in sailing.

How To: Calculate Commission Based on Varying Rates in Excel

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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Begin your own blog and make money online

Have you always dreamed about quitting your day job to pursue your true passion in writing about tips on how to bake your famous cupcake pops? Stop dreaming and start doing! Thanks to the prevalence of the internet, blog writing is more popular than ever, and successful bloggers actually make quite a hefty chunk of change doing what they love.

How To: Use coupons to shop for free at Walgreens

In this clip, learn how to be a real coupon diva! This episode of coupon divas focuses on Walgreens drug stores and will show you how to combine things like register rewards, coupons, sales and other deals to walk out of the store with a full cart for virtually no money! Get your coupons to outnumber the cost of the items and go home with a bunch of free goodies. Kitty will show you the basics and how to stay organized with these strategies.

How To: Replace your Nintendo Wii sensor bar

Since the Nintendo Wii was first released, it has become one of the most popular gaming consoles in the video game industry. In terms of sales, the Wii has destroyed its competitors, the PS3 and Xbox 360. So there's no denying that the Wii is a pretty popular console. So in this tutorial, the great people at cnet, will show you how to replace your Wii sensor bar. It's really easy to do and will have you back in the game in no time. Enjoy!

How To: Change the nylon strings on a classical guitar

In this Music & Instruments video tutorial you will learn how to change the nylon strings on a classical guitar. Take the peg winder and unwind all the old strings. Then unravel all the strings from the bridge. Make sure the bridge doesn’t fall off. Take a new string and insert the finished end in to the sixth hole passing it from the hole of the guitar towards the end of the body. Then tie a knot and pull the string tight over the bridge as shown in the video. Now pass the unfinished end o...

How To: Create nested unique lists in Excel via array formulas

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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.

How To: Sell your car on Craigslist

This six minute video shows you how to sell your car on craigslist. First, go to craigslist.com and click on the nearest city (or country). Follow the links to list an ad for a car for sale. You will want to put the kind of car in the posting title because that is used in sorting search results. In the posting description it is important to be as specific as possible - again describing the car, giving some history of the car like if it has ever been in an accident and if you have had any work...

How To: Record macros in Excel 2007

In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ever you run that macro the Word will automatically build the template for you based on the recorded commands. To write macros you need to have the developer tab enabled. To enable it click on the office button and at th...

How To: Wash hands before eating bread, as per Jewish law

This animated video, produced by Jewish Pathways, demonstrates how to wash your hands in accordance with Jewish law before eating bread. Besides cleanliness and holiness, the instant reason the rabbis call for washing before bread is to keep alive the memory of the proper treatment of teruma (the first priestly tithe that may be eaten only by kohanim and their instant families, and that must be eaten only in the absence of any tum’ah – ritual defilement).

How To: Do pass and move soccer drills for ball control

This UEFA Training Ground video helps develop your ability to pass and move the ball to fellow soccer teammates. Although it seems quite basic, proper passing in heated game situations is a nice skill to have and to fall back on if a recently learned soccer trick suddenly escapes you're caught between a rock and a pushy defender.

How To: Fold a concave 8 sided origami flower

Origami flowers are usually quite feminine and realistic. But this origami flower imparts more of a geometric, abstract interpretation of flower petals than most. And while this origami folding tutorial is meant for creating an eight-sided origami flower, it can just as easily pass for an eight-sided star.