Year Vision Search Results

How To: Replace the battery in a Creative Zen Vision:M

Have a tweaking Zen Vision M? Your battery might need replaced, so do it yourself instead of paying someone else to do it! You don't need to pay an expensive professional when you only need to pay for the battery. This step-by-step video demonstration will show you the procedure for replacing the battery in your Creative Zen Vision:M Portable Media Player. You can use the replacement battery found in the video, or any other replacement battery, the results are the same.

How To: Make Wiccan New Year's spell bags

This video demonstrates how to make Wiccan New Year's spell bags or wish bags. Wiccans celebrate the New Year on the Winter Solstice. They like to stay up all night, playing drums round a bonfire. Wiccans also make a wish bag and at the New Year they whisper a wish into this bag and then pop it. This makes it an air spell. Alternatively you can whisper the wish into the bag, seal it, and then put it on the bonfire. This makes it a fire spell. Sometimes the bag is saved all year and then it is...

How To: Use YEARFRAC, INT, and DATEDIF in Excel

In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...

How To: Create a simple and clean makeup look with Michelle Phan

A New Year, a new you. At least that's what most of us promised ourselves when the clock struck 12 and 2010 transformed magically into 2011. While not all our New Year's resolutions are easily stuck to, such as dieting and exercising six times a week, you can update your look to look your best. Check out this makeup tutorial by Michelle Phan to learn how to create a simple and clean look.

How To: Create a New Year's purple nails look

In this video, we learn how to create a 2010 New Year nail look. First, apply a dark purple nail color to the top half of the nails. Now use a clear nail polish to push the purple color down to the middle of the nail. Next, apply a black color to the very top of the nail and then use the clear polish to again push the color down and blend all of them together. Next, use a dotting tool and clear polish to pick up rhinestones or nail rocks and apply them to the tip of the nail where the color i...

How To: Create a hot New Year's party look for an older woman

In this video, we learn how to create a hot new year look for an older woman. Start off by applying primer to the eyelids, then brush on a light gold eyeshadow to the crease of the inner eyes and below the eyebrows. Next, brush on a aqua blue eyeshadow to the entire eyelid, followed by a sparkly blue eyeshadow on top of it. Next, brush a purple color on the outer edge of the eyes and inside the outer crease of the eyes. After this, apply black eyeliner to the bottom of the eye and the top. Th...

How To: Count dates falling within a given year in MS 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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.

How To: Apply costume vampire makeup for Halloween

Looking for some tips on how to apply this year's vampire makeup? Look no further. In this excellent makeup tutorial, learn how to apply professional costume makeup to give yourself a realistic vampiress makeover! Perfect for fans of Twilight, Bella Swan, and Edward Cullen!

How To: Create party makeup for going out at night

This look is great for going out at night, or better yet, New Year's Eve. You want to look fantastic when it's time to ring in the new year, this tutorial will show you how to look glamorous for the new year. This tutorial is also great for other lavish parties or clubbing. This makeup look was inspired by the New Years Ball in New York. How it's so bright and sparkling.

How To: Play dreidel

The dreidel, the small top that's among the most recognizable symbols of the Hanukkah season, is a fun game of chance to play with friends and family.

How To: Understand the basics of apple tree pruning

Each year an apple tree should produce three things: new growth, fruit buds on last year's and older growth, and fruit on those fruit buds formed in previous years. In order to keep an apple tree in balance and fruiting, one must prune. However, pruning is too often done poorly. In this, the second installment of his series on practical apple tree pruning, Stephen Hayes of Fruitwise Heritage Apples looks goes over what to look for in a good secateurs, or pruning shears, and how to thin out sp...

How To: Turn Off HDR Video Recording on Your iPhone 12 or 12 Pro to Reduce File Sizes & Increase Compatibility

There's a lot of talk these days about how the iPhone 12, 12 mini, 12 Pro, and 12 Pro Max can shoot Hollywood-quality video with HDR and Dolby Vision. The video processing is really cool when it works, but as of right now, you might find its limitations outweigh its use to you. If that's the case, there's a way to turn it off.

News: From Immersive Comics to Interactive Music, Here's What You Can Expect to Do with Magic Leap One

The year is 2018. You just received your own Magic Leap One: Creator Edition. What now? Rewinding back to today, we know of one specific app that will be available for Magic Leap's device, along with two others that could be tagged as highly likely. Paired with Magic Leap's own experiments and demonstrations, we can get a sense of what the playground for this new toy will offer.

How To: Make a buttercream orchid cake

Cake decorating is just another way for an artist to represent the kind of talent and vision they possess. A cake is not just a beautiful, sweet little snack, but a canvas in which an artist can be as creative as they can with using edible tools. This video tutorial shows you how to make a buttercream orchid cake that is sure to wow everybody. Enjoy!

How To: Unlock secret XBox 360 functions

Chris Pirillo demonstrates some lesser known features of the XBox 360 including: the Shut Down feature, Custom music, the manual moving visualization, composite and component video, and changing the vision camera effect.

How To: Sum year over year sales using MS Excel's SUMPRODUCT

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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.

How To: Apply gold champagne New Years nail art for New Years

In this video, we learn how to apply gold champagne New Years nail art for New Years. Start off by painting your nails all black and letting them dry. Now, use a thin brush to paint two champagne glasses and the numbers 2010 on the pointer finger of both the hands. Next, paint the top of the nails white onto each of the nails on the hand, except for the pointer finger. Rub out the white a little bit from the top of the nail going down, then apply a very sparkly gold shadow on the top of the n...

How To: Play "100 Years" by Five For Fighting on the piano

Want to know how to perform Five for Fighting's "100 Years" on the piano? Learn how with this free video piano lesson, which presents a complete breakdown of the song and its chords. While this tutorial is best suited for intermediate players, pianists of all skill levels can play along given a little time and effort. For more information, and to get started playing "100 Years" on your own keyboard instrument, watch this how-to!