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 617th installment in their series of digital spreadsheet magic tricks, you'll learn how see a SUMIFS and SUMPRODUCT functions formula to sum the fiscal year's sales when the year does not end on December 31st. Also see a formula for year-over-year percentage change.
This makeup tip is perfect for a glittery eyeshadow for New Year's as inspired by the cover of Sephora's magazine. First, apply a semi-dark gray eyeshadow along your eyelid and on the outside corners of your eyes. Using a fluffier brush, apply a lighter white-silver eyeshadow and then use dark black eyeliner along the line of your eye. Use silver glitter along your eyelids in a few layers and black layer on the outside of your eyelids for that perfect festive New Year's look.
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.
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 often done poorly. In this, the first installment of his series on practical apple tree pruning, Stephen Hayes of Fruitwise Heritage Apples looks at the general structure of the apple tree.
How to keep your pansies healthy year round
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!
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.
In China and Japan there exists a special zodiac quite different from that which we have in the states. The Chinese zodiac consists of twelve animals, each animal representing one year in the constant twelve year revolution.
In China and Japan there exists a special zodiac quite different from that which we have in the states. The Chinese zodiac consists of twelve animals, each animal representing one year in the constant twelve year revolution.
We know that December 31st may seem like old news now, but for the Chinese the New Year is just getting started. Chinese New Year begins on February 3rd and ushers in the Year of the Rabbit.
Your New Year's party guests will swear these are the real thing and perhaps even pick one up to pour some Chardonnay in if you're not careful! This origami tutorial shows you how to fold realistic - and damn cute - martini glasses.
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to build a pivot table to calculate year over year sales showing percentage change.
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.
Add a party favor to your next hosted New Year's Eve bash. Ring in the New Year wearing personalized party glasses! It's a fun project for kids and adults.
Check out this Spanish language video that shows you how to say the months of the year in Spanish. This video covers months and some useful phrases dealing with numbers and months. Practice your Spanish language skills and improve your pronunciation of the months of hte year in Spanish with this instructional language video. Hope it's helpful.
What would a New Year's Eve party be without alcohol? Well, it certainly wouldn't be a party. Get your party juices flowing by juicing up with this perfect gin martini.
Corn is the staple of American agriculture, and fresh corn is a delicious treat. If you want to be able to enjoy fresh corn year-round without paying for imported crops, watch this video. It will show you how to freeze corn and keep it fresh all year.
Lemons have been keeping away scurvy for hundred of years because of their long rotting time, but did you know you can preserve them so that they last for a year? This video will show you how to do it. Preserved lemons are great for Moroccan cooking.
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!
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...
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 ...
Learn how to make a papier mâché mask. Make a papier-mache mask for Halloween, a masquerade party, Carnival time, or anytime!
Learn how to play "Year 3000" by Jonas Brothers, an acoustic guitar tutorial. Follow along with this demonstration, tabs and lyrics here:
Studying to be a pediatric nurse? Then here is a nursing how-to video that teaches you how to assess a five year old's medical condition. Every nurse should know the basics of this technique, follow along and see how easy it is to read a five year old's vital signs. These medical tips are sure to help you pass your nursing exam with flying colors.
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.
Back in the '40s through the '60s, it took very little effort for gorgeous starlet Audrey Hepburn to start new trends. Whether she was sporting a short pixie cute (as in "Roman Holiday") or wearing buggy sunglasses (vide "Breakfast at Tiffany's"), Hepburn was always on the cutting edge.
We realize Christmas is over, but there's no reason you shouldn't surprise a friend with a pretty gift for New Year's Eve! In many other cultures friends and family give each other presents to celebrate their new year, including during Chinese New Year.
Ke$ha's music video for "We R Who We Are" is the perfect combination of extreme glitziness (studded eyebrows and glitter littering every corner as well as Ke$ha's face) and extreme party scene gritiness.
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-array formula.
Does the sound of the vuvuzela fire up your passion like it does for the South Africa supporters at this year's World Cup? Do you wish you could hear their divine drone more often? This video will teach you how to create a vuvuzela-like sound using common household items: a balloon and some hex nuts. If you can't get the real thing, this will be a good substitute if you think your life needs a little more noise.
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.
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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
For all your origami enthusiasts, take your art of origami to greater heights by using a dollar bill to create the impossible—fireworks! In this two-part video tutorial, learn how to fold origami fireworks from a single dollar bill. It's a great origami project for the 4th of July or New Year's Eve.
Thinking you need a little boost in the bra department for this year's Christmas card? Here is a tutorial on how to make your breasts appear larger using Photoshop.
Brian Brushwood reveals the techniques used to make super-realistic fake tongues, like those used in last year's Halloween Horror Nights show. Brian Brushwood on The Road shows how to make fake tongues to use for the magic illusion 'Sword through the Tongue' trick. He's performed this in his stage show at Universal Studios in Orlando.
Make sure this year’s live holiday Christmas tree is not only pretty, but safe, too. Here's how to safely put up a real, live Christmas tree. You will need:
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...
So 2000 was a wash for an election year; we put up with W for four years, then what happened? 2004! Lost again!!! Diebold you just can't seem to fade.
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...
Summer is almost over and that means the end of summer vacation and the start of the new school year. During this transition, parents and students get ready for the new year by purchasing a variety of different materials. Pencils, paper, books, testing sheets, etc.